Ramin Hossaini

Enabling Trace

Mar
09

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:

#User:
/usr/oracle/admin/sid/udump
#Background:
/usr/oracle/admin/sid/bdump
#Core:
/usr/oracle/admin/sid/cdump

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 *