Oracle 11g DBA Online Training

Course Duration : 60 Hrs

Oracle 11g DBA Course Content

• Architecture
  

1. Physical Structure
   
   
2. Logical Structure


3. Memory Structure


• System Global Area(SGA)
  
  
• Program Global Area(PGA)
  
  
4. Background Processes


5. Oracle Server


6. SQL Statement Execution
   

• Startup and Shutdown Modes

• Database Creation

1. Manual Script
   
   
2. Oracle Managed Files(OMF)
   

• Tablespace Management
  
  
  1. Types of Tablespaces
     
     
  2. Status of Tablespaces
     
     
  3. Modes of Tablespaces
     
• User Management

1. User Creation
   
   
2. Privileges
   
   
3. Roles
   
   
4. Quota
   
   
5. Profile

• Renaming a Datafile

• Space/Storage Management

1. Storage Parameters
   
   
2. Segments, Extents, Blocks

• UNDO Management

• Flashback Technologies

1. States of UNDO
   

• Server Parameter (SP) File Creation
  
  1. Flashback Query
     
     
  2. Flashback Drop Table
     
     
  3. Flashback Versions Query
     
     
  4. Flashback Transaction Query
     
• Oracle Managed Files (OMF)
  
  
• Networking
  
  
• Database(DB) Links
  
  1. Types of DB Links
• Materialized Views
  
  1. Refresh Options
     
     
  2. Multiplexing of Control File
     
• Control File Management
  
  1. Multiplexing of Control File
     
     
  2. States of Redolog File
     
     
  3. Adding of new log member, log group
     
     
  4. Dropping a log file
     
     
• Control File Management
  
  
• Redolog File Management
  
  
• Redolog File Management
  
  
  1. States of Redolog File
     
     
  2. Adding of new log member, log group
     
     
  3. Dropping a log file
     
     
• Archivelog Management
  
  
• Dropping a Database
  
  
• Backup and Recovery
  
  
  1. Logical Backups - Export, Import
     
     
  2. Physical Backups - Cold, Hot
     
     
  3. Data Pump
     
     
  4. Recovery Manager(RMAN)
     
     
  5. Recovery Scenarios
     
     
• Database Reorganization
  
  
• Transportable Tablespace
  
  
• Performance Tuning
  
  
  1. Memory Tuning
     
     
  2. Explain Plan
     
     
  3. TKPROF
     
     
  4. Automatic Workload Repository (AWR)
     
     
  5. Automatic Database Diagnostic Monitor (ADDM)
     
     
• Automatic Storage Management (ASM)
  
  
  1. Cold Backup
     
     
  2. RMAN
     
     
• Database Cloning
  
  
• Oracle Installation on Red Hat Linux
  
  
• Oracle Enterprise Manager (OEM)
  
  
• Renaming a Database
  
  
• Row Chaining and Row Migration
  
  
• Data Guard
  

1. Protection Modes
   
   
2. Physical Standby
   
   
3. Logical Standby
   
   
4. Snapshot Standby
   
   
5. Active Data Guard
   
   
6. Switchover and Failover