GLOBAL_PAGEWRITER_STATUS
GLOBAL_PAGEWRITER_STATUS displays the page flushing information and checkpoint 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. |
pgwr_actual_flush_total_num |
bigint |
Total number of dirty pages flushed from the startup to the current time. |
pgwr_last_flush_num |
integer |
Number of dirty pages flushed in the previous batch. |
remain_dirty_page_num |
bigint |
Estimated number of remaining dirty pages. |
queue_head_page_rec_lsn |
text |
recovery_lsn of the first dirty page in the dirty page queue of the current instance. |
queue_rec_lsn |
text |
recovery_lsn of the dirty page queue of the current instance. |
current_xlog_insert_lsn |
text |
The write position of Xlogs in the current instance. |
ckpt_redo_point |
text |
Checkpoint of the current instance. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot