ratingsÂ
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.
Unlimited Duration
March 4, 2021
Working within in a hands-on learning environment, guided by our expert team, you 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 Curriculum
-
- Instance Definition 00:00:00
- Define SGA 00:00:00
- Define Background Processes 00:00:00
- Datafile Definition 00:00:00
-
- SQL Parsing 00:00:00
- Optimizing Terms 00:00:00
- Optimizing Methods 00:00:00
- Query Plan Generation 00:00:00
- Query Plan Control 00:00:00
- Pluggable tuning parameters 00:00:00
- Define Container tuning structure 00:00:00
- Using PDB$SEED 00:00:00
- Create a new PDB 00:00:00
- Plug and unplug a PDB 00:00:00
- Defining SQL execution plans 00:00:00
- Automatic Workload Repository 00:00:00
- Reading execution plans 00:00:00
- Defining AWR 00:00:00
- AWR Settings 00:00:00
- Creating AWR Baselines 00:00:00
- Nested Loops Join 00:00:00
- Sort Merge join 00:00:00
- Hash Join and Cartesian Join 00:00:00
- Equijoins and Nonequijoins 00:00:00
- Outer Joins 00:00:00
- Semijoins 00:00:00
- Automatic Maintenance Tasks 00:00:00
- Segment Advisor 00:00:00
- Statistics Gathering 00:00:00
- Automatic Tuning Optimizer 00:00:00
- Automatic Database Diagnostic Monitor 00:00:00
- Active Session History (ASH) 00:00:00
- Overview of what is an Oracle Service 00:00:00
- Creating an Oracle Service for Single instance and RAC 00:00:00
- Monitoring a Service 00:00:00
- Resource Management and a Service 00:00:00
- Enterprise Manager and a Service 00:00:00
- Sql Performance Analyzer overview 00:00:00
- Sql Performance Analyzer Options 00:00:00
- Database Parameter changes 00:00:00
- Database version changes 00:00:00
- Creating SQL Tuning Sets 00:00:00
- Database Replay Overview 00:00:00
- Database Replay Configuration 00:00:00
- Database Replay Options 00:00:00
- SQL Access Advisor: Overview 00:00:00
- Sql Access Advisor options 00:00:00
- SQL Access Advisor and Sql Tuning Sets 00:00:00
- Sql Access Advisor and AWR 00:00:00
- Results and Implementation 00:00:00
- Sql plan Management and baseline overview 00:00:00
- Enable sql plan management 00:00:00
- Loading Sql Plan baselines into the SGA 00:00:00
- Adaptive plan management 00:00:00
- Database buffer cache overview 00:00:00
- Database buffer cache parameters 00:00:00
- Oracle and Dirty reads and writes 00:00:00
- Automatic Shared Memory Management (ASMM) 00:00:00
- Buffer Cache goals and responsibility 00:00:00
- Buffer Cache pools 00:00:00
- Oracle’s Automatic Memory Management Overview 00:00:00
- Database Auto-tuned Parameters 00:00:00
- Database Non Auto-tuned Parameters 00:00:00
- Automatic Memory Management Hints and Sizing suggestions 00:00:00
- AMM versus ASMM 00:00:00
- Overview of ASM 00:00:00
- Definition of Grid Infrastructure 00:00:00
- ASM Instance 00:00:00
- ASM Diskgroups 00:00:00
- ASM Diskgroup parameters and templates 00:00:00
- ASMCMD 00:00:00
Course Reviews

Students