Capturing snapshots of monitored SQL statements

You can capture snapshots of the monitored SQL statements to verify performance improvements.

Before you begin

About this task

When the snapshot operation completes, information about the SQL statements that are in the scope of the specified sources for the monitor profile, including SQL statements that remain in the statement cache, is consolidated to the subsystem immediately. you can use the to view the SQL statements.

Procedure

To capture a snapshot of the monitored 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. Select an existing normal monitor profile and click Schedule > Snapshot.
  4. In the Schedule Snapshot window, specify whether to use client or server-side scheduling and other options for the snapshot. If you select client-side scheduling, the must remain connected to the subsystem until the scheduled start time for the snapshot.
  5. Click OK. A snapshot for the monitored SQL statements is scheduled.

Feedback