本站中文解释

视图

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)

See Also:

“DBA_REPLICATION_PROCESS_EVENTS”

---

编辑：一起学习网

标签：事件,视图,进程,编号,英文