Oracle Database 12c: Architecture and Internals

IT/Networking/Server/Operating Systems
  IT Online Library (1 Year Subscription - $1595.00)
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions

This Oracle Database 12c: Architecture and Internals training class begins with a discussion of the broad systems infrastructure where one finds Oracle database installations, and we outline how the database fits with other systems in a multi-tiered architecture, including web servers, application servers and engineered systems such as the Oracle Exadata database computing platform. We then explore the intricacies of a single database installation, including memory, process and storage structures. Periodically we delve into the internals of the database, probing into such areas internal locking mechanisms, kernel module calls and database failures.

The target audience is all Oracle professionals: database administrators, application designers and developers, web server administrators, system administrators, implementation specialists, and data center support engineers.


  1. Learn to the systems infrastructure.
  2. Learn to understand grid computing.
  3. Learn to the background and foreground process architecture.
  4. Learn to how to work with the memory and storage architecture.
  5. Learn to work with tablespaces.

  1. Oracle Architecture: The Systems Infrastructure
    1. About Enterprise Architectures
    2. The Relational Database
    3. Legacy Computing Models
    4. The Multi-Tiered Computing Model
    5. Scaling Up
    6. Cloud-Based Deployment
    7. Oracle Infrastructure Ecosystem
    8. Using Oracle Enterprise Manager
    9. More About EM
    10. Using EM Database Express
    11. Using EM Cloud Control
  2. Oracle Architecture: The Database Host
    1. The Database Server Stack
    2. Processor Layer
    3. CPU Resources
    4. Memory Resources
    5. I/O and Storage Processing
    6. OS Layer Processing Modes
    7. Database Server Virtualization
    8. Storage Virtualization
    9. Oracle Database Server Stack
    10. Oracle Engineered Systems
    11. Oracle Exadata Database Platform
    12. Exalogic Cloud Machine
    13. Exalytics BI Machine
  3. Oracle Architecture: Principles and Technology Concepts
    1. Grid Computing Principles
    2. Why Grid Computing?
    3. What Is Grid Computing?
    4. Parallelization Principles
    5. Hardware Parallelization
    6. Grid Computing Devices
    7. Clustered Database Servers
    8. Cloud Computing Principles
    9. Multi-Tenancy
  4. Oracle Architecture: The RDBMS Installation and The Database Instance
    1. The Database Server Software
    2. Database Versions and Releases
    3. Database Editions
    5. The Core Database Components
    6. Using V$VERSION View
    7. Understanding The Database Version Number
    8. The COMPATIBLE Database Parameter
    9. Database Instance Elements
    10. Individual Elements Of A Database Instance
    11. Physical Database Elements
    12. An Operational Database installation
    13. Database Instance Configurations
    14. Single Instance
    15. Parameter Files and Instance Configuration
    16. MAX_STRING_SIZE Parameter Example
    17. Independent Instances
    18. Clustered Instances
    19. The Database Instance In A Multi-tenant
  5. Configuration
    1. Reconfiguring A Database Instance
    2. Static Vs. Dynamic Parameters
    3. Dynamic Parameter Setting
    4. Parameter Setting Scope
    5. Parameter Setting Level
    6. Setting Upgrade Related Parameters
    7. Database Components
    8. Advanced Data Functionality Components
    9. Security Components
    10. High-Performance Components
    11. Administration Components
    12. Database Feature Usage
  6. Oracle Database Instance: Memory Architecture
    1. Shared and Private Memory
    2. SGA Internals
    3. The Buffer Cache
    4. The Database Smart Flash Cache
    5. The Redo Log Buffer
    6. The Shared Pool
    7. The Large Pool
    8. The Java Pool
    9. Unified Auditing Queues
    10. PGA Internals
    11. What Is Inside The PGA?
    12. Tunable and Non-tunable PGA Space
    13. Client-Side Cursors
    14. Where Is The PGA Stored?
    15. PGA/UGA In Shared Server Mode
    16. PGA/UGA With Optional Large Pool
    17. LOB Objects and Memory Handling
    18. LOB Buffer Caching
    19. Shared I/O Pool
    20. LOB Workspace and The PGA
    21. Instance Memory Management
    22. About Automatic Memory Management
    23. Default Settings
    24. Configure MEMORY_TARGET Parameter
    25. Configure SGA_TARGET Parameter
    26. Configure PGA_AGGREGATE_TARGET Parameter
    27. PGA_AGGREGATE_LIMIT Parameter
    28. Configure Memory Using EM DE
  7. Oracle Database Instance: Background Process Architecture
    1. Foreground Vs. Background
    2. About The Background Processes
    3. The Background Processes
    4. Linux System Processes
    5. The DBWR Process
    6. The LGWR Process
    7. Checkpoints And The CKPT Process
    8. The SMON Process
    9. The PMON Process
    10. The LREG Process
    11. The ARCH Process
    12. The RECO Process
    13. The CJQx Process
    14. The DBRM Process
    15. The Management Framework Processes
    16. Flashback Data Archive (FBDA) Process
    17. Fault Diagnostics
    18. Other Housekeeping Processes
    19. Background Process Performance Monitors
    20. Threaded Mode
    21. About Process Mode
    22. About Threaded Mode
    23. Kernel Errors and Exceptions
    24. The Error Message
    25. The Error Message Stack
    26. Kernel Errors and Core Dumps
    27. ORA-006xx and ORA-07445 Errors
    28. Understanding The Kernel Errors
    29. The Kernel Module
    30. Kernel Module Arguments
    31. Diagnostic Modules
    32. The Call Stack Trace
    33. ORA-600/ORA-7445/ORA-700 Error Lookup Tool
  8. Oracle Database Instance: Foreground Process Architecture
    1. Dedicated Server Mode
    2. Session Details From V$SESSION View
    3. Session Details From EM Database Express
    4. What Is The Impact Of Dedicated Server Mode?
    5. Shared Servers Mode
    6. Processing SQL In Shared Servers Mode
    7. Comparing Dedicated Server and Shared Servers Mode
    8. Dedicated Server Mode Client Connection
    9. Dedicated Server Mode SQL Statement Execution
    10. Shared Servers Mode Client Connection
    11. Shared Servers Mode SQL Statement Execution
    12. Consider Dedicated Server Mode
    13. Consider Shared Servers Mode
    14. Shared Servers Mode Advantages
    15. Choosing The SQL Execution Mode
    16. Instance-Level SQL Execution Mode Configuration
    17. Session-Level SQL Execution Mode Configuration
    18. Parallel SQL Execution
    19. What Is Parallel Execution?
    20. The Impact On SQL Statement Execution
    21. SQL Statement Execution
    22. Parse Phase
    23. Execute Phase
    24. Fetch Phase
    25. SQL Optimization and Execution Plans
    26. Optimization Methods
    27. Rule-Based Optimizer
    28. Cost-Based Optimizer
    29. Automatic Tuning Optimizer
    30. Adaptive Execution Plans
    31. Adaptive Statistics
  9. Oracle Database Storage Architecture: Logical Database Objects
    1. About Database Objects
    2. Relational Database Objects List
    3. Database-Resident Program Units
    4. Additional Database Objects
    5. Database Objects Illustrated
    6. Database Objects Context
    7. The Data Dictionary Schema(s)
    8. Making An Object Reference
    9. Explicit Schema Context
    10. Explicit Database Context
    11. Partition Context
    12. Editions Context and Redefinition
    13. About Application Upgrades
    14. About Application Downtime
    15. The Edition Hierarchy
    16. The Editions In Action
  10. Oracle Database Storage Architecture: Physical Database Files
    1. About The Database Files
    2. Server Parameter Files
    3. CONTROL Files
    4. REDO LOG Files
    5. DIAGNOSTIC Files
    6. What Are The Diagnostic Files?
    7. EM Cloud Control Access
    8. The MAX_DUMP_FILE_SIZE Parameter
    9. The DIAGNOSTIC_DEST Parameter
    10. The Log Files
    11. Text Alert Log Contents
    12. Viewing Text Alert Log Contents
    13. Viewing Alert Log Errors
    14. Maintaining The Alert Log
    15. The Trace Files
    16. Background Process Trace Files
    17. SQL Execution Process (User) Trace Files
    18. Incident Dump Files
    19. Core Dump Files
    20. Trace Files At The OS Level
    21. Sample DIAG Trace File
    22. Monitoring Trace File Space Usage
    23. Maintaining The Trace Directories
    24. Files In A Multi-Tenant Database
  11. Oracle Database Storage Architecture: Tablespaces
    1. Tablespaces and Data Files
    2. Peering Into The Tablespace Storage Hierarchy
    3. More About Clustered Table Storage
    4. More About The RowID
    5. Hybrid Columnar Compression
    6. Temporary Segments
    7. About Temporary Segments
    8. About Temporary Tablespace Groups
    9. Advantages
    10. INDEX Segments
    11. B-tree Index Segments
    12. Bitmap Index Segments
    13. Internal Locks
    14. Using V$LOCK_TYPE View
    15. Latches
    16. Using V$LATCH View
    17. Mutexes and V$MUTEXT_SLEEP
    18. User Locks
    19. Manage and Monitor System Locks
    20. About Database Wait Events
    21. Concurrency Wait Events (Mutex)
    22. Concurrency Wait Events (Latch)
    23. Spinning Vs. Sleeping
    24. Using EM Cloud Control Using AWR

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.


Class Prerequisites

Experience in the following is required for this Oracle class:

  • Oracle SQL and install and upgrade experience

Prerequisite Courses

Courses that can help you meet these prerequisites:

  • Introduction to SQL Training

Course Setup
  • Live Online: Course Setup | WebEx Setup