LOGQUEUESTATISTICS

Definition

The system table LOGQUEUESTATISTICS specifies the number of times certain logging-related events were counted per log queue since the last start of the database instance.

Structure

LOGQUEUESTATISTICS

QUEUEID

FIXED(5)

ID of the log queue

QUEUEMAXUSED

FIXED(5)

Number of write transactions

QUEUEINSERTCOUNT

FIXED(20)

Number of log entries inserted into the log queue

QUEUEOVERFLOWCOUNT

FIXED(10)

Number of wait situations due to log queue overflow

GROUPCOMMITCOUNT

FIXED(10)

Number of log pages whose writing was waited for by more than one transaction

WAITCOUNT

FIXED(10)

Number of COMMIT-/ROLLBACK entries

MAXWAITCOUNTPERPAGE

FIXED(10)

Maximum number of transactions that simultaneously waited for the same log page to be written

PHYSICALWRITECOUNT

FIXED(10)

Number of write operations

See also:

Evaluating System Tables, LOGQUEUESTATISTICS

Concepts of the Database System, Logging Data Changes