Basic Tuning Methods and Diagnostics
Tuning Methodologies
Tuning Lifecyles phases
Describe the time model
Explain wait events
Diagnosing performance problems using V$ views
Performing Oracle Database Application Monitoring
Implementing Real-Time Database Operation Monitoring
Configuring and using services to monitor database Application performance
Using Statspack
Installing and configuring Statspack
Diagnosing performance problem using Statspack
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 Log and Trace Files to Monitor Performance
Using the Alert Log to Monitor Performance
Using Trace files to Monitor Performance
Influencing the Optimizer
Explain how statistics influence the optimizer
Configuring parameters to influence the optimizer
Using AWR-Based Tools
Diagnosing performance issues using ADDM
Diagnosing performance issues using ASH reports
Using Automated Maintenance Tasks to Manage Performance
Using Metrics, Alerts and Baselines
Monitoring performance using metric thresholds and alerts
Using AWR baselines to monitor performance
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
Tuning the Shared Pool
Diagnosing and resolving performance problems related to the shared pool
Managing and Tuning the Result Cache
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 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
.jpeg)
.jpeg)
.jpeg)
.jpeg)
.jpeg)
