Performance Analysis
Performance Trace Overview
Architecture and Navigation
Initial Screen
Recording Performance Data
Starting the Trace
Stopping the Trace
Analyzing Performance Data
Display Filter
Other Filters
Displaying Lists of Trace Records
Analyzing Trace Records
SQL Trace Analysis
Embedded SQL
Measured Database Operations
Logical Sequence of Database Operations
Buffering
Analyzing a Sample SQL Data File
Example Explanation of an Oracle Statement
Example Explanation of an Informix Statement
Enqueue Trace Analysis
Enqueue Trace Records
Detailed Display of Enqueue Trace Records
RFC Trace Analysis
RFC Trace Records
Detailed Display of RFC Trace Records
Table Buffer Trace Analysis
Table Buffer Trace Records
Detailed Display of the Table Buffer Trace Records
Additional Functions
Saving Lists Locally
The Function Execute Explain for SQL Statements
Using the Dictionary Information Function
Summarizing Trace Lists