SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > [NO]LOG_TRACE
Was this helpful?
[NO]LOG_TRACE
SET LOG_TRACE starts tracing of logfile writes. To stop tracing of logfile writes, use the SET NOLOG_TRACE statement. Using this option requires trace privilege.
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, including:
• The length of the log and the amount of space reserved for its CLR
• 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
For information on the use of the SET LOG_TRACE statement, see the Database Administrator Guide.
Last modified date: 08/29/2024