Using the Active Processes by dialog box
In the Active Processes by <sort order> dialog box, you can view the SQL statements for processes by performing the following task:
- Select (highlight) the processes for which you want to see the SQL statements.
- Click Show SQL.
The SQL statements are displayed in a task output window. The Active Processes by <sort order> dialog box remains open so that you can select more processes. Each time you select a process and click Show SQL, the SQL statement is appended to the report in the task output window. - When you are finished, click Done.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*