[go: up one dir, main page]
Scribd
Upload
73 views2 pages

Oracle Database 19c - Syllabus

The document outlines the course topics for Oracle Database 19c Performance Tuning, covering areas such as tuning tools, memory and cache tuning, space and I/O tuning, and query tuning. It includes advanced topics like AWR/ASH/ADDM usage, Statspack analysis, and performance tuning case studies. Additionally, it discusses indexes, partitions, and monitoring tools for effective performance management.

Uploaded by

sdfaql94
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
73 views2 pages

Oracle Database 19c - Syllabus

The document outlines the course topics for Oracle Database 19c Performance Tuning, covering areas such as tuning tools, memory and cache tuning, space and I/O tuning, and query tuning. It includes advanced topics like AWR/ASH/ADDM usage, Statspack analysis, and performance tuning case studies. Additionally, it discusses indexes, partitions, and monitoring tools for effective performance management.

Uploaded by

sdfaql94
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Oracle Database 19c: Performance Tuning –

Course Topics
 Tuning Tools
 Tracing (SQL Trace / Autotrace)
 Different methods to run an explain plan
 Identifying Problem SQL Statements
 Execution Plan Interpretation
 Influencing the Optimizer
 Statistics
 Hints
 Plan Stability (Stored Outlines / SQL Profiles / SQL Baseline)
 SQL Tuning Sets
 Transporting Stats / STS / Outline / SQL Profiles from one DB to another DB
 SQL Tuning Advisory
 Using SQL Performance Analyzer
 SQL Plan Management

Memory & Cache Tuning

 Tuning the Shared Pool


 Tuning the Buffer Cache
 Tuning PGA and Temporary Space
 Automatic Memory Management

Space & I/O Tuning

 Tuning Segment Space Usage


 Tuning I/O

AWR / ASH / ADDM

 Using Automatic Workload Repository (AWR)


 Defining Problems
 Using AWR Baselines
 Using AWR Based Tools
 Interpreting AWR / ASH / ADDM / Trace Reports
 Enhancement of AWR / ADDM / ASH / SPM

Statspack & Explain Plan

 What is your objective when tuning a query?


 In-depth analysis of Statspack
 Troubleshooting without AWR / ADDM (unlicensed customers)
 In-depth analysis of explain plan with real-time plans and issues
 Determining if an explain plan is good or bad

Query Tuning

 Tune database using initialization parameters


 Use and impact of histograms in query tuning
 Adaptive Query Optimization
 Adaptive Plans
 SQL Plan Directives

Wait Events & RAC

 Commonly observed wait events and their resolutions


 RAC internode tuning (global waits)

Advanced Tracing & Case Studies

 Tracing (SQL Trace 10046 / 10053 Trace)


 Real case study–based performance tuning of 11g and 12c

Indexes, Partitions & MVs

 Parallel query execution plan interpretation


 Table and Index Partition
 Identifying which column to create an index on
 B-tree and Bitmap Index usage
 Materialized View and Materialized View Log
 Partitioned Table query execution plan interpretation

OS & Monitoring Tools

 Deep dive on OS commands / OS Watcher / other tools to monitor performance tuning

You might also like