The DBA_QUEUE_TABLES view provides the information about all queue tables in the database.

Parameter Type Description
owner TEXT The role name of the owner of a queue table.
queue_table TEXT The user-defined name of the queue table.
type CHARACTER VARYING The type of data stored in the queue table.
object_type TEXT The type of the user-defined payload.
sort_order CHARACTER VARYING The order in which the queue table is sorted.
recipients CHARACTER VARYING The value is SINGLE.
message_grouping CHARACTER VARYING The value is NONE.
compatible CHARACTER VARYING The release number of the PolarDB-O. The queue table is compatible with this release.
primary_instance NUMERIC The value is 0.
secondary_instance NUMERIC The value is 0.
owner_instance NUMERIC The instance number of the instance to which the queue table belongs.
user_comment CHARACTER VARYING The comment added when the table was created.
secure CHARACTER VARYING
  • YES: indicates that the queue table is secure.
  • NO: indicates that the queue table is not secure.