This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise. Subjects include:

• Automatic database management, monitoring and tuning facilities. Included are automatic management of storage space and memory resources within the database and the role of the Segment Advisor and Memory Advisors.
• Automatic resumption of database operations even in the face of storage space allocation failures and errors.
• Setting metric and alert thresholds for proactive database monitoring.
• Using deferred segment creation to improve performance and establish efficient use of space.
• Globalization features within the database to support applications in multiple languages, currencies, time zones and countries.
• Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure, the Database Instance Health monitor and the Support Workbench to capture and process fault data.
• Configuring the database to recover from a wide variety of failures. This includes configuring redo log files and the Flash or Fast Recovery Area.
• Using Oracle flashback technology to recover from user errors and from database failures, including Flashback Data Archive and Flashback Transaction Backout as part of the Oracle Total Recall technology.
• Perform other flashback operations, including Flashback Version Query, Flashback Transaction Query and Flashback Database.

Oracle Training Audience

The primary target audiences for this course are:

• Database administrators
• Web server administrators
• System administrators
• Implementation specialists
• Data center support engineers
• Senior application designers and developers

Oracle Training Certification

This course along with its prerequisites cover information necessary to complete the certification test ORACLE DATABASE 11g: ADMINISTRATION II.

Oracle Training Prerequisites

Many students taking this course have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory. Specific course prerequisites for this course are these titles:

• ORACLE DATABASE 11G R2: SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11G R2: PL/SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11G R2: ADMINISTRATION I

Suggested Next Courses

Administrators may wish to proceed onto more focused and specialized courses with these modules:

• ORACLE DATABASE 11G R2: GRID INFRASTRUCTURE & ASM
• ORACLE DATABASE 11G R2: PERFORMANCE TUNING
• ORACLE DATABASE 11G R2: SQL TUNING
• ORACLE DATABASE 11G R2: ENCRYPTION & ADVANCED DATA SECURITY
• ORACLE ENTERPRISE MANAGER 11G R2: GRID CONTROL

Oracle Training Course duration

3 Days

Oracle Training Course outline

MANAGING MEMORY

• ABOUT ADVANCED ADMINISTRATION
• ABOUT MANUAL MEMORY MANAGEMENT
• AUTOMATIC MEMORY MANAGEMENT
• MEMORY_TARGET
• MEMORY_MAX_TARGET
• SGA_TARGET
• SGA_MAX_SIZE
• WORKAREA_SIZE_POLICY & PGA_AGGREGATE_TARGET
• USING EM & THE MEMORY ADVISORS
• MONITOR IN MEMORY ACCESS MODE

MANAGING STORAGE & THE SEGMENT ADVISOR

• MONITOR TABLESPACES
• ABOUT RESUMABLE SPACE ALLOCATION
• TABLE STORAGE MANAGEMENT
• USE THE SEGMENT ADVISOR

GLOBALIZATION

• GLOBALIZATION SETTINGS
• NLS_LANG
• NLS_LANGUAGE & NLS_TERRITORY
• DATE & TIME LOCALIZATION
• LINGUISTIC INDEXES
• ABOUT LOCALE BUILDER

DIAGNOSING DATABASE PROBLEMS

• FAULT DIAGNOSABILITY INFRASTRUCTURE
• USING THE ALERT LOG
• ABOUT THE TRACE FILES
• DATABASE INSTANCE HEALTH SNAPSHOT
• USING THE SUPPORT WORKBENCH
• ENABLE ORACLE CONFIGURATION MANAGE

RECOVERY CONCEPTS

• THE BACKUP & RECOVERY STRUCTURES
• ORACLE SECURE BACKUP
• MANAGING REDO DATA
• MANAGING ARCHIVED REDO DATA
• CHECKLIST FOR SOUND RECOVERY

ORACLE FLASHBACK TECHNOLOGY

• ABOUT FLASHBACK TECHNOLOGY
• SELECT...AS OF TIMESTAMP
• SELECT...AS OF SCN
• UNDO MANAGEMENT FOR FLASHBACK
• UNDO_RETENTION
• FLASHBACK TABLE
• FLASHBACK DROP
• FLASHBACK VERSIONS QUERY
• FLASHBACK TRANSACTION QUERY
• FLASHBACK TRANSACTION BACKOUT

FLASHBACK DATABASE & FLASHBACK DATA ARCHIVE

• ABOUT FLASHBACK DATABASE
• CONFIGURING THE FLASH RECOVERY AREA
• PERFORMING DATABASE FLASHBACK
• MONITORING FLASHBACK PERFORMANCE
• FLASHBACK DATABASE CONSIDERATIONS
• CONFIGURE FLASHBACK DATA ARCHIVE

---

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved