GLOBAL_REDO_STAT

GLOBAL_REDO_STAT displays the total statistics of XLOG redo operations on all nodes in a cluster. Except the avgiotim column (indicating the average redo write time of all nodes), the names of the other columns in this view are the same as those in the PV_REDO_STAT view. The respective meanings of the other columns are the sum of the values of the same columns in the PV_REDO_STAT view on each node.

**Table 1** GLOBAL_REDO_STAT columns
Name	Type	Description
phywrts	bigint	Total number of physical writes on all nodes
phyblkwrt	bigint	Total number of physical write blocks on all nodes
writetim	bigint	Total physical write time of all nodes
avgiotim	bigint	Average redo write time of all nodes
lstiotim	bigint	Sum of the last write time of all nodes
miniotim	bigint	Sum of the minimum write time of all nodes
maxiowtm	bigint	Sum of the maximum write time of all nodes