Durasi : 5 hari

1. Introduction
   Oracle Database 10g: The Database for the Grid
   Database Architecture: Review
   Oracle Memory Structures
   Oracle Processes
   Reviewing Oracle Instance Managemen
   Physical Database Structure
   Logical and Physical Database Structures
2. Configuring Recovery Manager
   Backup and Recovery
   Features of Recovery Manager
   Using a Flash Recovery Area with RMAN
   RMAN Usage Considerations
   Starting RMAN 
   Control File Autobackups
3. Using Recovery Manager
   Issuing Recovery Manager Commands  
   Types of RMAN Commands
   BACKUP Command 
   Backup Constraints
   RMAN Backup Types
   LIST Command
   REPORT Command
4. Recovering from Noncritical Losses
   Causes of File Loss
   Losing a TEMPFILE
   Log Group Status
   Losing a Redo Log Group Member
   Re-creating Indexes
   Authentication Methods for Database Administrators
5. Database Recovery
   RMAN Recovery: RESTORE and RECOVER Commands
   Complete Recovery
   Incomplete Recovery
   User-Managed Time-Based Recovery
   User-Managed Cancel-Based Recovery
   Recovering a Control File Autobackup
6. Flashback
   Flashback Drop and the Recycle Bin
   Recycle Bin
   Flashback Database
7. Dealing with Database Corruption
   What Is Block Corruption?
   DBVERIFY Utility  
   ANALYZE Command
   DBMS_REPAIR Package
   Block Media Recovery (BMR)
   BLOCKRECOVER Command
8. Monitoring and Managing Memory
   Memory Management
   Automatic Shared Memory Management15
   How ASMM Works
9. Automatic Performance Management
   Tuning Activities
   Performance Planning
   Instance Tuning
   Dictionary Views
   Advisory Framework
   SQL Access Advisor: Overview
10. Managing Schema Objects
    Table Types
    Creating a Partition
    Index-Organized Tables
    Clusters
    Analyzing Growth Trends
    Managing Optimizer Statistics
    Reorganizing Schema Objects Online 
11. Managing Storage
    Space Management
    Block Space Management
    Row Chaining and Migration  
    Proactive Tablespace Monitoring  
    Thresholds and Resolving Space Problems
    Segment Advisor
    Resuming Suspended Statements
    Transporting Databases
12. Automatic Storage Management
    Automatic Storage Management
    ASM Instance Initialization Parameters
    Database Instance Parameter Changes
    Starting Up an ASM Instance
    Accessing an ASM Instance
    DBCA and Storage Options
    ASM Storage: Concepts
    ASM Files  
    ASMCMD Utility  
13. Managing Resources
    Database Resource Manager
    Assigning Users to Consumer Groups
    Specifying Resource Plan Directives
14. Automating Tasks with the Scheduler
    Simplifying Management Tasks  
    Using a Time-Based or Event-Based Schedule  
    Creating Complex Schedules  
    Creating Job Chains  
    Advanced Scheduler Concepts  
    Creating a Job Class  
    Creating a Window  
15. Database Security
    Oracle Transparent Data Encryption (TDE)
    Transparent Data Encryption: Considerations
    Wallet Support for Usernames and Passwords
    RMAN-Encrypted Backups: Considerations
    Virtual Private Database
    Creating a Column-Level Policy