Ramin Hossaini (blog)

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:

#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

Related posts:

1. Backing up an Oracle database without RMAN
2. Oracle: List all database-links
3. Turning Archive-log mode on and off
4. Listing key Oracle Database files
5. Oracle: Recovering a Tablespace