Basic Tuning Methods and Diagnostics
Tuning Methodologies
Tuning Lifecyles phases
Describe the time model
Explain wait events
Diagnosing performance problems using V$ views
Reducing the Cost of SQL Operations
Shrinking Segments
Managing Chaining and Migration
Configuring Index and Table Performance Options
Configuring table compression
Diagnosing and tuning space related issues
Using Statspack
Installing and configuring Statspack
Diagnosing performance problem using Statspack
Using Real Application Testing
Using SQL Performance Analyzer to test the impact of database changes
Use Database Replay to check impact of system change on performance
Using Log and Trace Files to Monitor Performance
Using the Alert Log to Monitor Performance
Using Trace files to Monitor Performance
SQL Performance Management
Managing optimizer statistics
Using the Optimizer Statistics Advisor
Using the SQL Access and SQL Tuning advisors to Tune SQL statements
Use SQL Plan Management to tune SQL statements
Using Metrics, Alerts and Baselines
Monitoring performance using metric thresholds and alerts
Using AWR baselines to monitor performance
Tuning the Shared Pool
Diagnosing and resolving performance problems related to the shared pool
Managing and Tuning the Result Cache
Using AWR-Based Tools
Diagnosing performance issues using ADDM
Diagnosing performance issues using ASH reports
Using Automated Maintenance Tasks to Manage Performance
Tuning the Buffer Cache
Diagnosing and resolving performance problems related to the buffer cache
Diagnose database I/O issues
Configuring Big Table Caching
Configuring Flash Cache
Performing Oracle Database Application Monitoring
Implementing Real-Time Database Operation Monitoring
Configuring and using services to monitor database Application performance
Tuning the PGA
Diagnosing and resolving performance issues related to PGA
Diagnosing and resolving performance issues related to temporary tablespace
Identifying Problem SQL Statements
Understand the phases for SQL statement processing
Interpreting execution plans
Using formatted output of SQL Trace or the optimizer trace to identify poorly performing SQL statements
Monitoring Adaptive / Dynamic Execution plans
Monitoring Automatic Reoptimization and SQL Plan Directives
Using Automatic Memory Management
Configuring Automatic Shared Memory Management
Configuring Automatic Memory Management
Influencing the Optimizer
Explain how statistics influence the optimizer
Configuring parameters to influence the optimizer
Using In-Memory Features
Configure and Use in memory columnn store to improve SQL performance
Use in memnory column store with other database features
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
