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 9i Features, Database Administration & Tuning

© 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

* Understand Oracle’s Internal Structures.

* Use Oracle’s Explain Plan Facility.

* Understand the Two-Phase Commit.

* Determine Where To Place Indexes.

* Use Oracle 7.3’s Features With Data Warehouses.

* Build The Oracle Performance Database.

* Tune the DLM.


Course Description

This two-day seminar is designed for practicing database administrators (not exclusively Oracle DBA’s) who want to understand the concepts behind advanced Oracle9i features, database administration and tuning. This class will assume a functional knowledge of database tuning, and will delve into the Oracle-centric techniques for tuning very-large Oracle databases.

What's Happening?

Many practicing Oracle DBA are not aware of some of the new features that were introduced in Oracle8i and Oracle9i for database tuning and administration.

What You Will Learn

The first day of this seminar will introduce the advanced concepts of Oracle9i administration, including Oracle parallel query, Real Application Clusters, tuning Oracle SQL, as well as techniques for determining the overall health of an Oracle database.

Day two will cover the specific new features of Oracle9i and show how they can be used to effectively tune and administer an Oracle environment. Topics will include Oracle WebServer administration, Oracle bitmapped indexes, STAR schema queries, Partitioned tables, the Oracle object layer, and other miscellaneous topics.

Book Required

  • N/A


This course is designed for the working Oracle professional and the amount of previous experience with Oracle is incidental.
Previous experience with relational database management and SQL is helpful, but this class is self-contained and has no formal prerequisites.

Curriculum Design

This course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of 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 Oracle9i new features training.

Oracle9i Features, Database Administration & Tuning

© 2007-2016 by Donald K. Burleson


Day One:
Tuning The Oracle9i Architecture (3 hours) 
  • Oracle’s Internal Structures
  • Oracle Metadata: the V$ Tables
  • Tuning Oracle Memory
  • Sizing The SGA 
  • Using The db_block_size Parameter With db_file_multiblock_read_count
  • Tuning Oracle Sorting 
  • The Oracle PGA 
  • Tuning The shared_pool_size
  • Tuning The Dictionary Cache 
  • Multithreaded Server Tuning  
  • Tuning The db_block_buffers Parameter
  • Predicting The Benefit Of Additional Block Buffers
  • Memory Cache Tuning  
  • Simulating The Pinning Of Database Rows 
  • Interoperability Facilities 
  • Creating Batch-Oriented Oracle Instances
  • I/O-Based Tuning  
  • Disk Striping  
  • Tuning Data Fragmentation 
Tuning Oracle SQL  (2 hours)
  • Tuning Oracle SQL Syntax
  • General Tips For Efficient SQL 
  • Tuning SQL With Indexes  
  • Concatenated Indexes  
  • Using Oracle’s Explain Plan Facility 
  • Using Temporary Tables  
  • Tuning With The Rule-Based Optimizer 
  • Using Hints With The Cost-Based Optimizer
  • Tuning PL/SQL  
  • Using Oracle Stored Procedures And Triggers 
  • Simulating Object-Orientation  
  • Inheritance  
  • Abstraction  
  • Pointer-Based Navigation 
  • Invoking Methods In SQL 
  • Using ODBC As A Server Interface 
Tuning Oracle Locking  (2 hours)
  • Database Deadlocks 
  • Escalation Of Locks With Non-Oracle Servers 
  • Alternative Locking Mechanisms For Oracle 
  • The WHERE Clause  
  • Locking And Distributed Databases 
  • Understanding The Two-Phase Commit 
  • Measuring Oracle Locks  
  • Identifying Conflicts  
  • Using catblock.sql And utllockt.sql  


Day Two:
Oracle DBA Performance And Tuning  Tricks (3 hours)
  • Using The Unrecoverable Option  
  • Using Read-Only Tablespaces  
  • Determining Where To Place Indexes 
  • Bitmapped Indexes  
Tuning Oracle Data Warehouse And OLAP Applications (1 hour)
  • Data Aggregation And Drill-Down 
  • Oracle Solutions To MDDB  
  • Populating Star Schemas With Distributed SQL  
  • Aggregation, Roll-Ups, And Star Schemas  
  • Alternatives To Cubic Data Representation  
  • Using Oracle 7.3’s Features With Data Warehouses  
  • Parallel Query For Data Warehouses  
  • Star Query Hints And Star Joins With Oracle 7.3
  • Using Oracle’s Bitmap Indexes  
  • Using Oracle 7.3 Hash Joins  
Oracle Application Monitoring (1 hour)
  • Proactive Vs. Reactive Measuring Techniques  
  • Creating An Oracle-Based Monitor  
  • Gathering The Oracle Performance Statistics 
  • Creating A Performance Repository With Oracle Utilities 
  • Using Oracle utlbstat And Outlets Utilities  
  • What Oracle Statistics Do We Want To Collect? 
  • Building The Oracle Performance Database  
  • Local Oracle Processing  
  • cron Run Schedules  
  • Performance Reports
  • Online Menu For The Performance System 
  • Running The Oracle Reports And Alerts
Real Application Clusters (RAC) - 2 hours
  • Basic RAC concepts
  • Tables and freelist groups
  • Tuning the DLM
  • Parallel recovery


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.


We also offer Oracle9i new features training classes.

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