QUEUE_TABLE--queue table name |
|
VARCHAR2(30) |
TYPE --payload type |
|
VARCHAR2(7) |
OBJECT_TYPE --name of object type, if any |
|
VARCHAR2(61) |
SORT_ORDER --user specified sort order |
|
VARCHAR2(22) |
RECIPIENTS --SINGLE or MULTIPLE |
|
VARCHAR2(8) |
MESSAGE_GROUPING --NONE or TRANSACTIONAL |
|
VARCHAR2(13) |
COMPATIBLE --indicates the lowest version with which the queue table is compatible |
|
VARCHAR2(5) |
PRIMARY_INSTANCE --indicates which instance is the primary owner of the queue table; a value of 0 indicates that there is no primary owner |
|
NUMBER |
SECONDARY_INSTANCE --indicates which owner is the secondary owner of the queue table; this instance becomes the owner of the queue table if the primary owner is not up; a value of 0 indicates that there is no secondary owner |
|
NUMBER |
OWNER_INSTANCE --indicates which instance currently owns the queue table |
|
NUMBER |
USER_COMMENT --user comment for the queue table |
|
VARCHAR2(50) |