Oracle教程

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

本站中文解释

V$LOGSTDBY_PROCESS视图提供了异步增量重做日志运行时在当前　Logical Standby 数据库中要求执行的操作的详细信息。

用途：

V$LOGSTDBY_PROCESS视图为实施Oracle数据库应用程序中的Logical Standby提供了有用的信息，它用于监视和控制异步增量重做日志执行过程。

使用：
可以使用V$LOGSTDBY_PROCESS视图获取Redo Apply着色操作中开启的项目，以及它的状态、执行结果、任务编号和错误。

例如，要检查设施正在正常运行，可以执行以下查询：

SELECT *
FROM V$LOGSTDBY_PROCESS;

官方英文解释

V$LOGSTDBY_PROCESS displays dynamic information about what is happening to the Data Guard log apply services.

This view is helpful when diagnosing performance problems during the logical application of archived redo logs to the standby database, and it can be helpful for other problems. This view is for logical standby databases only.

Column Datatype Description

SID

NUMBER

Session id of the associated session. This matches the SID column of the corresponding row in the V$SESSION view.

SERIAL#

NUMBER

Serial number of the associated session. Together, (SID,SERIAL#) uniquely identify the session in the current database instance.

LOGSTDBY_ID

NUMBER

Parallel query slave ID

SPID

VARCHAR2(24)

This corresponds to the SPID value of the row corresponding to this process in the V$PROCESS view

TYPE

VARCHAR2(128)

Role that the process plays in the context of SQL Apply:

  • COORDINATOR

  • APPLIER

  • ANALYZER

  • READER

  • PREPARER

  • BUILDER

STATUS_CODE

NUMBER

Operation code identifying the current action of the process:

  • 16111 – SQL Apply process is initializing

  • 16112 – SQL Apply process is cleaning up as apply and mining processes are stopping based on a user command

  • 16116 – SQL Apply process is idle

  • 16117 – SQL Apply process is busy and is not waiting on any interesting event

  • 16110 – APPLIER process has invoked a user-provided stored procedure in order to inspect a DDL statement prior to it being processed

  • 16113 – APPLIER process is applying DML changes to some user object or to a sequence

  • 16114 – APPLIER process is applying a DDL change

  • 16115 – COORDINATOR process is loading the LogMiner dictionary from the redo stream

  • 16243 – BUILDER process is paging out memory to free up space in lcr cache

  • 16240 – READER process idle waiting for additional logfile to be available

  • 16241 – READER process is idle waiting for the logfile to fill the log sequence gap

  • 16242 – READER process is processing a logfile

STATUS

VARCHAR2(256)

Description of the current action of the process

HIGH_SCN

NUMBER

Identifies the highest redo record/LCR processed by this process

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

相关推荐