Services - Oracle Performance Management Seminar - Oracle 8i, 9i and 10G
The world of Oracle performance management has a reputation as part science, part art, and mostly wizardry. This seminar
imparts the core principles of performance management by sharing a methodology to investigate, determine, and implement
"meaningful solutions" to real problems. This seminar covers all releases of Oracle from version 7 to 10G, predominantly
focusing on versions 9i and 10g. The syllabus for the seminar includes the following:
What is Compulsive Tuning Disorder (CTD)?
• Why should you care?
What is Performance Optimization?
• When should you optimize?
What is the Oracle Wait Interface (OWI)?
The Method Behind the Madness
• Oracle Diagnostics (I)
• Operating System Diagnostics (II)
• Correlating I & II
The Guts of OWI
• The core performance diagnostic views
• Low-level trace methods (10046, 10053)
Diagnosing an Oracle performance problem - A Demo
Performance Enhancements in Oracle 9i
Performance Case Studies from the Real World
Application Performance Optimization - A DBA’s Perspective
• The 80-20 rule
• Optimization Methodologies
• Controlling the Oracle Optimizer
• Oracle Instance/Database Configuration & Optimization
• SQL Processing
Database Memory Allocation & Management
Design your database for performance
Real-world case studies
Performance Management in Oracle 10G
Conclusion
The world of Oracle performance management has a reputation as part science, part art, and mostly wizardry. This seminar
imparts the core principles of performance management by sharing a methodology to investigate, determine, and implement
"meaningful solutions" to real problems. This seminar covers all releases of Oracle from version 7 to 10G, predominantly
focusing on versions 9i and 10g. The syllabus for the seminar includes the following:
What is Compulsive Tuning Disorder (CTD)?
• Why should you care?
What is Performance Optimization?
• When should you optimize?
What is the Oracle Wait Interface (OWI)?
The Method Behind the Madness
• Oracle Diagnostics (I)
• Operating System Diagnostics (II)
• Correlating I & II
The Guts of OWI
• The core performance diagnostic views
• Low-level trace methods (10046, 10053)
Diagnosing an Oracle performance problem - A Demo
Performance Enhancements in Oracle 9i
Performance Case Studies from the Real World
Application Performance Optimization - A DBA’s Perspective
• The 80-20 rule
• Optimization Methodologies
• Controlling the Oracle Optimizer
• Oracle Instance/Database Configuration & Optimization
• SQL Processing
Database Memory Allocation & Management
Design your database for performance
Real-world case studies
Performance Management in Oracle 10G
Conclusion
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
| |
 |
DBPerfMan - In The Business of
Optimizing Oracle Database
Performance!
Optimizing Oracle Database
Performance!
| Copyright © 2004-2008 DBPerfMan, LLC. All rights reserved. |
