Drilling down by transaction

Review statistical information about the SQL statements for a transaction by using query drill-down.

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

To drill down by transaction:

  1. On the OAT menu, click Performance Analysis > SQL Explorer. The SQL Explorer pages are displayed.
  2. To display a list of transaction times for the 100 most recent transactions, click the Transactions tab.
  3. Click the drill-down icon for a transaction. A list of the SQL statements that ran for the transaction is displayed. Click the drill-down icon to display statistics for a statement.
Parent topic: Analyzing query performance with SQL Explorer
Copyright© 2018 HCL Technologies Limited