Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-14
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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).