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 







Oracle9i New Features Training

© 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

Don't forgetsupplemental mentoring


Key Features

* Learn about external tables.

* See new Oracle9i SQL features.

* Understand multiple blocksizes.

* See important new init.ora parameters.

* Understand online table reorganization.

* Focus on the important new Oracle9i features.


Course Description

This is an intensive 3-day Oracle9i new features overview.  This course is a comprehensive overview of Oracle9i taught by a highly experienced Oracle professional.

Unlike mediocre Oracle9i new features training, this course examines all Oracle9i new features with an eye on those features that are the most important to Oracle9i availability, Oracle9i performance and Oracle9i development.

This hand-on Oracle9i new features training is special because this course is taught by a veteran Oracle Certified DBA with more than 20 years of full-time experience.

Book Recommended

  Oracle9i New Features

Robert Freeman

Oracle Press

ISBN: 0072223855


This course is designed for practicing Oracle professionals who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.

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 Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle new features training.

Oracle9i New Features

© 2007-2016 by Donald K. Burleson


          1 - Overview of Oracle9i new features
  New Administration Features

           2 – Oracle9i managed files (OMF)
       Oracle9i db_create_file_dest parameter
       Exercise – Create Oracle9i OMF tablespaces and data files
2 – Oracle9i online reorg
        Exercise – Online reorg for pubs database
 3 – Oracle9i Multiple blocksizes
          Exercise – Create tablespaces with multiple blocksizes
4 – Oracle9i SGA memory management
5 – Oracle9i Automated undo management
5 - Oracle9i Resumable space management
5 - Managing spfiles in Oracle9i
6 - Oracle9i Virtual private databases
6 - Oracle9i Fine-grained auditing
6 - Oracle9i Database flash freeze
Oracle9i Architecture Changes
1 - Oracle9i Flashback query
2 - Oracle9i Logminer
3 - Oracle9i Fast-start recovery
 3 - New Oracle9i RMAN features
 3 - Oracle9i Data Guard
4&5 - Object/relational enhancements in Oracle9i
             Inheritance, ADTs
             Exercise – Create an ADT
Oracle9i VLDB features
             6 - Oracle9i Multi-table inserts
                         Exercise – Create multi-table inserts
             6 - Oracle9i Merge statements - Upserts
                          Exercise – Create an upsert statement
             6 - Oracle9i Parallel direct load changes
             6 - Oracle9i list partitioning


Oracle9i SQL
             1 - Oracle9i CASE statement
                      Exercise – Perform Oracle9i CASE statement in SQL
            1 – Oracle9i Explicit defaults
1 – Oracle9i Scalar subqueries
            1 - New joins – cross join, natural join, using and on
            1 - Oracle9i Left and right outer joins
                         Exercise – Perform Oracle9i joins in SQL
            2 - Oracle9i Explicit column value defaults
            2 - Oracle9i New date time BIFs
            2 – Oracle9i External tables
                         Exercise – create an external table

Oracle9i PL/SQL

            3 - Oracle9i Compiled PL/SQL
3 - Oracle9i Common SQL parser
3 - Oracle9i cookie support
3 - Oracle9i PL/SQL Inheritance support
3 - Oracle9i New PL/SQL datatypes

New SQL optimization
4 – Oracle9i Index skip scan
                        Exercise – show index skip scan in action
             4 - Oracle9i Index-only scans on FBIs
Exercise – show index-only FBI scan
 4 - New Oracle9i first_rows_n optimization
5 - New Oracle9i execution plan columns
5 - New Oracle9i statistics gathering
5 - Oracle9i in-memory execution plans in v$sql_plan
            Exercise – Join v$sql_plan and v$session
5 - Improved Oracle9i cursor sharing with peeking
             6 - Evolution of OPS into RAC
             6 - Oracle9i Cache fusion architecture
             6 - Using Oracle9i TAF with RAC



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