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.
