OWNER --Owner of the queue |
NOT NULL |
VARCHAR2(30) |
NAME --Name of the queue |
NOT NULL |
VARCHAR2(30) |
QUEUE_TABLE --Name of the table the queue data resides in |
NOT NULL |
VARCHAR2(30) |
QID --Object number of the queue |
NOT NULL |
NUMBER |
QUEUE_TYPE --Type of the queue |
|
VARCHAR2(15) |
MAX_RETRIES --Maximum number of retries allowed when dequeuing from the queue |
|
NUMBER |
RETRY_DELAY --Time interval between retries |
|
NUMBER |
ENQUEUE_ENABLED --Queue is enabled for enqueue |
|
VARCHAR2(7) |
DEQUEUE_ENABLED --Queue is enabled for dequeue |
|
VARCHAR2(7) |
RETENTION --Time interval processed messages retained in the queue |
|
VARCHAR2(40) |
USER_COMMENT --User specified comment |
|
VARCHAR2(50) |