Capturing SQL statements from Optim Performance Manager

You can tune SQL statements that you are monitoring in Optim™ Performance Manager.

Before you begin

Procedure

To capture an SQL statement from Optim Performance Manager:

In Optim Performance Manager, select the SQL statement and click the Tune button. This button is located in several locations, such as the Active SQL dashboard, the Locking dashboard, and reports. Refer to the documentation for Optim Performance Manager for details. The workflow assistant for query tuning opens to the Run All Single-Query Advisors and Analysis Tools page of the Invoke section. The SQL statement appears in the Query Text field.

For help on the Run All Single-Query Advisors and Analysis Tools page, click the Help button at the top of the page or in the two sections. You can also click at the top of the page or in a section and then press F1.


Feedback