Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  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

 
 
 

Oracle performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.