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_TABLESdescribes the queues in all queue tables in the database. -
USER_QUEUE_TABLESdescribes the queues in the queue tables created in the current user’s schema. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
Owner of the queue table |
|
|
|
|
Name of the queue table |
|
|
|
|
Type of user data:
|
|
|
|
|
Object type of the payload when |
|
|
|
|
User-specified sort order |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Indicates whether the queue tables are enabled for replication through Oracle GoldenGate. If the queue tables are replicated, these values appear in the column:
If replication is not enabled on the queue tables, then this column is empty. |
|
|
|
|
Lowest release level which the queue table is compatible with (for example, |
|
|
|
|
Indicates the instance number of the instance which is the primary owner of the queue table. A value of |
|
|
|
|
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 |
|
|
|
|
Instance number of the instance which currently owns the queue table |
|
|
|
|
Comment supplied by the user |
|
|
|
|
Indicates whether the queue table is secure ( |
See Also:
-
“DBA_QUEUE_TABLES”
-
“USER_QUEUE_TABLES”
-
Oracle Database Advanced
Queuing User’s Guide for more information Advanced Queuing
