[Home] [Help] [Dependency Information]
Object Name: | CDB_HIST_PERSISTENT_QMN_CACHE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
STREAMS AQ Persistent QMN Cache Historical Statistics Information in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
QUEUE_TABLE_ID | NUMBER | Yes | ||
TYPE | VARCHAR2 | (32) | ||
STATUS | NUMBER | |||
NEXT_SERVICE_TIME | TIMESTAMP(3) | (11) | ||
WINDOW_END_TIME | TIMESTAMP(3) | (11) | ||
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) | (11) | ||
DEQLOG_ROWS_PROCESSED | NUMBER | |||
DEQLOG_PROCESSING_ELAPSED_TIME | NUMBER | |||
DEQLOG_PROCESSING_CPU_TIME | NUMBER | |||
LAST_DEQLOG_PROCESSING_TIME | TIMESTAMP(3) | (11) | ||
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) | (11) | ||
CON_DBID | NUMBER | |||
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, 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_DBID
, CON_ID
FROM SYS.CDB_HIST_PERSISTENT_QMN_CACHE;
SYS.CDB_HIST_PERSISTENT_QMN_CACHE does not reference any database object
SYS.CDB_HIST_PERSISTENT_QMN_CACHE is referenced by following:
|
|
|