Oracle教程 2023-03-27

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

本站中文解释

Oracle视图ALL_XSTREAM_INBOUND_PROGRESS提供了用于检索和监视当前正在运行的XStream收入进度的信息。该视图包含XStream收入和处理过程正在进行的有关信息，例如订阅的地址、元信息和收入类型。

要使用Oracle视图ALL_XSTREAM_INBOUND_PROGRESS，可以使用SELECT语句查询出所需的信息。例如，要获取所有正在进行的XStream收入进度，可以使用以下SELECT语句：

SELECT * FROM ALL_XSTREAM_INBOUND_PROGRESS;

此外，还可以使用WHERE子句来查询具有特定属性的收入进度。例如，可以使用以下SELECT语句来获取XStream收入进度来自指定地址的信息：

SELECT * FROM ALL_XSTREAM_INBOUND_PROGRESS
WHERE SUBSCRIBER_ADDRESS = ‘sample_url’;

官方英文解释

ALL_XSTREAM_INBOUND_PROGRESS displays information about the progress made by the XStream inbound servers accessible to the current user.

Related View

DBA_XSTREAM_INBOUND_PROGRESS displays information about the progress made by all XStream inbound servers in the database.

Column	Datatype	NULL	Description
`SERVER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the inbound server
`PROCESSED_LOW_POSITION`	`RAW(64)`		Position of the processed low transaction
`APPLIED_LOW_POSITION`	`RAW(64)`		All messages with a commit position less than this value have been applied
`APPLIED_HIGH_POSITION`	`RAW(64)`		Highest commit position of a transaction that has been applied
`SPILL_POSITION`	`RAW(64)`		Position of the spill low watermark of the transactions currently being applied
`OLDEST_POSITION`	`RAW(64)`		Earliest position of the transactions currently being applied
`OLDEST_MESSAGE_NUMBER`	`NUMBER`	`NOT NULL`	Earliest message number of the transactions currently being applied
`APPLIED_MESSAGE_NUMBER`	`NUMBER`	`NOT NULL`	Message number up to which all transactions have definitely been applied. This value is the low watermark for the inbound server. That is, messages with a commit message number less than or equal to this message number have definitely been applied, but some messages with a higher commit message number may also have been applied.
`APPLIED_TIME`	`DATE`		Time at which the message with the message number displayed in the `APPLIED_MESSAGE_NUMBER` column was applied
`APPLIED_MESSAGE_CREATE_TIME`	`DATE`		Time at which the message with the message number displayed in the `APPLIED_MESSAGE_NUMBER` column was created at its source database
`SPILL_MESSAGE_NUMBER`	`NUMBER`		Spill low watermark. Any message with a lower SCN has either been applied or spilled to disk. The XStream client application does not need to send logical change records (LCRs) with a lower SCN than the spill low watermark. Spilled messages may not have been applied yet.
`SOURCE_DATABASE`	`VARCHAR2(128)`	`NOT NULL`	Database where the transaction originated
`SOURCE_ROOT_NAME`	`VARCHAR2(128)`		The global name of the source root database

本站中文解释

官方英文解释

相关推荐