7.15 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