Oracle 10g Performance Case Studies .fr

Jun 18, 2007 - Technical Support Consultant, SAP AG .... afternoon! ▫ DBA_HIST_SYSTEM_EVENT can show you (per default) on an hourly basis which wait ...
167KB taille 12 téléchargements 358 vues
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