Utilities and Dynamic Performance Views

Objectives

Views, Utilities, and Tools

Dictionary and Special Views

Dynamic Troubleshooting and Performance Views

Topics for Troubleshooting and Tuning

Collecting System-Wide Statistics

Collecting Session-Related Statistics

UTLBSTAT and UTLESTAT Scripts

Gather Statistics

The Statistics Report

Library Cache Statistics

I/O Statistics

Latches: Overview

Latches

Latch Types

Oracle Wait Events

V$EVENT_NAME View

Statistics Event Views

V$SYSTEM_EVENT View

V$SESSION_EVENT View

V$SESSION_WAIT View

Enterprise Manager (EM Version 2)

Event Management System

Predefined Event Tests

Predefined Event Tests

Predefined Event Tests

Predefined Event Tests

Event Parameters

Fix the Problem Detected by the Event

DBA-Developed Tools

Oracle Packs

Performance Manager

TopSessions

TopSessions: Locks

Tablespace Manager

Common Uses of Oracle Trace Manager

Overview of Oracle Expert Tuning Methodology

Tuning Session Scope

        Tuning Recommendations

Summary