Viewing Journal Status

How To

The journal status page displays operating system statistics from the SYSINFO table. Journal status items and their corresponding SYSINFO.INFO values are summarized in Table.

Journal Status Items

Description

Number of journal blocks read from journal files

The accumulated number of journal block reads in the current run time. (NUM_JNL_BLK_READ)

Number of journal blocks written to journal files

The accumulated number of journal block writes in the current run time. (NUM_JNL_BLK_WRITE)

Number of journal records generated

The accumulated number of journal record writes in the current run time. (NUM_JNL_REC_WRITE)

Number of journal forced writes

The accumulated number of journal force writes in the current run time. (NUM_JNL_FRC_WRITE)

Number of journal files

The number of blocks set in a journal file. (NUM_JOURNAL_FILE)

Number of journal blocks in a file

The number of journal blocks in each journal file. (NUM_JOURNAL_BLOCKS)

Number of free journal blocks

The current number of free journal blocks in all journal files. (NUM_JNR_BLOCK_FREE)

File number of the currently used journal file

For databases with multiple journal files, the number of the current journal file (CURRENT_JOURNAL_FN)

The current block number of the journal file

The number of the currently used journal block. (CURRENT_JOURNAL_BN)

Table:Journal Status items 


Related topic:

Monitoring Database Status
Transaction Information