| Level: | For IT professionals |
| Provider: | Oracle (Unofficial) |
| Type of provider: | Database |
| Theme: | Database |
| Length (days): | 5 |
| Hours/day: | 8 |
| Delivery method: | Instructor-led (classroom) or on-line (webinar) |
| Price: | 1.850$ + VAT |
This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You'll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.
- Introduction
- Monitoring tools overview
- Using Automatic Workload Repository
- Defining Problems
- Metrics, Alerts, and Baselines
- Comparative Performance Analysis with AWR Baselines
- Using AWR Based Tools
- Monitoring an Application
- Identifying Problem SQL Statements
- Influencing the Optimizer
- Using SQL Performance Analyzer
- SQL Performance Management
- Using Database Replay
- Tuning the Shared Pool
- Tuning the Buffer Cache
- Tuning PGA and Temporary Space
- Automatic Memory Management
- Tuning Segment Space Usage
- Tuning I/O
- Performance Tuning Summary
- Appendix B: Using Statspack
- Oracle Database 11g: Administration Workshop I Release 2
- Oracle Database 11g: Administration Workshop II Release 2
Social Media
Live Contact