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
Our engaging instructors and mentors are highly-experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees 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 Info
Cost: $ 2,695
Length: 5.0 days (40 hours)
Level:
Next Available Classes:
6:00 PM ET
6:00 PM ET
6:00 PM ET
6:00 PM ET