DBA_QUEUE_TABLES

All queue tables created in the database

Columns
   ___________________________
 
   SORT_ORDER
      Sort order for the queue table
   OWNER
      Owner of the queue table
   QUEUE_TABLE
      Name of the queue table
   OWNER_INSTANCE
      Instance which owns the queue table currently
   SECONDARY_INSTANCE
      Instance assigned as the secondary owner of the queue table
   PRIMARY_INSTANCE
      Instance assigned as the primary owner of the queue table
   COMPATIBLE
      Compatibility version of the queue table
   USER_COMMENT
      User specified comment
   RECIPIENTS
      Mulitple or single recipient queue
   OBJECT_TYPE
      Name of the payload type for object type payload
   TYPE
      Name of the payload type
   MESSAGE_GROUPING
      Transaction grouping

Related Commands:

Simon Sheppard
SS64.com