Oracle Enterprise Manager Oracle Trace Developer's Guide
Release 1.4.0
A53697_01
Library
Product
Contents
Index
Send Us Your Comments
Preface
1 Overview
Users of Oracle Trace Data
Oracle Products Instrumented with Oracle Trace API
Adding Instrumented Products to Your Oracle Trace Environment
2 Oracle Trace Architecture
Oracle Trace Concepts
Product Definition
Event
Item
Event Set
Collection
Process
Oracle Trace Runtime Behavior
Initialization
Starting a Collection
Collecting Data
Ending a Collection
Formatting Collected Data
Using the Oracle Trace Command-Line Interface
Starting a Collection
Stopping a Collection
Formatting Collection Files
Deleting Collection Files
Deleting Formatted Data
3 Oracle Trace Methodology
Designing Your Data Model
Events
Items
Design Considerations
Creating the Product Definition
Writing User Documentation
Adding Oracle Trace API Calls
Preparing to Collect Data
Recording Events
Managing Collections
Compiling Your Instrumented Application
Collecting the Data
Formatting the Data
Analyzing the Data
4 Advanced Topics
More About Items
Resource Items
Cross-Product Items
How Cross-Product Items Work
Using Cross-Product Items to Correlate Events
Passing Cross-Product Items to Remote Processes
Registration IDs
Event Sets
Multi-Thread Support
5 Creating Product Definitions
Running Oracle Trace in Administrative Mode
What Is a Product Definition?
Create Product Property Page
Adding Items to a Product Definition
Editing Items
Removing Items from a Product Definition
MSB
Adding Events
Adding Duration Events
Removing Start Event and End Event Items
Ordering Event Items
Adding Point Events
Removing Event-Specific Items
Ordering Event Items
Editing Events
Removing Events from a Product Definition
Adding Event Sets to a Product Definition
Removing Events from an Event Set
Editing Event Sets for a Product Definition
Removing Event Sets from a Product Definition
Editing Existing Product Definitions
6 Producing Reports and Formatting Data
Producing Oracle Trace Reports
Using Oracle Trace Data with Other Reporting Tools
Preparing Oracle Trace Formatted Data
Formatting Data Using the Oracle Trace Manager
Formatting Data Using the Command-Line Interface
Deleting Formatted Data
Querying Formatted Data
Optimizing Report Performance
Defining Indexes
Defining Synonyms
Defining the Elapsed Function
Generating Summary Data for Each Statement
Generic Report Templates
Generating an Occurrence Report
Reporting the Number of Connection Events
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
Specialized Reports
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 Names
7 Oracle Trace Routines
Calling Oracle Trace Routines
Datatypes
Data Structures
Event Collection Flags Array
User-Defined Buffer
Parameter Classification
Required Parameters
Optional Parameters
Parameter Descriptions
Return Values
epc_add_reg_id
epc_cancel
epc_cf_value
epc_check_ef (Specific to Oracle8 Databases)
epc_collect
epc_context
epc_delete_context
epc_drop_fac (Oracle Server Release 8.0 Only)
epc_end_event
epc_event
epc_flush
epc_get_cf_items
epc_init
epc_remove_reg_id
epc_set_cf_items
epc_start_event
A Components of Oracle Trace
Files
Images
Processes
Interfaces
B Using Oracle Trace for Oracle Server Data Collections
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
C Oracle SQL*Net Events
Items Associated with Each Event
User, Admin, Dev, Error, and Fatal Events
Hex Event
Time Event
CF3 Event
D Oracle Trace Format Database
Oracle Server
Oracle Trace Supported Datatypes
Tables for Control Information
Tables for Collected Event Data
E Sample Instrumented Application
Events in the Sample Application
Running the ATM Sample Application
Index
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents
Index
