Oracle教程

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

本站中文解释

V$LOGSTDBY_STATS是一个视图，能够查看系统实时但只读的归档日志应用情况。它允许检查基本配置，以及如何应用到数据库中归档日志数据。

使用Oracle视图V$LOGSTDBY_STATS：

1.通过查看FINISHED_SEQUENCE字段，可以检查归档日志应用到数据库中的最新序列号，通过这个序列号可以确认应用到数据库中是最新的。

2.查看STARTED_SEQUENCE字段，可以检查系统正在应用的归档日志序列号。

3.查看WAIT_SECONDS字段，可以检查从开始应用归档日志到完成的时间。

4.查看SCHEMA_NAME字段，可以检查归档日志应用到的模式名称。

5.查看ARCHIVED_LOGS字段，可以检查系统对归档日志的累计应用的数量。

官方英文解释

V$LOGSTDBY_STATS displays statistics, current state, and status information related to SQL Apply.

No rows are returned from this view when SQL Apply is not running. This view is only meaningful in the context of a logical standby database.

All statistics shown in this view are reinitialized at each SQL Apply start.

Column Datatype Description

NAME

VARCHAR2(64)

Name of the statistic, state, or status:

Note: Many of the following statistics are subject to change or deletion; programmers should write application code to tolerate missing or extra statistics.

  • id of the logminer session used by SQL Apply to mine the redo logs.

  • number of preparers

  • number of appliers

  • server processes in use for SQL Apply

  • maximum SGA (in MBytes) for LCR cache

  • whether SQL Apply is preserving the commit order seen at the primary database while applying changes

  • maximum events recorded in the DBA_LOGSTDBY_EVENTS table

  • whether SQL Apply is logging errors that are skipped in the DBA_LOGSTDBY_EVENTS table

  • whether SQL Apply is logging DDLs that are skipped in the DBA_LOGSTDBY_EVENTS table

  • whether SQL Apply is logging DDLs that are applied in the DBA_LOGSTDBY_EVENTS table

  • whether SQL Apply is logging unsupported operations that are encountered in the DBA_LOGSTDBY_EVENTS table

  • whether or not real time apply is on

  • value of apply delay (in minutes)

  • coordinator state

  • coordinator uptime in seconds

  • time of the most recent start of SQL Apply

  • number of transactions mined and made available for apply

  • number of transactions applied

  • number of rolled back transactions mined

  • number of DDL txns mined

  • number of CTAS (Create Table as Select) txns mined

  • number of thread enable events encountered in the redo stream

  • number of thread disable events encountered in the redo stream

  • bytes of redo records mined

  • bytes paged out

  • seconds spent in pageout activity

  • bytes checkpointed

  • seconds spent in checkpointing activity

  • seconds SQL Apply is idle

  • number of times a complete standby redo logs are mined without having to mine the corresponding archived log

  • number of times SQL Apply had to switch from a standby redo log to the corresponding archived log

  • number of times SQL Apply mined redo from the archived logs

  • number of archived logs that arrived at the standby via gap fetch mechanism (gap fetched logs mined)

  • number of failed attempts to open a logfile

  • amount of time spent in waiting for the current gap to resolve if SQL Apply is running in real time mode (current logfile wait)Foot 1

  • time spent in waiting for gap to resolve if SQL Apply is running in real time mode (total logfile wait)Foot 2

VALUE

VARCHAR2(64)

Value of the statistic or state information

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

Footnote 1

In case SQL Apply is not running in real time mode, this may not reflect time spent in gap resolution, but simply the time spent waiting for the most recent archived log to show up at the logical standby.

Footnote 2

In case SQL Apply is not running in real time mode, this will include time that SQL Apply spent every time it finished processing all archived logs registered with it, and waited for the next log to be archived.


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

相关推荐