The syssqltrace_info table describes information about the SQL profile trace system.

Column Type Description
flags integer SQL trace flags
ntraces integer Number of items to trace
tracesize integer Size of the text to store for each SQL trace item
duration integer Trace buffer (in seconds)
sqlseen int8 Number of SQL items traced since start or resizing
starttime integer Time tracing was enabled
memoryused int8 Number of bytes of memory used by SQL tracing

Copyright© 2018 HCL Technologies Limited