Information that fall into the trace stats category is not filled in when using auto optimize option (4334158)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Information that fall into the trace stats category is not filled in when using auto optimize option
Description

When using auto optimize and checking the "Execution Statistics" tab (see below), I see Trace Stats(not setup) and the data there is not filled in. What do I need to enable and how in order to have all this information?
Cause

This information comes from SQL Optimizer
Resolution

In SQL Optimizer for Oracle go to Options | General | Trace Setup to setup trace. After that, you can get trace information in Toad:
By default, trace is disabled in SQL Optimizer
So Toad cannot get that information
Setup trace in SQL Optimizer for Oracle

And Toad displays this information now: