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.

转载于:https://www.cnblogs.com/feishunji/archive/2011/07/12/2104373.html