Drilling down from the activity summary

Review statistical information about SQL statements 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 on an SQL statement:

  1. On the OAT menu, click Performance Analysis > SQL Explorer. The SQL Explorer pages are displayed.
  2. Click the drill-down icon for an SQL statement type, or click the Transactions tab and then click the drill-down icon for a transaction. You can continue to display more detailed information by clicking the drill-down icons.
Parent topic: Analyzing query performance with SQL Explorer
Copyright© 2018 HCL Technologies Limited