Oracle Enterprise Manager Oracle Trace User's Guide
Library
Product
Preface
Purpose
Audience
How This Guide Is Organized
Part I: Collecting and Reporting Oracle Trace Data
Part II: Developer's Guide to Oracle Trace
Conventions Used in This Guide
Related Publications
Your Comments Are Welcome
Chapter 1 Overview
Using Oracle Trace
Collecting Event Data
Managing Collections
Accessing Data
Joining Event Data from Multiple Products
Adding Instrumented Products
Part I Collecting and Reporting Oracle Trace
Chapter 2 Using Oracle Trace
Starting Oracle Trace
Viewing the Oracle Trace Main Window
Left Pane
Right Pane
Toolbar Icons
Viewing Oracle Trace Menus
File Menu
Edit Menu
View Menu
Collection Menu
Product Menu
Help Menu
Discovering Products
Creating Collections and Viewing Collection Data
Formatting Data
Running Reports
Exiting Oracle Trace
Troubleshooting
Chapter 3 Creating, Formatting, and Deleting 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
Creating Like Collections
Stopping Collections
Formatting Collections
Deleting Collection Entries
Deleting Formatted Data
Deleting Collection Files
Chapter 4 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
Generating Frequency Reports
Generating Statistical Reports
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
Part II Developer's Guide to Oracle
Chapter 5 Instrumentation Guidelines
Know Why You Are Instrumenting
Know How Oracle Trace Interacts with an Application
Required Oracle Trace Routines
Decide What You Want to Know About Each Event
Compiling Your Instrumented Application
Create a Definition File for Your Product
Performance Impact of Instrumentation
Instrumenting a Multi-Threaded Application
Chapter 6 Relating Data Between Products
Methods for Passing Data Among Products
What Is the Cross-Product Mechanism?
Chapter 7 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
Chapter 8 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
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_cancel
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_cf_value
Purpose
Format
C Binding
Parameters
Description
Return Values
epc_collect
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_context
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_delete_context
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_end_event
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_event
Purpose
Format
C Binding
Parameters
Description
Return Values
epc_flush
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_get_cf_items
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_init
Purpose
Format
C Binding
Parameters
Description
Return Values
epc_remove_reg_id
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_set_cf_items
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
epc_start_event
Purpose
Format
C Binding
Parameters
Description
Return Values
See Also
Appendix 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
Using Stored Procedure Packages to Control Oracle Trace
Using the Oracle Trace Command Line Interface
Oracle Trace Collection Results
Additional Information: Oracle Trace INIT.ORA Parameters
Oracle Server Release 7.3 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
SQLSegment Event
Wait Event
Parse Event
Execute Event
Fetch Event
LogicalTX Event
PhysicalTX Event
Appendix B Oracle SQL*Net Release 2.3 Events
Items Associated with Each Event
User, Admin, Dev, Error, and Fatal Events
Hex Event
Time Event
CF3 Event
Appendix C Oracle Trace Format Database
Oracle7 Server Release 7.3
Oracle Trace Supported Datatypes
Tables for Control Information
Tables for Collected Event Data
Appendix D Sample Instrumented Application
Events in the Sample Application
Running the ATM Sample Application
[prev]
[next]
[top]
[bottom]
[contents]
[index]
Copyright © 1996, 1997, Oracle Corporation
Last Modified: 10:20am EST, February 07, 1997
