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.
* Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Learning Objectives
Working in a hands-on learning environment led by our expert facilitator, you’ll explore:
The Oracle Database Architecture
Query Optimizer
Tuning Container Databases and Pluggable Databases
Oracle 19c 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
$2,695
Length: 5.0 days (40 hours)
Level:
Course Schedule:
6:00 PM ET