||Oracle Tips by Burleson
Advanced Oracle DBA Topics
This tutorial introduces advanced topics for
the Oracle database administrator. As an introduction to advanced
topics, the student will be exposed to Oracle 10g external tables and
an overview of Oracle database internal tuning.
The primary focus on this tutorial will be on
advanced features. We will look at the object-oriented relational
features of the Oracle 10g database, and the student will learn basic
object-oriented concepts, including polymorphism, inheritance,
encapsulation, and understand how these features can be applied within
Oracle. Specific object-oriented topics within Oracle will include
abstract data typing, varray tables, nested tables, and the use of
pointers as navigational tool within object-oriented Oracle databases.
The Themes for this tutorial examine Oracle
10g undocumented features, specifically the hidden parameters and the
x$ fixed tables, and we will also gain experience in defining and
loading an external table.
Upon completion of this tutorial, you will be
* Define and query Oracle 10g external tables
* Explain uses for Oracle Database
* Understand the Oracle 10g online
* Query against the x$ fixed views
* Locate undocumented Oracle parameters
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.