||Oracle Concepts by Burleson
introduces the process of parsing SQL statements and the generation of
SQL execution plans within the library cache.
Topics will include a
review of RAM regions for SQL and PL/SQL, and an overview of how to
adjust the behavior of SQL code within the library cache. We will be
examining data dictionary views that can show us the behavior of SQL
statements, and you will perform hands-on exercises in querying the
dictionary. We will also explore important techniques for improving
the speed of SQL processing, including stored outlines, cursor
sharing, peeking and automated query re-write.
We will also see how
Oracle can change SQL execution plans for materialized views and the
remove certain forms of inefficient SQL subqueries.
Upon completion of this tutorial, you will be
Create SQL subqueries
Perform SQL aggregation
Understand SGA memory regions for SQL and PL/SQL processing
Adjusting how the Oracle database processes SQL and PL/SQL
Monitoring SQL re-parsing
Using cursor sharing with SQL
Implementing SQL peeking
Using stored outlines (optimizer plan stability) with SQL
Learn to use automated SQL query re-write
For more details, see the "Easy
Oracle Series" a set of books especially designed by Oracle
experts to get you started fast with Oracle database technology.
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA