DBA_QUEUE_TABLES

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

Related: