Oracle 11g Database Administration II (OCP) - OCP800
This Oracle DBA training course is designed to arm the Oracle database administrator professional with the tools necessary to build a solid foundation for the OCP exam. This 5-day course is designed to provide Oracle professionals the tips, concepts and techniques required to pass the OCP exam on your first attempt.
This Oracle DBA training course features labs designed to help the student demonstrate and gain practical experience with the Oracle DBA concepts required to pass the Oracle OCP exam.
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.
Take this Oracle training class to get beyond a the basic understanding of the Oracle environment and learn the more advanced skills required to effectively configure, administer, monitor and tune the database within a large-scale enterprise.
This Oracle DBA training course features labs designed to help the student demonstrate and gain practical experience with the Oracle DBA concepts required to pass the Oracle OCP exam.
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.
Take this Oracle training class to get beyond a the basic understanding of the Oracle environment and learn the more advanced skills required to effectively configure, administer, monitor and tune the database within a large-scale enterprise.
Course ID: OCP800
Duration: 5 days
Audience: Oracle Database Administrators
Prerequisites: Basic SQL knowledge
Topics:
Managing Memory
- About Manual Memory Management
- Automatic Memory Management
- MEMORY_TARGET
- MEMORY_MAX-TARGET
- SGA_TARGET
- SGA_MAX_SIZE
- WORKAREA_SIZE_POLICY and PGA_AGGREGATE_TARGET
- Using EM and The Memory Advisors
- Monitor In Memory Access Mode
Managing Storage and The Segment Advisor
- Monitor Tablespaces
- About Resumable Space Allocation
- Table Storage Management
- Pctfree Illustrated
- Use The Segment Advisor
- Using The Shrink Space Option
- Cascade To Dependent Objects
- Optionally Call Delete_Task()
Managing Resources
- Database Resource Manager Architecture
- Consumer Groups
- Resource Plans
- Automatic and Adaptive Consumer Group Mapping
- Activating Plans
- Monitoring Resource Allocation
- Explicit Consumer Group Switching
Automating Tasks With The Scheduler (Basic)
- Scheduler Architecture
- RAC Environment
- Manage Programs
- Manage Schedules
- Manage Jobs
Automating Tasks With The Scheduler (Advanced)
- Manage Job Classes
- Manage Windows and Window Groups
- Manage Chains
- About Events and The Scheduler
Globalization
- Globalization Settings
- NLS_LANG
- NLS_LANGUAGE and NLS_TERRITORY
- Date and Time Localization
- Linguistic Indexes
- About Locale Builder
Diagnosing Database Problems
- About The Fault Diagnosability Infrastructure
- ADR Highlights From EM
- Using The Alert Log
- About The Trace Files
- Database Instance Health Snapshot
- Using The Support Workbench
- Enable Oracle Configuration Manager
Automatic Storage Management
- ASM and The Broader Database Architecture
- Creating The ASM Instance
- Administering The ASM Instance
- SYSASM Super Administrator
- ASM Storage Parameters
- Using DBCA
- Using ASMCMD
- Configuring Databases For ASM Storage
- DBCA
- DBUA
- ASM Migration
- Using EM
Recovery Concepts
- About The Backup and Recovery Structures
- Managing Redo Data
- Is LOG_BUFFER Large Enough?
- What V$LOG Reveals
- What V$LOG_HISTORY Reveals
- What V$LOGFILE Reveals
- What V$ARCHIVED_LOG Reveals
- Managing Archived Redo Data
- Archivelog Status
- Creating A Foundation For Sound Recovery
Oracle Flashback Technology
- About Flashback Technology
- Flashback Query
- Select...As Of Timestamp
- Select...As Of SCN
- Using DBMS_FLASHBACK()
- Configuring Undo Management For Flashback
- UNDO_RETENTION
- Flashback Table
- Flashback Drop
- Flashback Versions Query
- Flashback Transaction Query
- Flashback Transaction Backout
Flashback Database
- About Flashback Database
- Configuring The Flash Recovery Area
- More About DB_RECOVERY_FILE_DEST
- Performing Database Flashback
- Monitoring Flashback Performance
- Flashback Database Considerations
- Configure Flashback Data Archive
Instance Recovery
- About Instance Recovery
- SMON Process and Instance Recovery
- PMON Process and Process Recovery
- Instance Recovery Parallelism
- Changing Recovery_Parallelism
- MTTR Advisor and Tuning Checkpoints
- LOG_CHECKPOINTS_TO_ALERT
- Redo Logfile Size Advisor
- Fast-Start On-Demand Parallelism
Configuring RMAN