Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_QUEUE_TABLES

All queue tables created by the user

Columns
   ___________________________
 
   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:



Simon Sheppard
SS64.com