Sql Trace

讲述如何跟踪sql语句.[@more@]

Start session trace

You can also add an identifier to the trace file name for later identification:

Stop session trace

Tracing other user's SQL

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.

Formating output

The TKProf utility can be used to format trace output

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/60088/viewspace-891600/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/60088/viewspace-891600/