V$DATAGUARD_STATS
displays how much redo data generated by the primary database is not yet available on the standby database, showing how much redo data could be lost if the primary database were to crash at the time you queried this view. You can query this view on any instance of a standby database in a Data Guard configuration. If you query this view on a primary database, then the column values are cleared.
Column | Datatype | Description |
---|---|---|
NAME |
VARCHAR2(32) |
The parameter name can be any of the following:
|
VALUE |
VARCHAR2(64) |
Value of the parameter. For example, the APPLY FINISH TIME parameter value +00 00:00:01.7 indicates the standby database needs 1.7 seconds to finish applying the remaining redo data. |
UNIT |
VARCHAR2(30) |
Time unit for the parameter, displayed as day (2) to second (n ) interval, where n is 0 or 1. |
TIME_COMPUTED |
VARCHAR2(30) |
Local time on the standby database when the value of the parameter is computed or sampled. |