Updated on 2025-05-29 GMT+08:00

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.

Table 1 GLOBAL_DOUBLE_WRITE_STATUS columns

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.