Oracle DBACourse Structure
Architecture & Configuration
Overview of Oracle DBA tasks
Instance Architecture
Oracle Instance Internals
Using SQL*Plus for DBA management
Control file, UNDO and REDO management
User and privilege management
Oracle database management
Overview of instance management
Initialization file management
Oracle*Net configuration
Data buffer configuration & sizing
Shared pool and PGA configuration & Sizing
Troubleshooting network connectivity
Oracle object management
Oracle tables, views and materialized views
Oracle indexes
Oracle constraints
Schema, File & tablespace management
Database Maintenance
Oracle DBA Utilities
Monitoring Oracle
This section explores the methods used for monitoring all active components of the Oracle database.
Dictionary and v$ views
Table & index monitoring
workload & trend monitoring
Instance monitoring
Oracle environment monitoring
STATSPACK and AWR performance management
Performance Management
This section explores the methods used for performance management in Oracle and shows tips and scripts for monitoring all components of any Oracle database. You will also learn the proper action to take when any area of Oracle becomes a bottleneck.
Bottleneck performance analysis
Instance Tuning
SQL and CBO behavior
Tracing SQL Execution
SQL Execution Internals
SQL Tuning
Oracle High Availability tools
Backup & Recovery