Oracle Built−in Packages- P60: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Table Columns in the Queue Table View Name Description Type QUEUE Name of the queue remember you can have more than one queue in a queue table VARCHAR2 30 MSG_ID Unique identifier of the message RAW 16 CORR_ID Optional correlation identifier value provided by the user VARCHAR2 128 MSG_PRIORITY Message priority NUMBER MSG_STATE Message state VARCHAR2 9 DELAY Point in time to which the message is delayed for dequeuing DATE EXPIRATION Number of seconds in which the message will expire after its message state is set to READY NUMBER ENQ_TIME Date-time at which the message was enqueued DATE ENQ_USER_ID User ID of the enqueuing process NUMBER ENQ_TXN_ID Transaction ID of the enqueue action VARCHAR2 30 DEQ_TIME Date-time at which the message was dequeued DATE DEQ_USER_ID User ID of the dequeuing process NUMBER DEQ_TXN_ID Transaction ID of the dequeue action VARCHAR2 30 RETRY_COUNT Number of attempts to dequeue the message NUMBER EXCEPTION_QUEUE_OWNER Owner of exception queue VARCHAR2 30 EXCEPTION_QUEUE Name of exception queue for this message VARCHAR2 30 USER_DATA Payload of the queue user_data this might be a RAW value or the contents of the object which was placed in the queue RAW or object_type Note the following about using the queue table view The AQ administrator can use the SQL language to examine the contents of any queue or queue table. Objects Per Queue Table 286 Appendix A What s on the Companion Disk The dequeue columns are relevant only for single consumer queues. If you want to examine the dequeue history of messages in a multiple consumer queue you will need to examine the underlying database table owned by SYS that contains the message data see the next section . Data Dictionary Objects This section documents the database objects in the data dictionary that contain information for all queue tables and queues to which you have access. The DBA_QUEUE_TABLES view You can obtain information about .
