Oracle 11g DBA  Online Training

Oracle Certification Training
Database Administration

Table of Contents

Architecture

  • 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

Database Creation

  • 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

Renaming a Datafile

Space/Storage Management

  • Storage Parameters
  • Segments, Extents, Blocks

UNDO Management

  • States of UNDO

Flashback Technologies

  • Flashback Query
  • Flashback Drop Table
  • Flashback Versions Query
  • Flashback Transaction Query

Server Parameter (SP) File Creation

Oracle Managed Files (OMF)

Networking

Control File Management

  • Multiplexing of Control File

Redolog File Management

Renaming an Instance

  • States of Redolog File
  • Adding of new log member, log group
  • Dropping a log file

Archivelog Management

Dropping a Database

Backup and Recovery

  • Physical Backups – Cold, Hot
  • Logical Backups – Export, Import
  • Data Pump
  • Recovery Manager(RMAN)

Database Reorganization

Transportable Tablespace

Performance Tuning

  • SQL Tuning
  • Memory Tuning
  • Explain Plan
  • TKPROF
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)

Automatic Storage Management (ASM)

Oracle Installation on Oracle Enterprise Linux

Oracle Enterprise Manager (OEM)

Renaming a Database

Row Migration

Row Chaining

Quick Entry