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.
| 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. |
