A shared memory region allocated when the database instance starts. It contains data and control information for the instance. Key components include the Database Buffer Cache (stores blocks read from data files), Shared Pool (caches SQL execution plans), and Redo Log Buffer (stores transactional changes).
| Module | Key Topics Covered | |---------|--------------------| | | Recovery Manager configurations, Fast Recovery Area, Backup of CDB/PDBs, Point-in-time recovery. | | 10 – Flashback | Flashback Database, Flashback Table, Flashback Transaction (using undo and redo logs). | | 11 – Diagnosing Failures | Automatic Diagnostic Repository (ADR), Incident Packaging Service (IPS). | | 12 – Automatic Workload Repository (AWR) | AWR baseline templates, Compare periods reports. | | 13 – Performance Tuning | SQL Tuning Advisor, Real-time SQL monitoring, Adaptive execution plans (19c updates). | | 14 – Autonomous Features | Automatic indexing, Automatic memory management, Automatic SQL plan management. | | 15 – Moving Data | Data Pump (parallel, encryption), SQL*Loader, External tables with Big Data connectors. |
An instance consists of the temporary memory structures and background processes.
Managing data files (auto-extend, resizing, and moving online).
Using Recovery Manager (RMAN) for consistent and inconsistent backups.
While the specific workshop PDF is proprietary and intended for enrolled students, Oracle provides comprehensive, updated documentation that covers the same administrative topics:
Utilize automated tuning features and resource management.
This module explains how Oracle manages concurrent user access. It covers Locking Mechanisms (DML locks, DDL locks) and how to resolve locking conflicts and deadlocks.
No. 23ai is a separate database version. However, the 19c guide includes a preface comparing 19c to 23ai for those planning migrations.
The is the core instructional material for a comprehensive, 5-day training program designed to transform students into proficient Database Administrators (DBAs). This "story" of the guide follows a structured journey from the foundational architecture to advanced performance tuning. The Journey Through the Workshop
Treat the PDF as a lab manual. For every architectural concept discussed, open your SQL*Plus or SQL Developer terminal and query the relevant V$ views (e.g., V$PARAMETER , V$INSTANCE , V$DATAFILE ).
A shared memory region allocated when the database instance starts. It contains data and control information for the instance. Key components include the Database Buffer Cache (stores blocks read from data files), Shared Pool (caches SQL execution plans), and Redo Log Buffer (stores transactional changes).
| Module | Key Topics Covered | |---------|--------------------| | | Recovery Manager configurations, Fast Recovery Area, Backup of CDB/PDBs, Point-in-time recovery. | | 10 – Flashback | Flashback Database, Flashback Table, Flashback Transaction (using undo and redo logs). | | 11 – Diagnosing Failures | Automatic Diagnostic Repository (ADR), Incident Packaging Service (IPS). | | 12 – Automatic Workload Repository (AWR) | AWR baseline templates, Compare periods reports. | | 13 – Performance Tuning | SQL Tuning Advisor, Real-time SQL monitoring, Adaptive execution plans (19c updates). | | 14 – Autonomous Features | Automatic indexing, Automatic memory management, Automatic SQL plan management. | | 15 – Moving Data | Data Pump (parallel, encryption), SQL*Loader, External tables with Big Data connectors. |
An instance consists of the temporary memory structures and background processes.
Managing data files (auto-extend, resizing, and moving online).
Using Recovery Manager (RMAN) for consistent and inconsistent backups.
While the specific workshop PDF is proprietary and intended for enrolled students, Oracle provides comprehensive, updated documentation that covers the same administrative topics:
Utilize automated tuning features and resource management.
This module explains how Oracle manages concurrent user access. It covers Locking Mechanisms (DML locks, DDL locks) and how to resolve locking conflicts and deadlocks.
No. 23ai is a separate database version. However, the 19c guide includes a preface comparing 19c to 23ai for those planning migrations.
The is the core instructional material for a comprehensive, 5-day training program designed to transform students into proficient Database Administrators (DBAs). This "story" of the guide follows a structured journey from the foundational architecture to advanced performance tuning. The Journey Through the Workshop
Treat the PDF as a lab manual. For every architectural concept discussed, open your SQL*Plus or SQL Developer terminal and query the relevant V$ views (e.g., V$PARAMETER , V$INSTANCE , V$DATAFILE ).