QUEUE -- queue name |
|
VARCHAR2(30) |
MSG_ID -- unique identifier of the message |
|
RAW(16) |
CORR_ID -- user-provided correlation identifier |
|
VARCHAR2(128) |
MSG_PRIORITY -- message priority |
|
NUMBER |
MSG_STATE -- state of this message |
|
VARCHAR2(9) |
DELAY -- number of seconds the message is delayed |
|
DATE |
EXPIRATION -- number of seconds in which the message will expire after being READY |
|
NUMBER |
ENQ_TIME -- enqueue time |
|
DATE |
ENQ_USER_ID -- enqueue user id |
|
NUMBER |
ENQ_TXN_ID -- enqueue transaction id |
NOT NULL |
VARCHAR2(30) |
DEQ_TIME -- dequeue time |
|
DATE |
DEQ_USER_ID -- dequeue user id |
|
NUMBER |
DEQ_TXN_ID -- dequeue transaction id |
|
VARCHAR2(30) |
RETRY_COUNT -- number of retries |
|
NUMBER |
EXCEPTION_QUEUE_OWNER -- exception queue schema |
|
VARCHAR2(30) |
EXCEPTION_QUEUE -- exception queue name |
|
VARCHAR2(30) |
USER_DATA -- user data |
|
BLOB |
SENDER_NAME -- name of the Agent enqueuing the message (valid only for 8.1-compatible queue tables) |
|
VARCHAR2(30) |
SENDER_ADDRESS -- queue name and database name of the source (last propagating) queue; the database name is not specified if the source queue is in the local database (valid only for 8.1-compatible queue tables) |
|
VARCHAR2(1024) |
SENDER_PROTOCOL -- protocol for sender address, reserved for future use (valid only for 8.1-compatible queue tables) |
|
NUMBER |
ORIGINAL_MSGID -- message id of the message in the source queue (valid only for 8.1-compatible queue tables) |
|
RAW(16) |
CONSUMER_NAME -- name of the Agent receiving the message (valid ONLY for 8.1-compatible MULTICONSUMER queue tables) |
|
VARCHAR2(30) |
ADDRESS -- address (queue name and database link name) of the agent receiving the message.The database link name is not specified if the address is in the local database. The address is NULL if the receiving agent is local to the queue (valid ONLY for 8.1-compatible MULTICONSUMER queue tables) |
|
VARCHAR2(1024) |
PROTOCOL -- protocol for receiving agent's address (valid only for 8.1-compatible queue tables) |
|
NUMBER |
PROPAGATED_MSGID -- message id of the message in the receiving agent's queue (valid only for 8.1-compatible queue tables) |
NULL |
RAW(16) |