Oracle 10g Performance Case Studies
Martin Frauendorfer Technical Support Consultant, SAP AG
[email protected]
1
Table of Contents . Overview
Enqueue Analysis
Runtime Analysis
I/O Analysis
Comparison Analysis
Summary
© SAP AG 2007, Oracle 10g Performance Case Studies, Martin Frauendorfer / 2
2
1. Overview Intension Oracle 10g provides plenty of new features and possibilities in the area of performance analysis, e.g.:
Active Session History
Automatic Workload Repository
Advisors
Improvements in the wait event area
Improvements in the SQL optimization area
This presentation intends to show some real-life examples of how Oracle 10g features can effectively support the analysis and resolution of performance problems. With Oracle