[Home] [Help] [Dependency Information]
Object Name: | DBA_HIST_CR_BLOCK_SERVER |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Consistent Read Block Server Historical Statistics
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
CR_REQUESTS | NUMBER | |||
CURRENT_REQUESTS | NUMBER | |||
DATA_REQUESTS | NUMBER | |||
UNDO_REQUESTS | NUMBER | |||
TX_REQUESTS | NUMBER | |||
CURRENT_RESULTS | NUMBER | |||
PRIVATE_RESULTS | NUMBER | |||
ZERO_RESULTS | NUMBER | |||
DISK_READ_RESULTS | NUMBER | |||
FAIL_RESULTS | NUMBER | |||
FAIRNESS_DOWN_CONVERTS | NUMBER | |||
FAIRNESS_CLEARS | NUMBER | |||
FREE_GC_ELEMENTS | NUMBER | |||
FLUSHES | NUMBER | |||
FLUSHES_QUEUED | NUMBER | |||
FLUSH_QUEUE_FULL | NUMBER | |||
FLUSH_MAX_TIME | NUMBER | |||
LIGHT_WORKS | NUMBER | |||
ERRORS | NUMBER | |||
CON_DBID | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, CR_REQUESTS
, CURRENT_REQUESTS
, DATA_REQUESTS
, UNDO_REQUESTS
, TX_REQUESTS
, CURRENT_RESULTS
, PRIVATE_RESULTS
, ZERO_RESULTS
, DISK_READ_RESULTS
, FAIL_RESULTS
, FAIRNESS_DOWN_CONVERTS
, FAIRNESS_CLEARS
, FREE_GC_ELEMENTS
, FLUSHES
, FLUSHES_QUEUED
, FLUSH_QUEUE_FULL
, FLUSH_MAX_TIME
, LIGHT_WORKS
, ERRORS
, CON_DBID
, CON_ID
FROM SYS.DBA_HIST_CR_BLOCK_SERVER;
|
|
|