GLOBAL_DOUBLE_WRITE_STATUS
GLOBAL_DOUBLE_WRITE_STATUS displays the information about doublewrite files of all instances in the entire cluster.
| 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.
