Oracle Performance Tuning Online Training
Oracle Performance Tuning Online Training
Oracle Performance Tuning Online Training
Oracle Performance Tuning Online Training Course Content:
Oracle 11g Performance Tuning:
Properly Focusing Database Tuning Efforts
- The Database Tuning Focus
- Comparing Database Applications
- Impact Of Systems Infrastructure
- Impact Of Enterprise Architecture
- Top 10 Oracle Database Mistakes
Understanding The Database Host System
- Top 3 Host Performance Issues
- The Operating System
- Host System Processors
- I/O Processing
- Oracle Exadata Database Platform
Assessing Current Database Performance
- About Database Tuning
- Performance Statistics
- Comprehensive Performance Analysis
- Real-Time Performance Monitors
Real-Time Instance Activity Monitoring
- Drill-Down Real-Time Monitors
- How To Monitor Instance Activity
- Cursor Measures
- Transaction Measures
- Session Measures
- Logical I/O Measures
- Physical I/O Measures
- Net I/O Measures
- Table Measures
- All Measures
Understanding Statistics and Wait Events
- How Are The Statistics Organized?
- Controlling The Statistics Collection
- Statistics_Level Parameter
- Timed_Statistics Parameter
- Timed_Os_Statistics Parameter
- Examining Current Statistics Collection Settings
- Control_Management_Pack_Access Database Parameter
- Using Operational Statistics
- Using Wait Events
- Using Time Model Statistics
- Interpreting Os Statistics
Understanding I/O Internals
Automatic Database Tuning and Awr
- Management and Advisory Framework
- Managing Awr
- About Active Session History (Ash)
- Addm
Managing Snapshots
Create_Baseline() and Drop_Baseline()
Create_Snapshot() and Drop_Snapshot_Range()
Proactive Tuning With Metrics, Alerts and Baselines
- Metrics and Alert Thresholds
- Managing Metrics
- Using Metric Baselines
- Managing Alerts
Tuning Memory: The Shared Pool
- More About The Shared Pool
- Diagnose Shared Pool Problems
- Keep Objects In The Shared Pool
Tuning Memory: The Buffer Cache
- More About The Buffer Cache
- Remedy Performance Issues
Tuning Memory: Automatic Shared Memory
- Automatic Shared Memory Management
- Using Em and The Memory Advisors
Tuning I/O: Checkpoint and Redo Tuning
- Tune Redo Writing and Archiving
- Mttr Advisor and Tuning Checkpoints
- Log_Checkpoints_To_Alert
- Additional Redo Tuning Options
- Redo Log Files and 4k Sectors
Tuning I/O: Database Writes
Space Tuning: Block Space Usage
- Using The Shrink Space Option
- Using The Segment Advisor
- About Chained and Migrated Rows
- Call Delete_Task()
PL/SQL Tuning Support From Em
- Application Tuning Setup
- Em Application Monitoring and Tuning
Performance Tuning Using Statspack
- Install The Statspack Utility
- Create Statspack Snapshots
- Generate Statspack Reports
- Identify The Report Sections
Conclusion