[Home] [Help] [Dependency Information]
Object Name: | GV_$AQ_MESSAGE_CACHE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
QUEUE_ID | NUMBER | |||
SHARD_ID | NUMBER | |||
PRIORITY | NUMBER | |||
SUBSHARD_ID | NUMBER | |||
PARTITION_ID | NUMBER | |||
MAX_MSGS | NUMBER | |||
ENQUEUED_MSGS | NUMBER | |||
BROWSED_MSGS | NUMBER | |||
MSGS_MADE_EXPIRED | NUMBER | |||
MSGS_MADE_READY | NUMBER | |||
CHUNK_SIZE | NUMBER | |||
NUM_CHUNKS | NUMBER | |||
NUM_FREE_CHUNKS | NUMBER | |||
USED_MEMORY_SIZE | NUMBER | |||
STATE | VARCHAR2 | (13) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, QUEUE_ID
, SHARD_ID
, PRIORITY
, SUBSHARD_ID
, PARTITION_ID
, MAX_MSGS
, ENQUEUED_MSGS
, BROWSED_MSGS
, MSGS_MADE_EXPIRED
, MSGS_MADE_READY
, CHUNK_SIZE
, NUM_CHUNKS
, NUM_FREE_CHUNKS
, USED_MEMORY_SIZE
, STATE
, CON_ID
FROM SYS.GV_$AQ_MESSAGE_CACHE;
|
|
|