Oracle Enterprise Manager Oracle Trace User's Guide
Release 1.5.0
A57690-01

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview

Oracle Trace Manager

Managing Collections

Collecting Event Data

Accessing Collected Data

Oracle Trace Environment

Components on the Client

Components on the Server

Configured Components Checklist

2 Using Oracle Trace

Starting Oracle Trace

Viewing the Oracle Trace Manager Main Window

Viewing Oracle Trace Manager Menus

Collection Menu

Discovering Products

Troubleshooting

3 Working with Collections

Creating Collections

Step 1: Select Server Nodes

Step 2: Choose Installation

Step 3: Select Event Sets

Step 4: Limit Data Collected by Users

Step 5: Limit Data Collected by Events

Step 6: Name Collection Definition File

Step 7: Schedule the Collection

Advanced Scheduling Options

Step 8: Select Formatting Option

Advanced Formatting Options

Viewing Collection Data

Creating Like Collections

Stopping Collections

Preparing Oracle Trace Formatted Data

Formatting Collections

Formatting Data Using the Oracle Trace Manager

Formatting Data Using the Command-Line Interface

New otrcfmt Image for Oracle Server Release 8.0.4 (and 7.3.4)

Running Reports

Deleting Collection Entries

Deleting Formatted Data

Deleting Collection Files

4 Querying Oracle Trace Data

Optimizing Report Performance

Defining Synonyms

Defining the Elapsed Function

Creating Generic Reports

Generating an Occurrence Report

Reporting the Number of SQL Statements per Session

Generating Frequency Reports

Reporting the Frequency of Wait Events

Reporting the Frequency of Logical Transactions

Generating Statistical Reports

Analyzing Resource Wait Times

Reporting Summary Performance Data

Creating Specialized Reports

Generating Summary Data for Each Statement

Analyzing SQL Library Cache Performance

Analyzing Fetches and Rows per Cursor Execution

Reporting the Number of Executions per Command Type

SQL*Net User Events for a Database Session

SQL*Net Event Listing

Producing Oracle Trace Reports

A Using Oracle Trace for Oracle Server Data Collections

Using Oracle Trace for Server Performance Data Collection

Using INIT.ORA Parameters to Control Oracle Trace

Oracle Trace INIT.ORA Parameters

Using Stored Procedure Packages to Control Oracle Trace

Oracle Trace Collection Results

Oracle Server Events

Data Items Collected for Events

Resource Utilization Items

Cross-Product Items

Items Specific to Oracle Server Events

Items Associated with Each Event

Event Statistics Block

Connection Event

Disconnect Event

ErrorStack Event

Migration Event

RowSource Event

RowSource Event (Specific to Oracle Server Release 8.0.2 and Higher)

SQLSegment Event

LogicalTX Event

PhysicalTX Event

B Oracle SQL*Net Events

Items Associated with Each Event

User, Admin, Dev, Error, and Fatal Events

Copyright © 1997 Oracle Corporation.
All Rights Reserved.