LOGSTATISTICS

Definition

The system table LOGSTATISTICS describes the degree to which log management is being utilized and the number of special events that have occurred during logging since the start of the database instance.

Structure

LOGSTATISTICS

USABLESIZE

FIXED(20)

Size of the log area (KB)

USEDSIZE

FIXED(20)

Used log area (KB)

USEDSIZEPERCENTAGE

FIXED(3)

Used log area (%)

NOTSAVEDSIZE

FIXED(20)

Size of log area not yet saved (KB)

NOTSAVEDPERCENTAGE

FIXED(3)

Size of log area not yet saved (%)

SAVEPOINTCOUNT

FIXED(10)

Number of savepoints

TRANSACTIONCOUNT

FIXED(10)

Number of transactions

WRITETRANSACTIONCOUNT

FIXED(10)

Number of write transactions

MAXUSEDSESSIONID

FIXED(10)

Highest database session ID assigned

MAXUSEDTRANSACTIONNUMBER

FIXED(15)

Highest transaction ID assigned

QUEUECOUNT

FIXED(5)

Number of log queues

QUEUESIZE

FIXED(5)

Size of the log queue (KB)

See also:

Evaluating System Tables, LOGSTATISTICS

Concepts of the Database System, Logging Data Changes