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