Drilling down by SQL statement type

Review statistical information about an SQL statement by using query drill-down by statement type.

Prerequisite: For query drill-down, SQL Tracing must be set to On. See Turning on SQL tracing.

To drill down by SQL type:

  1. On the OAT menu, click Performance Analysis > SQL Explorer. The SQL Explorer pages are displayed. The statements that were executed on the system are grouped by type along with summary statistics for each SQL statement group.
  2. Click the drill-down icon for a statement type. A list of the SQL statements of that were run is displayed. You can continue to drill down by clicking the drill-down icon for a statement and then for a statement execution. Statistics for the statement are displayed.
Parent topic: Analyzing query performance with SQL Explorer
Copyright© 2018 HCL Technologies Limited