Toad World® Forums

Auto Trace without Data Results Displayed

Is it possible to Execute Statement (F9) a query with Auto Trace Enabled, but to not return the results into the Data Grid?

Is it possible to Execute as Script (F5) a query with Auto Trace Enabled, but to not return the results into the Script Output (Output and Grid 1)?

This would allow one to capture the statistics on the query without trying to display all of the actual results. This would be comparable to "SET AUTOTRACE TRACE ONLY". As defined in the Oracle docs (19c): "Like SET AUTOTRACE ON, but suppresses the printing of the user's query output, if any. If STATISTICS is enabled, query data is still fetched, but not printed."

Toad for Oracle 13.3.0.181

No.

I would recommend running with F9 instead of F5 for this kind of thing. F5 does a lot more work when it fetches results, and it fetches ALL results. F9 only fetches 500 rows (or so) by default. Then if you scroll down in the grid, it will fetch more as you scroll.

You can make it fetch fewer in Options -> Oracle -> General, -> OCI Array Buffer Size. But I recommend that you leave it on Automatic.

What I mean is, you can't disable output in either F5 or F9.

You can limit with with F9 and OCI Buffer Size.