GLOBAL_SINGLE_FLUSH_DW_STATUS

The GLOBAL_SINGLE_FLUSH_DW_STATUS view displays the information about the eliminated doublewrite file on a single page of all instances in the entire cluster. The information before the slash (/) is the page refresh information of the first version of the doublewrite file, and that after the slash (/) is the page refresh information of the second version of the doublewrite file.

**Table 1** GLOBAL_SINGLE_FLUSH_DW_STATUS columns
Name	Type	Description
node_name	text	Instance name.
curr_dwn	text	Sequence number of the doublewrite file.
curr_start_page	text	Start position of the current doublewrite file.
total_writes	text	Total number of data write pages in the current doublewrite file.
file_trunc_num	text	Number of times that the doublewrite file is reused.
file_reset_num	text	Number of reset times after the doublewrite file is full.