How to run a SQL trace in SQL Editor? (4274741)

AutoTrace is a mini version of SQL Trace that displays quick results directly on the client. In Toad, the results are displayed beneath the Editor or the Query Builder window.

How does one enable this trace?

Right-click in the Editor and click the AutoTrace menu option.

To view AutoTrace results

In the Editor results area, click the AutoTrace tab.
If the AutoTrace tab is not visible, right-click and then select Desktop | Autotrace.

The AutoTrace results panel will display and every statement issued in AutoTrace mode will have results generated.

Note: AutoTrace will force a read of all data from the result of the query.
This can take some time. If a query will return a large number of rows, and time is a factor, AutoTrace is not advisable.

From the AutoTrace results area you can sort columns, print the grid, and copy the results to the clipboard.