Oracle Training Overview

This Oracle 11g courseware training guide book will bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise.

Oracle Training Course Objectives

The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise. Specific subjects to be considered are:

• Specific subjects to be considered are:
• Automatic database management, monitoring and tuning facilities. Included is automatic management of storage space and memory resources within the database.
• Using Oracle flashback technology to recover from user errors and from database failures, including flashback data archive and flashback transaction backout along with the Total Recall capability.
• Controlling resource utilization on database servers whose resource demand exceeds its capacity.
• Automating launching routine maintenance tasks and even application functions using the database Scheduler.
• Handling database corruption.
• Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure to capture fault data.
• Automatic resumption of database operations even in the face of failures and errors.
• User-managed and automatically managed backup strategies and database recovery operations.
• Use advanced Enterprise Manager wizards and tools, including the integrated LogMiner, Flasback Transaction Backout wizard, database Recovery Wizard, and others.
• Automatic Storage Management (ASM) of some or all database files, providing a database-centric and optimized storage subsystem and volume manager