• No products in the cart.

ratings 

Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more.

PRIVATE
Course Access

Unlimited Duration

Last Updated

March 4, 2021

Students Enrolled

Total Reviews

Posted by
Certification

Working within in a hands-on learning environment, guided by our expert team, you will explore:

· Overview Oracle Database Architecture

· Query Optimizer

· Tuning Container Databases and Pluggable Databases

· Oracle 12c Tuning features

· Evaluating Execution Plans

· Oracle Tuning Tools

· Using Automatic Workload Repository

· Join Types

· AWR Using Baselines

· Additional AWR performance tools

· Optimizer Statistics

· Monitoring a Service

· Bind Variables and database parameters

· Oracle's Real Application Testing (RAT)

· SQL Tuning Advisor

· Automatic Sql Tuning

· Sql Plan Management

· Shared Pool Tuning

· Tuning the database buffer cache

· Tuning the PGA (Program Global Area)

· Automatic Memory Management (AMM)

· Tuning Segment Space Utilization (ASSM)

· Automatic Storage Management

Course Curriculum

    • Instance Definition 00:00:00
    • Define SGA 00:00:00
    • Define Background Processes 00:00:00
    • Datafile Definition 00:00:00
    • SQL Parsing 00:00:00
    • Optimizing Terms 00:00:00
    • Optimizing Methods 00:00:00
    • Query Plan Generation 00:00:00
    • Query Plan Control 00:00:00
    • Pluggable tuning parameters 00:00:00
    • Define Container tuning structure 00:00:00
    • Using PDB$SEED 00:00:00
    • Create a new PDB 00:00:00
    • Plug and unplug a PDB 00:00:00
    • Identifying and Using Oracle’s Heat Map 00:00:00
    • 12c Compression Levels and Types 00:00:00
    • Defining SQL execution plans 00:00:00
    • Automatic Workload Repository 00:00:00
    • Reading execution plans 00:00:00
    • Monitoring tools overview 00:00:00
    • Enterprise Manager 00:00:00
    • Dynamic Performance Views 00:00:00
    • Automatic Workload Repository 00:00:00
    • Automatic Database Diagnostic Monitor 00:00:00
    • Sql Tuning Advisor 00:00:00
    • SQL Access Advisor 00:00:00
    • Sql Access Advisor 00:00:00
    • DB operation Tuning 00:00:00
    • DB operation Active Reporting 00:00:00
    • Defining AWR 00:00:00
    • AWR Settings 00:00:00
    • Creating AWR Baselines 00:00:00
    • Defining Metrics 00:00:00
    • Setting Alerts 00:00:00
    • Setting Corrective Actions 00:00:00
    • User Defined Metrics 00:00:00
    • Metric Dynamic Views 00:00:00
    • Nested Loops Join 00:00:00
    • Sort Merge join 00:00:00
    • Hash Join and Cartesian Join 00:00:00
    • Equijoins and Nonequijoins 00:00:00
    • Outer Joins 00:00:00
    • Semijoins 00:00:00
    • Creating AWR baselines 00:00:00
    • Creating AWR Repeating baselines 00:00:00
    • Moving Window Baseline 00:00:00
    • Automatic Maintenance Tasks 00:00:00
    • Segment Advisor 00:00:00
    • Statistics Gathering 00:00:00
    • Automatic Tuning Optimizer 00:00:00
    • Automatic Database Diagnostic Monitor 00:00:00
    • Active Session History (ASH) 00:00:00
    • Optimizer Statistics Overview 00:00:00
    • Table and Index Statistics 00:00:00
    • Statistic Preferences 00:00:00
    • Statistics Gathering 00:00:00
    • e) Locking Statistics, Export/Import Statistics 00:00:00
    • Pending and published statistics 00:00:00
    • Optimizer Hints 00:00:00
    • Optimizer Paths 00:00:00
    • Cost Base Optimization 00:00:00
    • Overview of what is an Oracle Service 00:00:00
    • Creating an Oracle Service for Single instance and RAC 00:00:00
    • Monitoring a Service 00:00:00
    • Resource Management and a Service 00:00:00
    • Enterprise Manager and a Service 00:00:00
    • Bind variable definition 00:00:00
    • Cursor_sharing parameter 00:00:00
    • Adaptive Cursor Sharing 00:00:00
    • Sql Performance Analyzer overview 00:00:00
    • Sql Performance Analyzer Options 00:00:00
    • Database Parameter changes 00:00:00
    • Database version changes 00:00:00
    • Creating SQL Tuning Sets 00:00:00
    • Database Replay Overview 00:00:00
    • Database Replay Configuration 00:00:00
    • Database Replay Options 00:00:00
    • SQL Tuning Advisor: Overview 00:00:00
    • SQL Tuning Advisor Limited Mode 00:00:00
    • Sql Tuning Advisor Comprehensive mode 00:00:00
    • Sql Tuning Profiles 00:00:00
    • SQL Access Advisor: Overview 00:00:00
    • Sql Access Advisor options 00:00:00
    • SQL Access Advisor and Sql Tuning Sets 00:00:00
    • Sql Access Advisor and AWR 00:00:00
    • Results and Implementation 00:00:00
    • Automatic Sql Tuning Maintenance Task 00:00:00
    • Automatic Tuning Optimization implementation(ATO) 00:00:00
    • Automatic Tuning Optimization Results 00:00:00
    • Enable/Disable Automatic Tuning Optimization 00:00:00
    • Sql plan Management and baseline overview 00:00:00
    • Enable sql plan management 00:00:00
    • Loading Sql Plan baselines into the SGA 00:00:00
    • Adaptive plan management 00:00:00
    • Shared pool architecture 00:00:00
    • Shared pool parameters 00:00:00
    • Library Cache 00:00:00
    • Dictionary cache 00:00:00
    • Large pool considerations and contents 00:00:00
    • Database buffer cache overview 00:00:00
    • Database buffer cache parameters 00:00:00
    • Oracle and Dirty reads and writes 00:00:00
    • Automatic Shared Memory Management (ASMM) 00:00:00
    • Buffer Cache goals and responsibility 00:00:00
    • Buffer Cache pools 00:00:00
    • PGA Overview 00:00:00
    • PGA Database Parameters 00:00:00
    • Temporary Segments 00:00:00
    • Temporary Tablespace 00:00:00
    • Sizing the PGA 00:00:00
    • Oracle’s Automatic Memory Management Overview 00:00:00
    • Database Auto-tuned Parameters 00:00:00
    • Database Non Auto-tuned Parameters 00:00:00
    • Automatic Memory Management Hints and Sizing suggestions 00:00:00
    • AMM versus ASMM 00:00:00
    • Overview of Automatic Segment Space Management 00:00:00
    • Defining the DB_BLOCK_SIZE 00:00:00
    • Defining DB_nk_CACHE_SIZE parameter 00:00:00
    • The DB_BLOCK_SIZE Parameter 00:00:00
    • Overview of table compression, block chaining, and block migration 00:00:00
    • Overview of ASM 00:00:00
    • Definition of Grid Infrastructure 00:00:00
    • ASM Instance 00:00:00
    • ASM Diskgroups 00:00:00
    • ASM Diskgroup parameters and templates 00:00:00
    • ASMCMD 00:00:00

Course Reviews

Profile Photo
ashar hafeez
0
61

Students

About Instructor

Pak

Course Events

[wplms_eventon_events]

More Courses by Insturctor

© 2021 Ernesto.  All rights reserved.  
X