Basic Tuning Tools - Diagnose performance issues using top wait events and the time model
- Use dynamic performance views to view statistics and wait events
- Use Enterprise Manager Monitoring
- Identify the key tuning components of the alert logs
Using Automatic Workload Repository - Create and manage AWR snapshots
- Generate and read AWR reports, analyze Compare Periods reports
Defining Problems - Identify performance issues & set tuning priorities
- Interpret tuning diagnostics
- Tune for life cycle phase
Using Metrics and Alerts - Interprete metric views and alerts
Baseline - Create and manage AWR baselines
- Create AWR baselines for future time periods
- Monitor performance and enable adaptive thresholds
Using AWR-Based Tools - Tune automatic maintenance tasks
- Analyze ADDM reports
- Analyze Active Session History (ASH) reports
Monitoring an Application - Configure and manage services
- Use services with client applications, Database Resource Manager and Scheduler
- Configure services aggregation, tracing, and set performance-metric thresholds
| Identifying Problem SQL Statements - Describe SQL statement processing
- View the SQL statement statistics to identify the SQL statements that perform poorly
- Describe and use methods for Viewing Execution Plans
Influencing the Optimizer - Describe the optimizer's behavior
- Adjust parameters to influence the optimizer
- Influence the optimizer (access methods, join techniques and adjust data structures)
SQL Performance Management - Manage optimizer statistics
- Configure automatic SQL tuning and SQL profiling
- Set up and use SQL plan baseline
Using SQL Performance Analyzer - Describe SQL Performance Analyzer process and benefits
- Use SQL Performance Analyzer
Using Database Replay - Identify when and how to use Database Replay
- Use Enterprise Manager to record and replay workloads
Tuning the Shared Pool - Describe Latches and Mutexes
- Diagnose and change cursor sharing
- Diagnose and resolve shared pool fragmentation
- Manage the results cache and tune the large pool
- Tune the data dictionary cache
| Tuning the Buffer Cache - Describe the buffer cache architecture
- Explain the symptoms that indicate a buffer cache problem
- Tune the buffer cache for performance issues
Tuning PGA and Temporary Space - Diagnose PGA memory issues and size the PGA
- Diagnose temporary space issues
- Specify temporary tablespace parameters for efficient operation
Automatic Memory Management - Implement Automatic Shared Memory Management (ASMM)
- Implement Automatic Memory Management (AMM)
Tuning Segment Space Usage - Tune segment space management
- Use Automatic Segment Space Management
- Diagnose row migration and chaining
- Use segment shrinking and table compression
Tuning I/O - Diagnose database I/O issues
- Describe the Stripe and Mirror Everything (SAME) concept
- Set filesystemio_options and Choose appropriate I/O solutions
- Tune Automatic Storage Management (ASM)
Appendix B Using Statspack |
