select crb.snap_id, crb.dbid, crb.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,
decode(crb.con_dbid, 0, crb.dbid, crb.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_CR_BLOCK_SERVER crb
where sn.snap_id = crb.snap_id
and sn.dbid = crb.dbid
and sn.instance_number = crb.instance_number
SELECT CRB.SNAP_ID
, CRB.DBID
, CRB.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
,
DECODE(CRB.CON_DBID
, 0
, CRB.DBID
, CRB.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_CR_BLOCK_SERVER CRB
WHERE SN.SNAP_ID = CRB.SNAP_ID
AND SN.DBID = CRB.DBID
AND SN.INSTANCE_NUMBER = CRB.INSTANCE_NUMBER
|
|
|