Oracle Enterprise Manager Oracle Trace User's Guide
Release 1.4.0
A53696_01

Library
Product
Index

Next

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
Left Pane
Right Pane
Toolbar Icons
Viewing Oracle Trace Manager Menus
File Menu
Edit Menu
View Menu
Collection Menu
Product Menu
Help 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: Name Collection Definition File
Step 5: Schedule the Collection
Advanced Scheduling Options
Step 6: Select Formatting Option
Advanced Formatting Options
Summary Page
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
Running Reports
Deleting Collection Entries
Deleting Formatted Data
Deleting Collection Files

4 Querying Oracle Trace Data

Optimizing Report Performance
Defining Synonyms
Using Indexes
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
ApplReg Event
RowSource Event
RowSource Event (Specific to Oracle Server Release 8.0.2 and Higher)
SQLSegment Event
Wait Event
Parse Event
Execute Event
Fetch Event
LogicalTX Event
PhysicalTX Event

B Oracle SQL*Net Events

Items Associated with Each Event
User, Admin, Dev, Error, and Fatal Events
Hex Event
Time Event
CF3 Event

Index


Next
Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.

Library
Product
Index