Oracle教程 2023-03-31

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

_PROCESSES

ALL_XSTREAM_INBOUND_PROCESSES视图位于Oracle数据库中，提供对XStream Inbound Server进程的汇总信息。它用于检查XStream Inbound Server (XIS)进程的性能，从而检查XStream Inbound Server的运行状况。

它的用途是可以用来检查多个XIS实例上的状态。它还提供了多个参数，用于检查XIS实例的各种信息，例如允许的实例连接的最大数量、各个实例上的内存使用情况、超时等等。

要使用ALL_XSTREAM_INBOUND_PROCESSES视图，首先需要连接到Oracle数据库服务器。然后，借助SELECT语句，可以查询ALL_XSTREAM_INBOUND_PROCESSES视图中的某项信息，可以查询每个XIS实例上的CPU使用情况，并显示JDBC传输速率等。

ALL_XSTREAM_INBOUND displays information about the XStream inbound servers accessible to the current user.

Related View

DBA_XSTREAM_INBOUND displays information about all XStream inbound servers in the database.

Column	Datatype	NULL	Description
`SERVER_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the inbound server
`QUEUE_OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the queue associated with the inbound server
`QUEUE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the queue associated with 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 the 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 XStream client application is not attached to it. `ATTACHED` – The inbound server is running, and the XStream client application is attached to it. `ABORTED` – The inbound server became disabled because it encountered an error.
`COMMITTED_DATA_ONLY`	`VARCHAR2(3)`		`YES` – means the inbound server can receive only LCRs in committed transactions from the XStream client application. A committed transaction is an assembled, noninterleaving transaction with no rollbacks.