Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle DBA Advanced Topics

© 2007-2016 by Burleson Corporation


This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring


Key Features

* Learn SQL Optimization.

* Look inside Oracle Optimizers.

* Learn SGA Tuning.

* Understand advanced database administration.


Course Description

Oracle DBA Advanced topics is an intensive three day course intended to introduce the Oracle DBA to system internals and advanced database administration.  Topics will focus on SQL optimization internals, SGA internals, and advanced DBA administration and tuning topics.

Book Required

  Oracle High-Performance SQL Tuning

Donald K. Burleson

Oracle Press, 2002

ISBN: 0072190582

  Creating a Self-Tuning Oracle Database
Automating Oracle9i Dynamic SGA Performance

Donald K. Burleson

Rampant TechPress, 2007

ISBN: 0-9727513-2-7


This course is designed for practicing Oracle professionals who have basic experience with Oracle database administration and wish to advance their skills in advanced topics.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledge leader in Oracle database administration.  Author or more than 20 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson has over a decade of real-world DBA experience in Oracle features and shares his Oracle secrets in this intense Oracle training.


Oracle DBA Advanced Topics

© 2007-2016 by Donald K. Burleson

Day 1: SQL Optimization
Inside the Oracle Optimizers
  • The “best” execution plan (first_rows vs. all_rows) - (page 129-130)
  • Rule-based optimization - (page 129)
  • Cost-based optimization - (page 334)
  • Gathering statistics - (page 340)
  • Using histograms - (page 279, 305)
  • When the optimizers fail - (page 85)
  • Exercise – Change the optimizer mode

Table joining internals

  • Sort-merge joins - (page 341)
  • Nested Loop joins - (page 401)
  • Hash joins - (page 390-392)
  • STAR joins - (page 401)
  • Bitmap joins - (page 291)
  • Exercise – Change table join techniques & evaluate performance

Oracle Index Optimization

  • B-Tree indexes  - (page 233)
  • Bitmap Indexes  - (page 80, 127)
  • Function-based Indexes - (page 36, 61)
  • Clustered indexes - (page 87)
  • Index-only tables - (page 468)
  • Exercise – Create and use bitmap index

 Day 2: SGA Tuning

Inside the Shared pool

  • Shared Pool Internals
  • Using the library cache
  • Using cursor sharing
  • Implementing optimizer plan stability
  • Monitoring the shared pool
  • Monitoring the library cache
  • Using shared pool advice



  Oracle sorting internals
  • Sorting vs. index access
  • Sorting in sort_area_size
  • Sorting with the multi-threaded server
  • sorting with pga_aggregate_target

Oracle data buffer management

  • Internals of data buffer RAM
  • Using the KEEP pool
  • Using the RECYCLE pool
  • Defining multiple blocksize buffers
  • Monitoring the data buffers

Day 3: Advanced database administration

Inside the Data Dictionary structure

  • Querying against the fixed x$ tables
  • Queries with the v$ views
  • Queries using the DBA dictionary views

Oracle monitoring with STATSPACK

  • Basics of proactive tuning
  • Installing STATSPACK
  • Collecting data with STATSPACK
  • Using STATSPACK for exception reporting
  • Using STATSPACK for trend analysis

Oracle Internals

  • Automated segment space management (bitmap freelists)
  • Using multiple freelists and freelist groups
  • Managing space fragmentation
  • Using online reorgs
  • defining external tables to read OS flat files
  • Creating a self-tuning database
  • Using multiple blocksizes
  • Using advanced indexing (function-based and bitmap indexes)



Please note that while the knowledge gained from this Oracle training may be valuable when preparing for Oracle certification exams, the content of this course is not for Oracle Certification, including the Certified Professional (OCP) or Oracle Certified Associate (OCA) programs.

This is a BC Oracle training course (c) 2007-2016

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational