Data Dictionary of Oracle 11g



Index | Home | Forums

Table Name Description
ALL_DEQUEUE_QUEUES All queues accessible to the user

Column ID Column name Data type Length Precision NULL Description
1OWNERVARCHAR230(null)NOwner of the queue
2NAMEVARCHAR230(null)NName of the queue
3QUEUE_TABLEVARCHAR230(null)NName of the table the queue data resides in
4QIDNUMBER22(null)NObject number of the queue
5QUEUE_TYPEVARCHAR220(null)YType of the queue
6MAX_RETRIESNUMBER22(null)YMaximum number of retries allowed when dequeuing from the queue
7RETRY_DELAYNUMBER22(null)YTime interval between retries
8ENQUEUE_ENABLEDVARCHAR27(null)YQueue is enabled for enqueue
9DEQUEUE_ENABLEDVARCHAR27(null)YQueue is enabled for dequeue
10RETENTIONVARCHAR240(null)YTime interval processed messages retained in the queue
11USER_COMMENTVARCHAR250(null)YUser specified comment
12NETWORK_NAMEVARCHAR2512(null)YNetwork name of queue service

Index | Home | Forums

This page was created by oracleabc.com on Dec 31,2007 18:49:28
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here