Oracle Database 12c: Architecture and Internals

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
   4. Using PRODUCT_COMPONENT_VERSION View
   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
        
        

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

Experience in the following is required for this Oracle class:

• Oracle SQL and install and upgrade experience
  
  

Courses that can help you meet these prerequisites:

• Introduction to SQL Training