Oracle 视图 ALL_XSTREAM_OUTBOUND_PROGRESS 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图ALL_XSTREAM_OUTBOUND_PROGRESS是一种特殊的视图,它提供有关特定XStream Outbound应用程序的进度信息。它可以用来监控XStream Outbound应用的应用程序状态,以便更有效地处理数据。它可以查询有关当前XStream Outbound进程的信息,包括此进程的时间、传输会话ID、目标端点名称和记录ID,以便更好地了解当前XStream Outbound进程的运行情况。

要使用ALL_XSTREAM_OUTBOUND_PROGRESS视图,用户首先需要访问Oracle数据库,并使用正确的权限(如dba或sysdba)授予相应用户查询愿View的权限。授权后,可以使用SELECT语句查询ALL_XSTREAM_OUTBOUND_PROGRESS视图,以获取XStream Outbound应用程序的进度信息。也可以使用其他查询语句,如JOIN,WHERE等,对视图中的内容进行更复杂的筛选和分析。

官方英文解释

ALL_XSTREAM_OUTBOUND_PROGRESS displays information about the progress made by the XStream outbound servers accessible to the current user.

Related View

DBA_XSTREAM_OUTBOUND_PROGRESS displays information about the progress made by all XStream outbound servers in the database.

Column Datatype NULL Description

SERVER_NAME

VARCHAR2(128)

NOT NULL

Name of the outbound server

SOURCE_DATABASE

VARCHAR2(128)

Global name of the database where the transaction originated. For a PDB, this is the global name of the PDB.

PROCESSED_LOW_POSITION

RAW(64)

Position of the low-watermark transaction processed by the outbound server

PROCESSED_LOW_TIME

DATE

Time when the processed low position was last updated by the outbound server

OLDEST_POSITION

RAW(64)

The position of the earliest LCR that is required by the XStream client application

SOURCE_ROOT_NAME

VARCHAR2(128)

The global name of the source root database

PROCESSED_LOW_SCN

NUMBER

NOT NULL

SCN of the processed low transaction

OLDEST_SCN

NUMBER

NOT NULL

Oldest SCN of the transactions currently being captured

See Also:

“DBA_XSTREAM_OUTBOUND_PROGRESS”


数据运维技术 » Oracle 视图 ALL_XSTREAM_OUTBOUND_PROGRESS 官方解释,作用,如何使用详细说明