#acl merlyn:read,write All:read

= Tracing an entire database =
To enable SQL tracing for the entire database, execute:

 * ALTER SYSTEM SET sql_trace = true SCOPE=MEMORY;

To stop, execute:

 * ALTER SYSTEM SET sql_trace = false SCOPE=MEMORY;

{{{
Trace output is written to the database's UDUMP directory.

The default name for a trace files is INSTANCE_PID_ora_TRACEID.trc where:

INSTANCE is the name of the Oracle instance,
PID is the operating system process ID (V$PROCESS.OSPID); and
TRACEID is a character string of your choosing.
}}}




= References =
 http://www.orafaq.com/wiki/SQL_Trace