Oracle Architecture

• Instance vs. database
• Components of an Oracle Instance
• Components of an Oracle Database
• Datafiles, Controlfiles and Redo Logs
• Checkpoints , Roll Forward and Rollback
• Redo log concepts, Instance and Media recovery
• Buffer Cache Block Management - LRU List
• SGA vs. PGA
• Background processes

Software and Database Installation

• Unix Kernel Parameters Setup
• Installation of Oracle Software
• Installation Oracle Database using DBCA
• Setting up of Environment
• Startup and Shutdown of the Oracle Database

Init Parameters

• Init parameters
• Displaying init.ora values with v$parameter
• Sizing SGA components
• Shared pool concepts and components
• Overview of PGA for sorting and pga_aggregate_target
• Alteration of Modifiable and Non Modifiable Init parameters vs. Spfile
• Explaining the use of control files
• File locations for control Files
• Obtaining Control File Information
• Multiplexing Control Files
• Convert Database to Archivelog Mode
• Archiving the Oracle Redo Logs

Tablespace Management

• Managing Tablespaces - Create , alter , drop , remane , offline,online , read only , read write
• Creating , Resizing , Renaming , offline Datafiles
• Creating and Managing Temporary Tablespaces and Tempfiles
• Creating and Managing Undo Tablespaces
• Understanding Undo Retention
• Free Space / Used Space in Tablespace
• Troubleshooting Undo – snapshot too old
• Online redo log (log_buffer)
• Dictionary queries

Redo Management , Management of Database Segments

• Redo log switch
• Multiplexing the Online Redo Log Files
• Dictionary and v$ views
• The dba_, all_ and user_ structures
• Querying the tables, indexes, and segments views
• Monitoring the alert log
• Oracle trace/dump files
• Oracle tables : Creation and Maintenance Operations
• Oracle Indexes :
• Creating B*-Tree, bitmap and function-based Indexes
• Oracle Views

Reorg, Users , Roles , Profiles , Privileges

• Reorganize Tables
• Index rebuilding
• Creating New Database Users
• Managing Profiles
• Auditing User activity
• Identifying System and Object Privileges
• Granting and Revoking Privileges
• Creating and Modifying Roles
• Displaying user security Information from the Data Dictionary

Oracle*Net configuration

• Understanding the Listener and how connection takes place from Client to Server
• Use Netca
• Creating the listener.ora file
• Creating the tnsnames.ora file
• Verifying network connectivity with ping and tnsping
• Testing database connection via Listener

Backup & Recovery

• Hot vs. Cold backups
• Backup in Archivelog vs. Noarchivelog Mode
• Taking Cold Backups
• Taking Hot Backups
• Concepts of Hot Backup
• Complete and Incomplete Recovery
• Restoration from cold Backup with complete data loss
• Restoring and Recovering from loss of Datafiles - System and non system ,loss of Read Only Tablespaces
• Loss of Controlfiles
• Loss of Redo Logs - Inactive and Active
• Complete and Incomplete Recovery

Backup and Recovery management using RMAN

• Advantages of RMAN
• Advantages of Catalog over Nocatalog
• Catalog Creation
• RMAN Closed Database and Hot Backups
• RMAN Backup Management (Backup Database , tablespace , Datafile ,controlfile ,archivelogs , spfile)
• Viewing Backups using List
• Configure RMAN(Configure channels , autobackup , tape / disk ,retention Policies)
• Reporting Bacukups
• Restoring and Recovering from loss of Datafiles - System and non system ,loss of Read Only Tablespaces
• Loss of Controlfiles
• Loss of Redo Logs - Inactive and Active
• Complete and Incomplete Recovery

Oracle DBA Utilities

• Imp and exp utilities
• Data pump (impdp and expdp)
• SQL*Loader

Oracle DBA Utilities

• DBVerify for Corruptions
• Flashback Database , Flashback Drop , Flashback Query
• Using Opatch for Database Patching

Cloning Of Oracle Database

• Cloning using Hot Backup
• Cloning Using RMAN Duplicate Database

Performance Management : Understand Problem , Check OS and Automated Reports

• Understand the Performance Problem Scope
• Discuss with the affected Users
• Check dynamic performance views useful in tuning
• Use dynamic performance views to view statistics and wait events
• Diagnosis of Server Memory Issues
• Tracking CPU Utilization , High CPU Consuming Processes and Sessions
• Use of Graphs and Tools for Problem Diagnosis a the OS Level
• Create and manage AWR snapshots
• Generate AWR reports
• Create snapshot sets and compare periods
• Generate ADDM reports
• Log a performance Service Request with Oracle Support

Performance Management : Tuning the Oracle Instance

• Tuning SGA
• Tuning the Shared Pool
• Tuning the Buffer Cache
• Checkpoint and Redo Tuning
• Diagnose checkpoint and redo issues
• Size the redo log file
• Size the redo log buffer
• Size the redo log file
• Diagnose PGA memory issues
• Size the PGA memory
• Diagnose temporary space issues
• Understanding Locks
• Detect enqueue contention
• Understanding Latches
• Diagnose and Resolve Latch Issues