Ramin Hossaini

Enabling Trace


The TRACE_ENABLED parameter allows you to trace the execution history of Oracle. It should be set to TRUE by default.

The information gathered is stored in the following locations:


These locations could be different depending on what’s set in your PFILE.

Check if trace is enabled:

SHOW parameter trace_enabled;

Sample output:

SQL> show parameter trace_enabled;
NAME                      TYPE      VALUE
------------------------- --------  --------------
trace_enabled             BOOLEAN   TRUE

And if it isn’t enabled, enable it using:

ALTER SYSTEM SET trace_enabled = TRUE;

Note: Prior to version Oracle 9i, this parameter was: _trace_enabled

Leave a Reply

Your email address will not be published. Required fields are marked *