Oracle教程 2023-02-24

Oracle 视图 V$PERSISTENT_QMN_CACHE 官方解释，作用，如何使用详细说明

本站中文解释

V$PERSISTENT_QMN_CACHE视图是一个属于Oracle数据库的动态系统视图，用于报告所有与Filter, Replicate和Mapping驱动程序的持久性排队管理器（QMN）有关的信息。

这些信息包括当前活动的传输状态，此视图的行表示QMN进程中处理的传输作业。这个视图包括如下列：

QMN_CAPTURE_NAME：表示 capture 进程，把redo log转移到queue。

QMN_QUEUE_NAME ：表示 enqueue 进程，从queue发送消息到RMAN备份。

QMN_PROCESS_NAME ：表示 Pump 进程，从queue发送消息到终端应用程序（比如replicat）。

此视图为用户提供了一个可以查看、监控和调整QMN相关活动的有用的界面。通过此视图可以查看QMN的运行状况和能力，还可以监控和调整一些关键参数，以便更好地处理持久性操作。

官方英文解释

V$PERSISTENT_QMN_CACHE displays detailed information and statistics about the background activities for all queue tables in the system. There is one row per queue table. The rows are deleted when the database (or instance in an Oracle RAC environment) restarts.

Column	Datatype	Description
`QUEUE_TABLE_ID`	`NUMBER`	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) WITH TIME ZONE`	Time when the queue table should be serviced by QMON servers
`WINDOW_END_TIME`	`TIMESTAMP(3) WITH TIME ZONE`	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) WITH TIME ZONE`	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) WITH TIME ZONE`	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) WITH TIME ZONE`	Last index block cleanup time
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. 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

数据运维技术 » Oracle 视图 V$PERSISTENT_QMN_CACHE 官方解释，作用，如何使用详细说明

分享到：

本站中文解释

官方英文解释

相关推荐