This course gives
the Oracle database administrator (DBA) a firm
foundation in basic database administrative
tasks. Gain a conceptual understanding of the
Oracle 10g database architecture and how the
architectural structures work and interact with
one another.
| · |
Learn how to install Oracle Software and Database
|
| · |
Learn how to manage database storage and various objects
|
| · |
Learn Automatic Management and Oracle NET
|
| · |
Learn Automatic Storage Management |
| · |
Logical, Physical and Memory components |
| · |
Topologies of High Availability, Failover, RAC, Disaster Recovery |
| · |
Unix/Linux Environment Variable setups for Database |
| · |
Important Dictionary Views for Administering the Database |
| · |
Startup, Shutdown Status |
| · |
Oracle Enterprise Manager (OEM) and Init Parameter Review |
| · |
Tablespace and Datafile Management |
| · |
UNDO Tablespace Management and Temporary tablespace group creation |
| · |
ADDM (Automatic Database Diagnostic Monitor) |
| · |
ASMM (Automatic Shared Memory Management) |
| · |
ADSC (Automatic Database Statistic Collection) |
| · |
AWR (Automatic Workload Repository) |
| · |
ASH (Active Session History) |
| · |
ASM (Automatic Storage Management) |
| · |
Application Tuning and DB Link Management
|
| · |
Migrating Non-ASM files to ASM files |