Course Code: 5790

Oracle Database 12c: Architecture & Internals

Class Dates:
3 Days
Class Time:
Instructor-Led Training


  • Course Overview
  • This Oracle Database 12c: Architecture and Internals training class begins with a discussion of the broad systems infrastructure where one finds Oracle database installations. 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. The course also covers the internals of the database, including internal locking mechanisms, kernel module calls and database failures.

    Subjects covered are helpful for multiple certifications, including such certifications as an Oracle Database 12c Administrator Certified Associate (OCA) for "Exam: 1Z0-062: Oracle Database 12c: Installation And Administration"
  • Audience
  • The target audience for this Oracle Database training class is all Oracle professionals: database administrators, application designers and developers, web server administrators, system administrators, implementation specialists, and data center support engineers.


Course Details

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