Booking options
Price on Enquiry
Price on Enquiry
Delivered Online
5 days
All levels
5 Days
30 CPD hours
This course is intended forThis intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher.
OverviewWorking 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
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.
Nexus Human, established over 20 years ago, stands as a pillar of excellence in the realm of IT and Business Skills Training and education in Ireland and the UK....