Oracle 11g DBA Online Training
Course Duration : 60 Hrs
Oracle 11g DBA Course Content
- Physical Structure
- Logical Structure
- Memory Structure
- System Global Area(SGA)
- Program Global Area(PGA)
- Background Processes
- Oracle Server
- SQL Statement Execution
- Startup and Shutdown Modes
- Manual Script
- Oracle Managed Files(OMF)
- Tablespace Management
- Types of Tablespaces
- Status of Tablespaces
- Modes of Tablespaces
- User Management
- User Creation
- Privileges
- Roles
- Quota
- Profile
- Storage Parameters
- Segments, Extents, Blocks
- States of UNDO
- Server Parameter (SP) File Creation
- Flashback Query
- Flashback Drop Table
- Flashback Versions Query
- Flashback Transaction Query
- Oracle Managed Files (OMF)
- Networking
- Database(DB) Links
- Types of DB Links
- Materialized Views
- Refresh Options
- Multiplexing of Control File
- Control File Management
- Multiplexing of Control File
- States of Redolog File
- Adding of new log member, log group
- Dropping a log file
- Control File Management
- Redolog File Management
- Redolog File Management
- States of Redolog File
- Adding of new log member, log group
- Dropping a log file
- Archivelog Management
- Dropping a Database
- Backup and Recovery
- Logical Backups - Export, Import
- Physical Backups - Cold, Hot
- Data Pump
- Recovery Manager(RMAN)
- Recovery Scenarios
- Database Reorganization
- Transportable Tablespace
- Performance Tuning
- Memory Tuning
- Explain Plan
- TKPROF
- Automatic Workload Repository (AWR)
- Automatic Database Diagnostic Monitor (ADDM)
- Automatic Storage Management (ASM)
- Cold Backup
- RMAN
- Database Cloning
- Oracle Installation on Red Hat Linux
- Oracle Enterprise Manager (OEM)
- Renaming a Database
- Row Chaining and Row Migration
- Data Guard
- Protection Modes
- Physical Standby
- Logical Standby
- Snapshot Standby
- Active Data Guard
- Switchover and Failover