Oracle教程 2023-04-02

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
`SNAP_ID`	`NUMBER`	`NOT NULL`	Unique snapshot ID
`DBID`	`NUMBER`	`NOT NULL`	Database ID for the snapshot
`INSTANCE_NUMBER`	`NUMBER`	`NOT NULL`	Instance number for the snapshot
`QUEUE_TABLE_ID`	`NUMBER`	`NOT NULL`	Queue table object ID
`TYPE`	`VARCHAR2(32)`		Type of the queue table’s queue monitor cache
`STATUS`	`NUMBER`		Status of the queue table’s queue monitor cache
`NEXT_SERVICE_TIME`	`TIMESTAMP(3)`		Time when the queue table should be serviced by QMON servers
`WINDOW_END_TIME`	`TIMESTAMP(3)`		Time manager activity period for non-owner queue table operations
`TOTAL_RUNS`	`NUMBER`		Total number of times this queue table is served
`TOTAL_LATENCY`	`NUMBER`		Cumulative latency in serving the queue table (in hundredths of a second)
`TOTAL_ELAPSED_TIME`	`NUMBER`		Total time spent in processing this queue table (in seconds)
`TOTAL_CPU_TIME`	`NUMBER`		Cumulative CPU time for serving the queue table (in hundredths of a second)
`TMGR_ROWS_PROCESSED`	`NUMBER`		Number of time manager entries processed
`TMGR_ELAPSED_TIME`	`NUMBER`		Cumulative time for time management activities (in hundredths of a second)
`TMGR_CPU_TIME`	`NUMBER`		Cumulative CPU time for time management activities (in hundredths of a second)
`LAST_TMGR_PROCESSING_TIME`	`TIMESTAMP(3)`		Last timer manager processing time
`DEQLOG_ROWS_PROCESSED`	`NUMBER`		Number of dequeue log entries processed
`DEQLOG_PROCESSING_ELAPSED_TIME`	`NUMBER`		Total time for processing dequeue log entries (in hundredths of a second)
`DEQLOG_PROCESSING_CPU_TIME`	`NUMBER`		Total CPU time for processing dequeue log entries (in hundredths of a second)
`LAST_DEQLOG_PROCESSING_TIME`	`TIMESTAMP(3)`		Last dequeue log processing time
`DEQUEUE_INDEX_BLOCKS_FREED`	`NUMBER`		Number of dequeue index blocks freed
`HISTORY_INDEX_BLOCKS_FREED`	`NUMBER`		Number of history index blocks freed
`TIME_INDEX_BLOCKS_FREED`	`NUMBER`		Number of time manager index blocks freed
`INDEX_CLEANUP_COUNT`	`NUMBER`		Number of times index block cleanup was attempted
`INDEX_CLEANUP_ELAPSED_TIME`	`NUMBER`		Total time for index block cleanup (in hundredths of a second)
`INDEX_CLEANUP_CPU_TIME`	`NUMBER`		Total CPU time for index block cleanup (in hundredths of a second)
`LAST_INDEX_CLEANUP_TIME`	`TIMESTAMP(3)`		Last index block cleanup time
`CON_DBID`	`NUMBER`		The database ID of the PDB for the sampled session
`CON_ID`	`NUMBER`		The ID of the container that `CON_DBID` identifies. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

本站中文解释

官方英文解释

相关推荐