Oracle教程

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

本站中文解释

Oracle视图V$ARCHIVE_GAP是在数据库的归档模式运行的状态时查询归档日志的可用性的技术细节的一视图。 该视图报告未归档的日志块数，这些日志块由ARCHOS程序运行并在disk上被写入。

V$ARCHIVE_GAP视图可以被用来监视日志序列是否存在中断，特别是当服务器繁忙时可能会出现性能问题。

使用V$ARCHIVE_GAP视图非常简单，可以在SQL*Plus中运行SELECT语句查询特定的信息以及相关的记录：

SQL> SELECT thread#, MIN (sequence#) AS “FIRST”
FROM V$ARCHIVE_GAP
GROUP BY thread#;

== 可以查看线程号与对应的第一个未归档日志块数，通过这样的简单查询可以定位哪些日志块需要立即归档，以及在何处存在着差距。

官方英文解释

V$ARCHIVE_GAP displays information about archive gaps on a standby database. This view can be used to find out the current archive gap that is blocking recovery for the current recovery incarnation.

Column Datatype Description

THREAD#

NUMBER

Thread number of the missing archived redo log files. The number is 1 for a single instance. For Oracle Real Application Clusters, this column will contain different numbers.

LOW_SEQUENCE#

NUMBER

Lowest sequence number of the log files received on the standby system

HIGH_SEQUENCE#

NUMBER

Highest sequence number of the log files received on the standby system

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$ARCHIVE_GAP 官方解释，作用，如何使用详细说明
分享到：

相关推荐