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.

starstarstarstarstar_half

* 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

Not Your Location? Change

Cost: $ 2,695

Length: 5.0 days (40 hours)

Level:

Next Available Classes:

Schedule select
03
Apr
Monday
10:00 AM ET -
6:00 PM ET
Almost Full
5 seat(s) left
Schedule select
12
Jun
Monday
10:00 AM ET -
6:00 PM ET
Full
Wait List
Schedule select
21
Aug
Monday
10:00 AM ET -
6:00 PM ET
Full
Wait List
Schedule select
30
Oct
Monday
10:00 AM ET -
6:00 PM ET
Full
Wait List
Loading...