LOGSTATISTICS

Prerequisites

Log on to the database instance DEMODB.

Examples

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

·        Size of the log area and used log area

SELECT usablesize, usedsize, usedsizepercentage
  FROM SYSINFO.LOGSTATISTICS

·        Number of log queues and their size(s)

SELECT queuecount, queuesize
  FROM SYSINFO.LOGSTATISTICS

·        Size of the log area that has not yet been backed up

SELECT notsavedsize, notsavedpercentage
  FROM SYSINFO.LOGSTATISTICS