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.
two-day seminar is designed for practicing database administrators
(not exclusively Oracle DBAs) 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.
practicing Oracle DBA are not aware of some of the new features
that were introduced in Oracle8i and Oracle9i for database tuning
You Will Learn
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.
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.
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