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
Drop your query
Most Popular Courses
Achieve your career goal with industry recognised learning paths
What my Client's Say?
-
It was a great course over my expectations. I am eager to have another course wıth you as soon as possıble ~ R. Kamand
-
All in all, it was a very constructive and one in a lifetime experience. I'm so glad that I was part of it.~ T. Engin
-
It was the best decision I had ever made in my life. Although it was expensive for me, but I don't regret even for one second. ~ Maruti Malla
-
Thank you for this great course. I learned a lot of things, I met very nice people and I am happy that I had these 6 crazy weeks with you.".~ Najmul Shar A Baig
-
Very nice and friendly tutor and staff. The course was very fruitful, particularly the input sessions during the first half of it.~ Radha Nandyala
-
It was such great experience, though it was really intensive, it was worth doing it! Cant thank enough all team effort esp Mohan! .~ Rohan Kumar
-
The course was really good because it was a practical course.~ M.Radha patel
-
I liked this experience. Good tutor and nice mates. I will always remember it. ~ Jitu Bavaria
