Oracle教程 2023-02-24

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

V$AQ_IPC_ACTIVE_MSGS是Oracle数据库中的一个只读视图，提供当前数据库队列和进程间通信（IPC）活动消息的概要信息，包括队列名称、队列类型、进程ID和消息ID等。

该视图主要用于查询活动消息并检查当前数据库的通信情况。要使用该视图，可以像执行其他SQL命令一样，使用SELECT语句查询它，比如：

SELECT * FROM V$AQ_IPC_ACTIVE_MSGS;

也可以使用SELECT语句查询视图中特定一列或几列，比如：

SELECT PROCESS_ID, MESSAGE_ID FROM V$AQ_IPC_ACTIVE_MSGS;

V$AQ_IPC_ACTIVE_MSGS displays the information related to active IPC messages being processed by AQ background processes.

Column	Datatype	Description
`PROCESS_NAME`	`VARCHAR2(48)`	Slave process name
`PROCESS_ID`	`NUMBER`	Oracle process ID for this slave
`SLAVE_STATE`	`NUMBER`	Slave status: `3`: Picked task `4`: Running `7`: Idle
`SLAVEOBJ_STATE`	`NUMBER`	Slave object status: `0`: Invalid `1`: Valid
`SEQUENCE_NUMBER`	`NUMBER`	Message sequence number
`MSG_CLASS_NAME`	`VARCHAR2(30)`	Message class name
`MSG_FLAGS`	`NUMBER`	Message flags: `1`: This message needs ack `2`: Short `4`: Long `8`: Priority `10`: Special ack
`MSG_SUBMT_TIME`	`NUMBER`	Time this message was added into the IPC master’s list (in seconds)
`MSG_PICKD_TIME`	`NUMBER`	Time this message was picked by slave or master for processing (in seconds)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：