Download JProbe User Guide

Exploring Performance Analysis Views
Exploring the Summary View
291
The SQL Statements section displays the time required to execute SQL statements. The
following table lists the type of information displayed in the SQL Statements table.
Parameter
Information Provided
SQL
Represents the SQL statement, truncated to 50 characters.
JProbe provides several truncation options. For details,
see Setting Preferences for Performance Views.
Note
Each instance of a prepared or a callable statement that
uses a particular SQL string is represented by its own row.
However, batch execution (which contains more than one
SQL statement) is represented in the SQL column only by
an asterisk (*). Select the row, right-click, and select View
SQL Statements to display all the statements represented
by that row.
Method
Displays the name of the JDBC method used to execute
the query.
Calls
Displays how many times the JDBC method was called.
CPU Cml
Displays the CPU cumulative time.
Elap Cml
Displays the elapsed cumulative time.
By double-clicking a row in the SQL Statements section you open the Methods view
with the graph associated with the row as the focus node. By selecting a row in the SQL
Statements section, right-clicking, and selecting the appropriate option, you can
investigate where the selected statements were executed or the statement’s SQL was
collected.
The Show only DML check box is by default selected, restricting the SQL statements
shown to the appropriate statement types (that is, only a subset of SQL statements—
known as DML (Data Manipulation Language)—is displayed). To display all collected
SQL statements, clear the Show only DML check box. DML statement types are
appropriate for tuning using Quest’s SQL Optimizer for Oracle.
To tune an SQL statement:
1 Install Quest’s SQL Optimizer for Oracle on the machine that will run the JProbe
Console.
Note
For information about this product, refer to the SQL Optimizer for Oracle
documentation set.