Oracle 19c Database Tuning
* Looking for a flexible schedule (after hours or weekends)? Please call 858-208-4141 or email us: sales@ccslearningacademy.com.
Student financing options are available.
Transitioning military and Veterans, please contact us to sign up for a free consultation on training and hiring options.
Looking for group training? Contact Us
Course schedule:
About This Course
Course Description:
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.
Learning Objectives
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
Inclusions
- Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
Target Audience
- This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher.
Your Instructors
Write a review
$2,795.00
40 hours
Inclusions
- Certified Instructor-led training
- Official Training Seminar Student Handbook
- Collaboration with classmates (not currently available for self-paced course)
- Real-world learning activities and scenarios
- Exam scheduling support*
- Enjoy job placement assistance for the first 12 months after course completion.
- This course is eligible for CCS Learning Academy’s Learn and Earn Program: get a tuition fee refund of up to 50% if you are placed in a job through CCS Global Tech’s Placement Division*
- Government and Private pricing available.*
-38%
-19%
AZ-204T00-A: Developing solutions for Microsoft Azure
$2,195.00$2,695.00
-38%
DP-900T00: Microsoft Azure Data Fundamentals
$495.00$795.00
