Course Length - 5 Days

Objectives of This Course
This course reviews all of the major administration features and improvements introduced with Release 1 and Release 2 of the Oracle database version 10g. Students will be able to apply their experience with previous releases of the Oracle database to this new release, which offers numerous productivity and manageability improvements. Within this course, students will learn how to:
• Install and initially configure, or upgrade an Oracle 10g database.
• Load and unload data between databases using the Data Pump architecture.
• Enable and configure automatic database management.
• Utilize advanced self-tuning and self-management capabilities, including the use of the database Advisors and other components of the Management Framework.
• Take advantage of the new recovery features available from flashback, flashback database, the flash recovery area and RMAN enhancements.
• Enable and use general storage management enhancements and incorporate the powerful new automatic storage management (ASM) option.
• Work within the changed Enterprise Manager (EM) interface and the database control.

Curriculum Note
Many additional new features introduced in Oracle 10g are also discussed in the following Dashcourses International courses:
• The Dashcourses International course ORACLE DATABASE 10G: NEW & ADVANCED FEATURES FOR DEVELOPERS
• The Dashcourses International course ORACLE DATABASE 10G: SQL TUNING

Target Audience
The target audience for this course is database administrators with experience using Oracle 9i, wanting to learn about the new and modified features introduced in Oracle 10g.

Course Prerequisites
The mandatory prerequisite for this course is extensive experience administering an Oracle database using version Oracle 9i. Those who lack such experience would be better served by completing the curriculum for new database administrators comprising the following Dashcourses International course modules:
• ORACLE DATABASE 10G: ADMINISTRATION I
• ORACLE DATABASE 10G: ADMINISTRATION II

Suggested Next Courses
Administrators may wish to obtain additional experience in the operating system platform on which their Oracle databases have been deployed. This is available from the Dashcourses International curricula for MS Windows Server, Linux and UNIX. As alluded to above, the following Oracle courses are suggested to follow this course:
• ORACLE DATABASE 10G: SQL TUNING
• ORACLE DATABASE 10G: DATA WAREHOUSES
• ORACLE DATABASE 10G: IMPLEMENT PARALLEL SQL & PARTITIONING