GLOBAL_DOUBLE_WRITE_STATUS
GLOBAL_DOUBLE_WRITE_STATUS displays doublewrite file status of 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. |
curr_dwn |
bigint |
Sequence number of the doublewrite file. |
curr_start_page |
bigint |
Start page for restoring the doublewrite file. |
file_trunc_num |
bigint |
Number of times that the doublewrite file is reused. |
file_reset_num |
bigint |
Number of reset times after the doublewrite file is full. |
total_writes |
bigint |
Total number of I/Os of the doublewrite file. |
low_threshold_writes |
bigint |
Number of I/Os for inefficient doublewrite files. |
high_threshold_writes |
bigint |
Number of I/Os for efficient doublewrite files. |
total_pages |
bigint |
Total number of pages that are flushed to the doublewrite file area. |
low_threshold_pages |
bigint |
Number of pages that are flushed with low efficiency. |
high_threshold_pages |
bigint |
Number of pages that are flushed with high efficiency. |
file_id |
bigint |
ID of the current doublewrite file. |
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