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.