DBA_HIST_PERSISTENT_QMN_CACHE

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

Note:

The DBA_HIST_PERSISTENT_QMN_CACHE view is available starting with Oracle Database 11g Release 2 (11.2.0.2).