Oracle教程

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

本站中文解释

oracle视图V$AQ_IPC_MSG_STATS被用来监控AQ IPC中消息传输情况。
V$AQ_IPC_MSG_STATS包含以下字段：

1. MSGNAME：消息名称；
2. MSGSEND：发送的消息数；
3. MSGRECEVED：接收的消息数；
4. MSGGETTIME：花费的时间；
5. TOTALTRANSMITTEDMESSAGE：传输的消息总数；
6. AVGTRANSMITTIME：消息平均传输时间，从发送到接收为一次完整传输。

使用Oracle视图V$AQ_IPC_MSG_STATS，可以查看消息在AQ IPC之间传输的情况，主要用于查看消息的传输效率，以及进行性能的监控和调优。例如：查询各个消息的传输比例及传输时间：

SELECT msgname, msgsend, msgrecv, totaltransmittedmsg, avgtransmitime
FROM v$aq_ipc_msg_stats;

官方英文解释

V$AQ_IPC_MSG_STATS displays the statistics of each IPC message class, such as the total number of invocations of a message class, total pending message/processed message count, and last failure related data. Information like total processed message count, average pending time/average processing time gives a real-time outline of AQ IPC background state.

Column Datatype Description

MSG_CLASS_NAME

VARCHAR2(30)

Message class name

TOTAL_MSG_CALLS

NUMBER

Total number of calls for this message class

TOTAL_ACTIVE_MSGS

NUMBER

Total number of active messages presently processed by slaves and master

TOTAL_PENDING_MSGS

NUMBER

Total number of pending messages in the master’s local context

TOTAL_PROCESSED_MSGS

NUMBER

Total number of processed messages

LAST_RECEIVED_TIME

TIMESTAMP(3) WITH TIME ZONE

Time when the last message of this type was received in the master’s context list

LAST_PROCESS_TIME

TIMESTAMP(3) WITH TIME ZONE

Time when the last message was picked for processing

LAST_DONE_TIME

TIMESTAMP(3) WITH TIME ZONE

Time when the last message was done processing

AVERAGE_PENDING_TIME

NUMBER

Average pending time for this message class (in seconds)

AVERAGE_PROCESSING_TIME

NUMBER

Average processing time for this message class (in seconds)

LAST_FAILURE_TIME

TIMESTAMP(3) WITH TIME ZONE

Time of the last failure for this message class

LAST_ERROR_MSG

VARCHAR2(512)

Last error message for this message class

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


数据运维技术 » Oracle 视图 V$AQ_IPC_MSG_STATS 官方解释，作用，如何使用详细说明
分享到：

相关推荐