Oracle Database 12c: Architecture & Internals
CLASS DATE(s):
Request a Class

COURSE LENGTH: 3 Days

COURSE COST: $1725.00

COURSE TIMES: 9:00am - 4:30pm

Printable version of this course
print

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 AND PREREQUISITES

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. Oracle Database 12c: SQL Fundamentals (Levels I & II)
Oracle Database 12c: Install & Upgrade Workshop

PREREQUISITE COURSES  

*Course Cost listed does not include the cost of the courseware. For more information or if you have any questions, please contact us (learn@vtec.org or 207-775-0244). This course is subject to a minimum enrollment to run. If the mimimum enrollment is not met than this class can run as an virtual instructor led course.

COURSE TOPICS:


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