LOGQUEUESTATISTICS

Prerequisites

Log on to the database instance DEMODB.

Examples

You can use the system tableLOGQUEUESTATISTICS to determine the following database information, among other things:

·        ID of the log queue

SELECT QUEUEID
  FROM SYSINFO.LOGQUEUESTATISTICS

·        Number of wait situations due to log queue overflow

SELECT QUEUEOVERFLOWCOUNT
  FROM SYSINFO.LOGQUEUESTATISTICS