ALL_QUEUE_TABLES

All queue tables accessible to the user

Columns
   ___________________________
 
   OWNER_INSTANCE
      Instance which owns the queue table currently
   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
   SECONDARY_INSTANCE
      Instance assigned as the secondary owner of the queue table
   OWNER
      Owner of the queue table
   USER_COMMENT
      User specified comment
   PRIMARY_INSTANCE
      Instance assigned as the primary owner of the queue table
   QUEUE_TABLE
      Name of the queue table

Related Commands:

Simon Sheppard
SS64.com