Page History

...

• New SQL Text enables tuning via manual entry, or cutting and pasting into the tuning window.
• Extract from Database Objects enables you to select stored SQL from the data source to which you are connected. You can either drag and drop objects from the Data Source Explorer or you can add database objects matching specified filers. For example, entering t in the filter area of the Data Source Objects Selection dialog, can match functions, materialized views, procedures, and views, whose name begins with t. You can then drag and drop the matches from the Data Source Explorer to the Tuning Statements grid.
• The Import from File (Workspace) and Import from File (System) options enables you to choose an SQL file saved in your workspace or elsewhere on your computer or network.
• The Scan Oracle SGA option is available for the Oracle platform only. It enables you to scan for and select active SQL in the System Global Area (SGA). For more information, see Tuning SQL Statements statements in the System Global Area (Oracle).

...

1. From the New SQL Text menu, select Scan Oracle SGA.
2. The system scans for SQL text which you can filter on the Scan SGA dialog that appears.
3. Choose the statement to be tuned and then click Finish.