Oracle教程

Oracle 视图 V$DATAGUARD_STATS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图V$DATAGUARD_STATS用于显示特定的Data Guard保护模式下的日志收发统计信息。可以查看活动的standby数据库的各个归档量或在LGWR和ARCn中进行备份的日志量。

使用方法：用户可以使用下面的SELECT语句来查询V$DATAGUARD_STATS视图：

SELECT *
FROM V$DATAGUARD_STATS;

该语法将返回关于Data Guard保护模式下日志收发统计信息的表格。此表不仅包括当前正在处理的日志，还包括未处理的日志数量和已成功收发的日志数量。

官方英文解释

V$DATAGUARD_STATS displays information about Oracle Data Guard metrics when queried on a standby database. No rows are returned when queried on a primary database.

Column Datatype Description

SOURCE_DBID

NUMBER

Database ID of the protected source database

SOURCE_DB_UNIQUE_NAME

VARCHAR2(32)

DB unique name of the protected source database

NAME

VARCHAR2(32)

Name of the metric:

  • APPLY FINISH TIME – An estimate of the time needed to apply all received, but unapplied redo from the primary database. If there are one or more redo gaps on the standby database, an estimate of the time needed to apply all received, but unapplied redo up to the end of the last archived redo log before the beginning of the earliest redo gap.

  • APPLY LAG – Apply lag is a measure of the degree to which the data in a standby database lags behind the data in the primary database, due to delays in propagating and applying redo to the standby database. This value is relevent only to the applying instance.

  • TRANSPORT LAG – Transport lag is a measure of the degree to which the transport of redo to the standby database lags behind the generation of redo on the primary database. If there are one or more redo gaps on the standby database, the transport lag is calculated as if no redo has been received after the beginning of the earliest redo gap.

  • ESTIMATED STARTUP TIME – An estimate of the time needed to start and open the database.

VALUE

VARCHAR2(64)

Value of the metric

UNIT

VARCHAR2(30)

Unit of measurement

TIME_COMPUTED

VARCHAR2(30)

Local time at the standby database when the metric was computed

DATUM_TIME

VARCHAR2(30)

Local time at the standby database when the datum used to compute the metric was received

The APPLY LAG and TRANSPORT LAG metrics are computed based on data that is periodically received from the primary database. An unchanging value in this column across multiple queries indicates that the standby database is not receiving data from the primary database.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$DATAGUARD_STATS 官方解释，作用，如何使用详细说明
分享到：

相关推荐