Oracle 11g DBA Online Training


Oracle 11g DBA Online Training Course Details

Oracle 11g DBA Online Training Course Content

  • Architecture
    1. Physical Structure
    2. Logical Structure
    1. Memory Structure
      • System Global Area(SGA)
      • Program Global Area(PGA)
    1. Background Processes
    1. Oracle Server
  1. 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