V$PERSISTENT_QMN_CACHE definition in Oracle Database 11.2
V$PERSISTENT_QMN_CACHE

select
  QUEUE_TABLE_ID,                          -- QUEUE_TABLE_ID NUMBER
  TYPE,                                    -- TYPE VARCHAR2(32)
  STATUS,                                  -- STATUS NUMBER
  NEXT_SERVICE_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,                      -- TOTAL_ELAPSED_TIME NUMBER
  TOTAL_CPU_TIME,                          -- TOTAL_CPU_TIME NUMBER
  TMGR_ROWS_PROCESSED,                     -- TMGR_ROWS_PROCESSED NUMBER
  TMGR_ELAPSED_TIME,                       -- TMGR_ELAPSED_TIME NUMBER
  TMGR_CPU_TIME,                           -- 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,          -- DEQLOG_PROCESSING_ELAPSED_TIME NUMBER
  DEQLOG_PROCESSING_CPU_TIME,              -- 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,              -- INDEX_CLEANUP_ELAPSED_TIME NUMBER
  INDEX_CLEANUP_CPU_TIME,                  -- INDEX_CLEANUP_CPU_TIME NUMBER
  LAST_INDEX_CLEANUP_TIME                  -- LAST_INDEX_CLEANUP_TIME TIMESTAMP(3) WITH TIME ZONE
from
  GV$PERSISTENT_QMN_CACHE
where
  INST_ID = USERENV('Instance')

home |  up