Toll Free - 877-442-3915

Account | Self-Paced Login

Account | Self-Paced Login | 877-442-3915

Oracle Database 12c: Architecture and Internals Course

Oracle Database 12c: Architecture and Internals Training Course


Course Description:

Training Dates
(Click on the course name below to view course details and full list of class dates)

Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 4/3/19 - 4/5/19
Course Fee : $1795


Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 5/1/19 - 5/3/19
Course Fee : $1795


Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 5/29/19 - 5/31/19
Course Fee : $1795


Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 6/26/19 - 6/28/19
Course Fee : $1795


Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 7/24/19 - 7/26/19
Course Fee : $1795


Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 8/21/19 - 8/23/19
Course Fee : $1795


Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 9/18/19 - 9/20/19
Course Fee : $1795


Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 10/16/19 - 10/18/19
Course Fee : $1795


Oracle Database 12c: Architecture and Internals
Locations: Available Nationwide and Online
Class Date(s): 11/25/19 - 11/27/19
Course Fee : $1795


Course Syllabus

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
• How To Use ORACLE ENTERPRISE MANAGER
• More About EM
• How To Use EM Database Express
• How To Use 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
• How To Use PRODUCT_COMPONENT_VERSION View
• The Core Database Components
• How To Use 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
• Configuring MEMORY_TARGET Parameter
• Configuring SGA_TARGET Parameter
• Configuring PGA_AGGREGATE_TARGET Parameter
• PGA_AGGREGATE_LIMIT Parameter
• Configuring 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
• How To Use V$LOCK_TYPE View
• Latches
• How To Use 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
• How To Use EM Cloud Control

Available Locations

Alabama
Birmingham
Birmingham South
Huntsville
Mobile
Montgomery

Arizona
Mesa
Phoenix
Scottsdale
Tucson

Arkansas
Bentonville
Fayetteville
Little Rock
Little Rock west

California
Bakersfield
El Segundo
Elk Grove
Fresno
Glendale
Irvine
Los Angeles
Los Angeles West
Mission Valley
Orange
Palo Alto
Petaluma
Pleasanton
Redwood City
Riverside
Sacramento
San Diego
San Diego downtown
San Francisco
San Jose
Walnut Creek
Woodland Hills

Colorado
Boulder
Centennial
Colorado Springs
Denver
Fort Collins
Grand Junction
Lakewood
Loveland

Connecticut
Cheshire
Danbury
East Granby
Hartford
Rocky Hill
Shelton
Stamford

Delaware
Wilmington DE

Florida
Boca Raton
Brandon
Clearwater
Daytona Beach
Fort Myers
Fort Walton Beach
Ft Lauderdale
Jacksonville
Kissimmee
Lake Mary
Lakeland
Land O Lakes
Melbourne
Miami
Miami Doral
Miramar Beach
Naples
Orange Park
Orlando
Orlando Downtown
Orlando Northeast
Palm Beach Gardens
Pensacola
Plantation
Sarasota
St Petersburg
Tallahassee
Tampa
Vero Beach

Georgia
Alpharetta
Atlanta Buckhead
Augusta
Columbus GA
Duluth
Kennesaw
Macon
Savannah

Idaho
Boise
Meridian

Illinois
Chicago
Gurnee
Joliet
Naperville
Northbrook
Oakbrook Terrace
Peoria
Rockford
Schaumburg

Indiana
Carmel
Evansville
Fort Wayne
Indianapolis
Indianapolis downtown
South Bend

Iowa
Cedar Rapids
Des Moines
Quad Cities

Kansas
Lenexa
Topeka
Wichita

Kentucky
Erlanger
Lexington
Louisville

Louisiana
Baton Rouge
Lafayette
New Orleans

Maine
Portland ME

Maryland
Annapolis
Baltimore
Bethesda
Columbia MD
Ellicott City
Frederick
Germantown
Greenbelt
Owings Mills
Rockville
Towson

Massachusetts
Boston
Braintree
Danvers
Mansfield
Newton
North Andover
Norwell
Springfield MA
Westborough
Woburn
Worcester

Michigan
Ann Arbor
Franklin MI
Grand Rapids
Kalamazoo
Lansing
Livonia
Novi
Traverse City
Troy

Minnesota
Bloomington
Maple Grove
Minneapolis
Minneapolis downtown
Rochester MN
St Cloud
Woodbury

Mississippi
Gulfport
Jackson

Missouri
Columbia MO
Kansas City
Lees Summit
O Fallon
Springfield
St Louis
St Louis downtown

Montana
Great Falls

Nebraska
Lincoln
Omaha

Nevada
Henderson
Las Vegas
Reno

New Hampshire
Bedford
Concord
Londonderry
Nashua
Portsmouth

New Jersey
Bridgewater
East Brunswick
East Rutherford
Hamilton
Jersey City
Mahwah
Morristown
Mt Laurel
Paramus
Princeton
Red Bank

New Mexico
Albuquerque

New York
Albany
Bohemia
Brooklyn
Buffalo
Harrison
Melville
Mt Kisco
New York City - Grand Central Station
New York City - Lower Manhattan
New York City - Penn Station
Poughkeepsie
Queens
Rochester
Syracuse
Uniondale

North Carolina
Asheville
Chapel Hill
Charlotte
Charlotte North
Charlotte Uptown
Fayetteville
Greensboro
Hickory
Morrisville
Raleigh
Wilmington

North Dakota
Fargo
Grand Forks

Ohio
Akron
Beachwood
Blue Ash
Cincinnati
Cleveland
Columbus
Columbus Downtown
Dayton
Dublin
Independence OH
Norwood
Toledo
Westlake
Youngstown

Oklahoma
Edmond
Oklahoma City
Tulsa

Oregon
Beaverton
Eugene
Medford
Portland
Salem
Tualatin

Pennsylvania
Allentown
Conshohocken
Erie
Harrisburg
Huntingdon Valley
Lancaster
Malvern
Philadelphia
Pittsburgh
Pittsburgh downtown
State College
University Center
Wexford
York

Rhode Island
Providence
Warwick

South Carolina
Cayce
Greenville
Mount Pleasant

South Dakota
Sioux Falls

Tennessee
Chattanooga
Franklin
Knoxville
Memphis
Nashville

Texas
Addison
Amarillo
Austin
Austin downtown
Bryan
Corpus Christi
Dallas
El Paso
Fort Worth
Grapevine
Houston
Houston North
Irving
Katy
Keller
League City
McAllen
Midland
Plano
Plano Frisco
San Antonio
San Antonio downtown
Sugar Land
The Woodlands
Waco

Utah
Provo
Salt Lake City

Vermont
Shelburne

Virginia
Alexandria
Arlington VA
Charlottesville
Fairfax
Fredericksburg
Glen Allen
Lynchburg
Manassas
McLean
Newport News
Norfolk
Reston
Richmond
Roanoke

Washington
Bellevue
Bellingham
Bothell
Kennewick
Mukilteo
Olympia
Puyallup
Seattle
Spokane
Tacoma

Washington DC
Washington DC
Washington DC - Union Station

West Virginia
Martinsburg

Wisconsin
Brookfield
Glendale WI
Green Bay
Madison
Madison east
Milwaukee

Wyoming
Casper
Cheyenne


Online Self-Paced Training Value Package Only $149

"The Instructor made class truly interesting and put everything into real world terms."
- Meredith T(Jersey City, NJ)


Business Computer Skills BBB Profile