Oracle教程 2023-02-25

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

本站中文解释

视图

ALL_REPLICATION_PROCESS_EVENTS视图允许查询某一个复制进程中所有事件对象。其列表如下：

EVENT_OWNER：事件所有者
EVENT#：事件编号
EVENT_NAME：事件名称
LAST_COMMIT_SCN：最后提交scn
LAST_ERROR#：最后错误编号
WAIT_CLASS：等待类
WAIT_TIME：等待时间

使用示例：查询某个复制进程中所有事件的状态：

SQL：

SELECT EVENT_OWNER, EVENT#, EVENT_NAME, LAST_COMMIT_SCN, LAST_ERROR#, WAIT_CLASS, WAIT_TIME
FROM ALL_REPLICATION_PROCESS_EVENTS
WHERE REPLICATION_PROCESS_NAME = ‘REPLICATION_PROCESS_NAME’

官方英文解释

ALL_REPLICATION_PROCESS_EVENTS provides information about the replication processes events accessible to the current user.

Related View

DBA_REPLICATION_PROCESS_EVENTS provides information about the replication processes events in the database.

Column	Datatype	NULL	Description
`STREAMS_TYPE`	`VARCHAR2(10)`		Streams type: `XStream` `GoldenGate`
`PROCESS_TYPE`	`VARCHAR2(27)`		Process type: `Capture` `Capture server` `Apply Coordinator` `Apply Server` `Apply Network Receiver` `Apply Reader` `Apply Hash server`
`STREAMS_NAME`	`VARCHAR2(128)`	`NOT NULL`	Streams name
`EVENT_NAME`	`VARCHAR2(128)`		Event name: `START` `STOP` `ABORT` `CREATE` `DROP` `PARAMETER CHANGE` `HANDLER CREATE` `HANDLER REMOVE` `ALTER`
`DESCRIPTION`	`VARCHAR2(2000)`		Event description
`EVENT_TIME`	`TIMESTAMP(6)`		Time when the event occurred
`ERROR_NUMBER`	`NUMBER`		Error number (valid when event is Error)
`ERROR_MESSAGE`	`VARCHAR2(2000)`		Error Message (valid when event is an error)

本站中文解释

官方英文解释

相关推荐