Contact Us

« Important Announcement » Contact Us 877-206-0106 | USA Flag

Thank you for your interest in LearnQuest.

Your request is being processed and LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.


Thank you for your interest in Private Training.

We look forward to helping you develop the perfect training solution to help you meet your company's goals.

For immediate assistance, speak with one of our representatives using the chat module below. Otherwise, LearnQuest or a LearnQuest-Authorized Training Provider will be in touch with you shortly.


Thank you for your interest in LearnQuest!

Now, you will be able to stay up-to-date on our latest course offerings, promotions, and training discounts. Watch your inbox for upcoming special offers.


Date: xxx

Location: xxx

Time: xxx

Price: xxx

Please take a moment to fill out this form. We will get back to you as soon as possible.

All fields marked with an asterisk (*) are mandatory.

Oracle Database 12c: Architecture & Internals

2,100 USD
3 Days
Classroom Training, Online Training

AWS Training Pass

Take advantage of flexible training options with the AWS Training Pass and get Authorized AWS Training for a full year.

Learn More

Prices reflect a 22.5% discount for IBM employees (wherever applicable).
Prices reflect a 24% discount for Kyndryl employees (wherever applicable).
Prices reflect the Accenture employee discount.
Prices shown are the special AWS Partner Prices.
Prices reflect the Capgemini employee discount.
Prices reflect the UPS employee discount.
Prices reflect the ??democompanyname?? employee discount.
GSA Private/Onsite Price: ??gsa-private-price??
For GSA pricing, please go to GSA Advantage.

Class Schedule

Delivery Formats

Sort results

Filter Classes

Guaranteed to Run





    Sorry, there are no public classes currently scheduled in your country.

    Please complete this form, and a Training Advisor will be in touch with you shortly to address your training needs.

View Global Schedule

Course Description


This Oracle Database 12c: Architecture & Internals course 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.

This course initially presents the Oracle database architecture from the perspective of a traditional, single-tenant database configuration as it exists within an on-premise systems infrastructure. We then draw comparisons between such a traditional environment and the new Oracle 12c multi-tenant architecture, used in both traditional and cloud-based computing models.

We present this information in a form that goes beyond a discussion of theoretical concepts. In many cases the Enterprise Manager interface is used to explore the components under consideration. Therefore one of the secondary objectives of this textbook is to acquaint you with the built-in Enterprise Manager Database Express interface and sometimes with its EM Cloud Control (CC) companion. In particular our focus is to discover the capabilities of the Enterprise Manager Database Express interface newly introduced with the Oracle 12 database release.

The architecture of different Oracle database installations are not all uniform, as there is considerable flexibility regarding the way a particular installation is configured. Such configuration options exist largely in the form of database parameter settings. So this course will devote considerable time to identifying these parameters and how these settings can be used to configure a database installation to suit local requirements.

The information contained within this course is critical to the success of most Oracle technology professionals, whether they are database administrators, security specialists, tuning experts or cloud computing administrators.




  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers


    • DBOR-950 and DBOR-951 Oracle Database 12c: SQL Fundamentals (Levels I & II)
    • DBOR-955 Oracle Database 12c: Install & Upgrade Workshop


  • 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
    • Database 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
    • 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
    • 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 DBWR Process
    • The LGWR Process
    • Checkpoints And The CKPT Process
    • The SMON Process
    • The PMON Process
    • The LREG Process
    • The ARCH Process
    • The RECO Process
    • The CJQx Process
    • The 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
    • About Threaded Mode
    • Kernel Errors & Exceptions
    • The Error Message
    • The 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
    • Session Details 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
    • Dedicated Server Mode SQL Statement Execution
    • Shared Servers Mode Client Connection
    • Shared Servers Mode SQL Statement Execution
    • Consider Dedicated Server Mode
    • Consider Shared Servers 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 Phase
    • Execute Phase
    • Fetch Phase
    • SQL Optimization & Execution Plans
    • Optimization Methods
    • Rule-Based Optimizer
    • Cost-Based Optimizer
    • Automatic Tuning Optimizer
    • Adaptive Execution Plans
    • 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
    • Database Objects Context
    • The Data Dictionary Schema(s)
    • Making An Object Reference
    • Explicit Schema Context
    • Explicit Database Context
    • Partition Context
    • 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
  • Get Personalized Training Solutions

    Get Personalized Training Solutions

    Need a personalized solution for your Training? Contact us, and our training advisors will guide you.

    Contact Us Now

    Need Help?

    Need Help? We're Here!

    Have questions about courses, instruction, materials covered, or finding the right fit? We're here to help!

    Reach Out To Us

    2023 Top 20 Training Industry Company - IT Training

    Need Help?

    Call us at 877-206-0106 or e-mail us at

    Save Up to $500 This Summer

    Soak up new skills this summer with exclusive discounts on our popular topics and courses.


    Summer 2024 Promotion

    IBM TechXchange Conference 2024

    October 21-24 | Mandalay Bay, Las Vegas

    Save $127 with Code: TECHXCHANGE10

    Offer Expires June 30, 2024

    Self-Paced Training Info

    Learn at your own pace with anytime, anywhere training

    • Same in-demand topics as instructor-led public and private classes.
    • Standalone learning or supplemental reinforcement.
    • e-Learning content varies by course and technology.
    • View the Self-Paced version of this outline and what is included in the SPVC course.
    • Learn more about e-Learning

    Course Added To Shopping Cart







    Self-Paced Training Terms & Conditions


    Exam Terms & Conditions


    Sorry, there are no classes that meet your criteria.

    Please contact us to schedule a class.

    STOP! Before You Leave

    Save 0% on this course!

    Take advantage of our online-only offer & save 0% on any course !

    Promo Code skip0 will be applied to your registration

    Nothing yet
    here's the message from the cart

    To view the cart, you can click "View Cart" on the right side of the heading on each page
    Add to cart clicker.

    Purchase Information

    ??elearning-coursenumber?? ??coursename??
    View Cart


    Date: xxx

    Location: xxx

    Time: xxx

    Price: xxx

    #Please take a moment to fill out this form. We will get back to you as soon as possible.#

    #All fields marked with an asterisk (*) are mandatory.#

    If you would like to request a quote for 5 or more students, please contact to be assigned an account representative.

    Need more Information?

    Speak with our training specialists to continue your learning journey.


    Delivery Formats


    By submitting this form, I agree to LearnQuest's Terms and Conditions

    heres the new schedule
    This website uses third-party profiling cookies to provide services in line with the preferences you reveal while browsing the Website. By continuing to browse this Website, you consent to the use of these cookies. If you wish to object such processing, please read the instructions described in our Privacy Policy.
    Your use of this LearnQuest site affirms your consent to our use of session and persistent cookies to track how you use our website.