DBA_QUEUE_TABLES

All queue tables created in the database

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:

DBA_QUEUES


© Copyright SS64.com 1999-2014
Some rights reserved