 |
|
Oracle Concepts by Burleson
Consulting |
Basic SQL
Data Access
This tutorial
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.
Learning Outcomes
Upon completion of this tutorial, you will be
able to:
-
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:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
