Set Log_Trace Statement

You can use the log_trace option of the set statement to start and stop tracing of logfile writes. Using this option requires the trace privilege.

Important! Do not use set log_trace only as a debugging or tracing tool. Do not base applications on Set log_trace output because it is not guaranteed to remain the same across releases. You are not guaranteed of the support of set log_trace in this or future releases.

To start tracing log writes, issue the following statement:

set log_trace;

To stop tracing log writes, issue the following statement:

set nolog_trace;

When you use set log_trace during a session, you receive a list of the log records written during execution of your query, along with other information about the log. Set log_trace output includes:

• The length of the log and the amount of space reserved for its CLR. For more information on CLRs, see Log Space Reservation.
• If the log write is a normal log record (do/redo) or a CLR.
• If the log record can be copied to the journal file.

  If the log is associated with a special recovery action.