[Home] [Help] [Dependency Information]
Object Name: | V_$PERSISTENT_QMN_CACHE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUEUE_TABLE_ID | NUMBER | |||
TYPE | VARCHAR2 | (32) | ||
STATUS | NUMBER | |||
NEXT_SERVICE_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
WINDOW_END_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
TOTAL_RUNS | NUMBER | |||
TOTAL_LATENCY | NUMBER | |||
TOTAL_ELAPSED_TIME | NUMBER | |||
TOTAL_CPU_TIME | NUMBER | |||
TMGR_ROWS_PROCESSED | NUMBER | |||
TMGR_ELAPSED_TIME | NUMBER | |||
TMGR_CPU_TIME | NUMBER | |||
LAST_TMGR_PROCESSING_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
DEQLOG_ROWS_PROCESSED | NUMBER | |||
DEQLOG_PROCESSING_ELAPSED_TIME | NUMBER | |||
DEQLOG_PROCESSING_CPU_TIME | NUMBER | |||
LAST_DEQLOG_PROCESSING_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
DEQUEUE_INDEX_BLOCKS_FREED | NUMBER | |||
HISTORY_INDEX_BLOCKS_FREED | NUMBER | |||
TIME_INDEX_BLOCKS_FREED | NUMBER | |||
INDEX_CLEANUP_COUNT | NUMBER | |||
INDEX_CLEANUP_ELAPSED_TIME | NUMBER | |||
INDEX_CLEANUP_CPU_TIME | NUMBER | |||
LAST_INDEX_CLEANUP_TIME | TIMESTAMP(3) WITH TIME ZONE | (20) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT QUEUE_TABLE_ID
, TYPE
, STATUS
, NEXT_SERVICE_TIME
, WINDOW_END_TIME
, TOTAL_RUNS
, TOTAL_LATENCY
, TOTAL_ELAPSED_TIME
, TOTAL_CPU_TIME
, TMGR_ROWS_PROCESSED
, TMGR_ELAPSED_TIME
, TMGR_CPU_TIME
, LAST_TMGR_PROCESSING_TIME
, DEQLOG_ROWS_PROCESSED
, DEQLOG_PROCESSING_ELAPSED_TIME
, DEQLOG_PROCESSING_CPU_TIME
, LAST_DEQLOG_PROCESSING_TIME
, DEQUEUE_INDEX_BLOCKS_FREED
, HISTORY_INDEX_BLOCKS_FREED
, TIME_INDEX_BLOCKS_FREED
, INDEX_CLEANUP_COUNT
, INDEX_CLEANUP_ELAPSED_TIME
, INDEX_CLEANUP_CPU_TIME
, LAST_INDEX_CLEANUP_TIME
, CON_ID
FROM SYS.V_$PERSISTENT_QMN_CACHE;
|
|
|