GV$PERSISTENT_QMN_CACHE definition in Oracle Database 11.2
GV$PERSISTENT_QMN_CACHE

select
  INST_ID,                                 -- INST_ID NUMBER
  QUEUE_TABLE,                             -- QUEUE_TABLE_ID NUMBER
  JOB_TYPE,                                -- TYPE VARCHAR2(32)
  FLAGS,                                   -- STATUS NUMBER
  NEXT_SVC_TIME,                           -- NEXT_SERVICE_TIME TIMESTAMP(3) WITH TIME ZONE
  WINDOW_END_TIME,                         -- WINDOW_END_TIME TIMESTAMP(3) WITH TIME ZONE
  TOTAL_RUNS,                              -- TOTAL_RUNS NUMBER
  TOTAL_LATENCY,                           -- TOTAL_LATENCY NUMBER
  TOTAL_ELAPSED_TIME/10000,                -- TOTAL_ELAPSED_TIME NUMBER
  TOTAL_CPU_TIME/10000,                    -- TOTAL_CPU_TIME NUMBER
  TMGR_ROWS_PROCESSED,                     -- TMGR_ROWS_PROCESSED NUMBER
  TMGR_ELAPSED_TIME/10000,                 -- TMGR_ELAPSED_TIME NUMBER
  TMGR_CPU_TIME/10000,                     -- TMGR_CPU_TIME NUMBER
  LAST_TMGR_PROCESSING_TIME,               -- LAST_TMGR_PROCESSING_TIME TIMESTAMP(3) WITH TIME ZONE
  DEQLOG_ROWS_PROCESSED,                   -- DEQLOG_ROWS_PROCESSED NUMBER
  DEQLOG_PROCESSING_ELAPSED_TIME/10000,    -- DEQLOG_PROCESSING_ELAPSED_TIME NUMBER
  DEQLOG_PROCESSING_CPU_TIME/10000,        -- DEQLOG_PROCESSING_CPU_TIME NUMBER
  LAST_DEQLOG_PROCESSING_TIME,             -- LAST_DEQLOG_PROCESSING_TIME TIMESTAMP(3) WITH TIME ZONE
  DEQUEUE_INDEX_BLOCKS_FREED,              -- DEQUEUE_INDEX_BLOCKS_FREED NUMBER
  HISTORY_INDEX_BLOCKS_FREED,              -- HISTORY_INDEX_BLOCKS_FREED NUMBER
  TIME_INDEX_BLOCKS_FREED,                 -- TIME_INDEX_BLOCKS_FREED NUMBER
  INDEX_CLEANUP_COUNT,                     -- INDEX_CLEANUP_COUNT NUMBER
  INDEX_CLEANUP_ELAPSED_TIME/10000,        -- INDEX_CLEANUP_ELAPSED_TIME NUMBER
  INDEX_CLEANUP_CPU_TIME/10000,            -- INDEX_CLEANUP_CPU_TIME NUMBER
  LAST_INDEX_CLEANUP_TIME                  -- LAST_INDEX_CLEANUP_TIME TIMESTAMP(3) WITH TIME ZONE
from
  X$KWQMNJIT

home |  up