Oracle 视图 ALL_QUEUE_TABLES 官方解释,作用,如何使用详细说明

本站中文解释

Oracle视图ALL_QUEUE_TABLES是Oracle 10g引入的一种视图,它用于描述属于当前用户的队列表的详细信息。它包含有关每个表的消息类型、消息数等等。这是由QUEUE_TABLE参数设置时创建的。

使用ALL_QUEUE_TABLES视图可以查询每个表的消息类型、表大小、表状态和当前消息总数。可以通过查询ALL_QUEUE_TABLES视图来获取表的详细信息以及消息的指标:

例如:SELECT * FROM ALL_QUEUE_TABLES;

这将返回当前用户的所有队列表的详细信息,包括每个表的消息类型、消息数量等信息。

官方英文解释

ALL_QUEUE_TABLES describes the queues in the queue tables accessible to the current user.

Related Views

  • DBA_QUEUE_TABLES describes the queues in all queue tables in the database.

  • USER_QUEUE_TABLES describes the queues in the queue tables created in the current user’s schema. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

Owner of the queue table

QUEUE_TABLE

VARCHAR2(128)

Name of the queue table

TYPE

VARCHAR2(9)

Type of user data:

  • RAW – Raw type

  • OBJECT – User-defined object type

  • VARIANT – Variant type (for internal use only)

OBJECT_TYPE

VARCHAR2(257)

Object type of the payload when TYPE is OBJECT

SORT_ORDER

VARCHAR2(22)

User-specified sort order

RECIPIENTS

VARCHAR2(8)

SINGLE or MULTIPLE recipients

MESSAGE_GROUPING

VARCHAR2(13)

NONE or TRANSACTIONAL

REPLICATION_MODE

VARCHAR2(22)

Indicates whether the queue tables are enabled for replication through Oracle GoldenGate. If the queue tables are replicated, these values appear in the column:

  • REPLICATED_SOURCE: This value is displayed for a source queue table.

  • REPLICATED_DESTINATION: This value is displayed for a destination queue table.

If replication is not enabled on the queue tables, then this column is empty.

COMPATIBLE

VARCHAR2(6)

Lowest release level which the queue table is compatible with (for example, 8.0.3)

PRIMARY_INSTANCE

NUMBER

Indicates the instance number of the instance which is the primary owner of the queue table. A value of 0 indicates that there is no primary owner.

SECONDARY_INSTANCE

NUMBER

Indicates the instance number of the instance which is the secondary owner of the queue table. This instance becomes the owner of the queue table if the primary owner is not alive. A value of 0 indicates that there is no secondary owner.

OWNER_INSTANCE

NUMBER

Instance number of the instance which currently owns the queue table

USER_COMMENT

VARCHAR2(50)

Comment supplied by the user

SECURE

VARCHAR2(3)

Indicates whether the queue table is secure (YES) or not (NO)

See Also:

  • “DBA_QUEUE_TABLES”

  • “USER_QUEUE_TABLES”

  • Oracle Database Advanced
    Queuing User’s Guide
    for more information Advanced Queuing


数据运维技术 » Oracle 视图 ALL_QUEUE_TABLES 官方解释,作用,如何使用详细说明