Oracle 视图 DBA_HIST_PERSISTENT_QMN_CACHE 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图DBA_HIST_PERSISTENT_QMN_CACHE主要用于提供持久消息队列服务（PQMS）的历史缓存信息。这些信息有助于检查PQMS的运行，但只能够在运行了AWR搜集后才能访问。
该视图提供的信息包括：
– 几个消息队列的名称
– 消息队列的消息大小
– 消息队列的类型（非持久，持久）
– 新消息队列的创建时间
– 上次同步时间
要使用DBA_HIST_PERSISTENT_QMN_CACHE，必须拥有SELECT_CATALOG_ROLE和SELECT_ANY_DICTIONARY权限，并且必须切换到SYSDBA角色。另外，使用者需要确保自己有足够权限来访问要访问的数据结构（尤其是数据字典视图）。
官方英文解释
DBA_HIST_PERSISTENT_QMN_CACHE displays the historical summary background queue table activity.
This view contains snapshots from V$PERSISTENT_QMN_CACHE.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
| Unique snapshot ID |
|
|
| Database ID for the snapshot |
|
|
| Instance number for the snapshot |
|
|
| Queue table object ID |
|
| Type of the queue table’s queue monitor cache | |
|
| Status of the queue table’s queue monitor cache | |
|
| Time when the queue table should be serviced by QMON servers | |
|
| Time manager activity period for non-owner queue table operations | |
|
| Total number of times this queue table is served | |
|
| Cumulative latency in serving the queue table (in hundredths of a second) | |
|
| Total time spent in processing this queue table (in seconds) | |
|
| Cumulative CPU time for serving the queue table (in hundredths of a second) | |
|
| Number of time manager entries processed | |
|
| Cumulative time for time management activities (in hundredths of a second) | |
|
| Cumulative CPU time for time management activities (in hundredths of a second) | |
|
| Last timer manager processing time | |
|
| Number of dequeue log entries processed | |
|
| Total time for processing dequeue log entries (in hundredths of a second) | |
|
| Total CPU time for processing dequeue log entries (in hundredths of a second) | |
|
| Last dequeue log processing time | |
|
| Number of dequeue index blocks freed | |
|
| Number of history index blocks freed | |
|
| Number of time manager index blocks freed | |
|
| Number of times index block cleanup was attempted | |
|
| Total time for index block cleanup (in hundredths of a second) | |
|
| Total CPU time for index block cleanup (in hundredths of a second) | |
|
| Last index block cleanup time | |
|
| The database ID of the PDB for the sampled session | |
|
| The ID of the container that
|
See Also:
“V$PERSISTENT_QMN_CACHE”
编辑：一起学习网
标签：队列,消息,视图,持久,信息