[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 Ingres Database Administrator Guide.