Table: DBA_QUEUE_TABLES
All queue tables created in the database
| Column Name | Description |
|---|---|
| COMPATIBLE | Compatibility version of the queue table |
| MESSAGE_GROUPING | Transaction grouping |
| OBJECT_TYPE | Name of the payload type for object type payload |
| OWNER | Owner of the queue table |
| OWNER_INSTANCE | Instance which owns the queue table currently |
| PRIMARY_INSTANCE | Instance assigned as the primary owner of the queue table |
| QUEUE_TABLE | Name of the queue table |
| RECIPIENTS | Mulitple or single recipient queue |
| SECONDARY_INSTANCE | Instance assigned as the secondary owner of the queue table |
| SECURE | Secure queue table |
| SORT_ORDER | Sort order for the queue table |
| TYPE | Name of the payload type |
| USER_COMMENT | User specified comment |