Oracle教程 2023-02-23

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

_DETAILS

Oracle视图ALL_GOLDENGATE_INBOUND_DETAILS用于显示与金山数据库的同步传输有关的详细信息。它的功能有：

– 查看接收端（即本地数据库）接收传入流的金山数据库实例名称以及传入流标识号；

– 查看目标数据库实例名称以及传出流标识号；

– 查看同步开始时间（EOR）、分片使用时间和传输状态；

– 查看当前活动传输数据段（CURRENT_ACTIVE_PARTITION）和当前接收端事件（CURRENT_INBOUND_SEQ事件）；

– 查看当前接收端的插入，更新和删除计数（INSERT_COUNTs、UPDATE_COUNTs、DELETE_COUNTs）；

– 查看当前远程源的最新时间戳；

– 查看报错情况，报错信息等

以上就是Oracle视图ALL_GOLDENGATE_INBOUND_DETAILS的功能介绍，要使用它，可以用以下SQL语句：

SELECT * FROM ALL_GOLDENGATE_INBOUND_DETAILS;

这样就可以获取金山与Oracle之间传输关系的详细信息。

ALL_GOLDENGATE_INBOUND displays information about the GoldenGate inbound servers accessible to the current user.

Related View

DBA_GOLDENGATE_INBOUND displays information about all GoldenGate inbound servers in the database.

Column	Datatype	NULL	Description
`REPLICAT_NAME`	`VARCHAR2(4000)`		The name of the replicat group created from GGSCI using GoldenGate
`SERVER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the inbound server
`APPLY_USER`	`VARCHAR2(128)`		Name of the user who can connect to the inbound server and apply messages
`USER_COMMENT`	`VARCHAR2(4000)`		User comment
`CREATE_DATE`	`TIMESTAMP(6)`		Date when inbound server was created
`STATUS`	`VARCHAR2(8)`		Status of the inbound server: `DISABLED` – The inbound server is not running. `DETACHED` – The inbound server is running, but the GoldenGate client application is not attached to it. `ATTACHED` – The inbound server is running, and the GoldenGate client application is attached to it. `ABORTED` – The inbound server became disabled because it encountered an error.