Viewing query monitoring results

You can view and tune the SQL statements and query workloads that are identified by your normal or exception monitor profiles.

Before you begin

About this task

Before the first consolidation is complete, no information is available from a monitor profile, even if monitored SQL statements have run. At the end of each consolidation interval, information about the SQL statements that are monitored by each monitor profile is written to the subsystem. After each consolidation, you can use the to view, analyze, and tune the monitored SQL statements.

Procedure

To view the query monitoring result and tune the workload or individual SQL statements:

  1. To open the Monitor List view, click the Monitor List tab. If the tab is not visible, click Window > Show View > Monitor List.
  2. In the Monitor List view, select the subsystem for the SQL statements that you monitor from the list, and connect the client to this subsystem if the connection is not opened.
  3. In the monitor profile list, double-click the monitor profile, for which you want to view the result. The Statements page of the workflow assistant for query tuning opens. All captured statements are displayed in the statement list, and these statements are grouped as a workload in the workload list.

What to do next

Analyze and tune the workload as a group or individual SQL statements with the workflow assistant for query tuning.

Feedback