Oracle sql trace

http://orafaq.com/wiki/SQL_Trace

 

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;

Identifying trace files

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.

For me the path locates at \app\Figo.Fei\diag\rdbms\orcl\orcl\trace

when search in Windows, pls notice that some folders are inaccessible, which need to be set by manual.