GLOBAL_CKPT_STATUS

GLOBAL_CKPT_STATUS displays the checkpoint information and log flushing information about all instances in the database, as described in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and the empty list is returned if this view is accessed in a PDB.

**Table 1** GLOBAL_CKPT_STATUS columns
Name	Type	Description
node_name	text	Instance name.
ckpt_redo_point	text	Checkpoint of the current instance.
ckpt_clog_flush_num	bigint	Number of Clog flushing pages from the startup time to the current time.
ckpt_csnlog_flush_num	bigint	Number of CSNlog flushing pages from the startup time to the current time.
ckpt_multixact_flush_num	bigint	Number of MultiXact flushing pages from the startup time to the current time.
ckpt_predicate_flush_num	bigint	Number of predicate flushing pages from the startup time to the current time.
ckpt_twophase_flush_num	bigint	Number of two-phase flushing pages from the startup time to the current time.