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 |
---|---|---|
|
|
Message class name |
|
|
Total number of calls for this message class |
|
|
Total number of active messages presently processed by slaves and master |
|
|
Total number of pending messages in the master's local context |
|
|
Total number of processed messages |
|
|
Time when the last message of this type was received in the master's context list |
|
|
Time when the last message was picked for processing |
|
|
Time when the last message was done processing |
|
|
Average pending time for this message class (in seconds) |
|
|
Average processing time for this message class (in seconds) |
|
|
Time of the last failure for this message class |
|
|
Last error message for this message class |
|
|
The ID of the container to which the data pertains. Possible values include:
|