ORACLE DBA

Oracle 11g DBA Course Contents

Introduction to Database

• 1. Different Types of Databases
• 2. Oracle 9i/10g/11g Features
• 3. Responsibilities of a DBA

Oracle Architecture

• 1. Physical Structure
• 2. Logical Structure
• 3. Instance
• 4. System Global Area - SGA
• 5. Program Global Area - PGA
• 6. Background Processes

Database Creation

• • 1. DB creation steps
  • 2. SYSAUX Tablespace

Tablespace Management

• 1. Additional Tablespaces
• 2. Advantages of having different tablespaces
• 3. Types of tablespaces
• 4. Bigfile tablespace
• 5. Temporary tablespaces

Storage Parameters

• 1. Automatic Segment Space management
• 2. Data Dictionary Views

Undo Management

• 1. Rollback Segments
• 2. Undo Management
• 3. Undo retention
• 4. Steps to create and maintain Undo tablespace
• 5. Retention Guarantee

Managing Redo log files

• 1. Introduction
• 2. Mirrored Redo Logs
• 3. Log Switches
• 4. Data Dictionary Views

Managing Control Files

• 1. Introduction
• 2. Managing the Size of Control File
• 3. Data Dictionary Views you can query

Archived Redo Log Files

• 1. Introduction
• 2. Converting Database into Archive Log Mode
• 3. Oracle managed files - Introduction
• 4. Main Benefits of the OMF

Managing Users and Resources

• 1. Managing database Users
• 2. Creating Users
• 3. Managing Resources and Profiles
• 4. Session and User Licensing
• 5. User Authentication

Managing User Privileges and Roles

• 1. Identifying User Privileges
• 2. Categories of Privileges
• 3. Managing User Roles
• 4. Listing Privilege and Role Information

Schema Management

• 1. Visible and Invisible Indexes
• 2. Read Only Tables
• 3. DDL Wait Option
• 4. Virtual Columns
• 5. Table Compression
• 6. Basic Compression
• 7. OLTP Compression

Security

• 1. Tablespace Encryption
• 2. Create wallet
• 3. Create directory structure
• 4. Creating Wallet Key
• 5. Case Sensitive Passwords

Auditing

• 1. Introduction
• 2. Parameters for Auditing
• 3. Types of Auditing
• 4. Data dictionary views for Auditing

Managing Oracle Networking - Net Manager

• 1. Introduction
• 2. Configuring Listener.ora,tnsnames.ora
• 3. Database Links
• 4. Materialized Views

Managing Exports and Imports

• 1. Main Tasks of Export and Import
• 2. Incremental, Cumulative and Complete Exports
• 3. Import Parameters
• 4. Introduction to Data pump
• 5. Export by using Data pump
• 6. Import by using Data pump

Managing Backups and Recovery

• 1. Cold Backup
• 2. Hot Backup Types
• 3. Various Recovery scenarios

Recovery Manager

• 1. Introduction
• 2. RMAN Commands
• 3. Types of RMAN backups - Full, Incremental Backups
• 4. Compressed Backups
• 5. Various Recovery scenarios by using RMAN

RMAN Enhancements

• 1. Data Recovery advisor
• 2. Proactive health checks
• 3. Virtual private catalog
• 4. Configuring the backup compression Algorithm
• 5. Duplicate Command

Memory Management

• 1. Introduction
• 2. Dynamic System Global Area (SGA)
• 3. Buffer Cache Advisory
• 4. Automatic Memory Management
• 5. Execution Plan Steps
• 6. Types of Traces
• 7. Automatic Workload Repository (AWR)

Tuning - The performance of the Database

• 1. Introduction
• 2. Goals of Tuning
• 3. Tuning Process steps
• 4. Tuning Memory, I/0, Contention,Parallel Query Option
• 5. Online Segment Shrinking

Shared Servers, Partitioned Tables and Indexes

• 1. Managing Partitioned Tables
• 2. Advantages of Partitioned Tables
• 3. Types of Partitioned
• 4. Managing Partitioned Tables
• 5. Client Process, Server process
• 6. Dedicated server Process
• 7. Shared server process

Flash Back Technology

• 1. Flash Recovery Area
• 2. Flash back query, Table
• 3. Flash Back Database
• 4. Drop a table and Undo by using flashback database

Dataguard

• 1. Types of Stabdby
• 2. Configuration of Dataguard
• 3. Active dataguard
• 4. Steps to create and maintain Standby

Automatic Storage Management(ASM)

• 1. Introduction to ASM
• 2. Disk group
• 3. Fast Mirror Resync
• 4. Oracle ASMCA
• 5. ASMCA Commands and options

Others

• 1. Introduction to Real Application Clusters (RAC)
• 2. Database Refresh Steps
• 3. Introduction to Unix Commands
• 4. Managing Databases for SAP Applications
• 5. Steps for Interview
• 6. Incident Management, Change Management
• 7. Interview questions
• 8. Steps for Resume preparation