V$PERSISTENT_QMN

8.116 V$PERSISTENT_QMN_CACHE

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