select ict.snap_id, ict.dbid, ict.instance_number,
instance, class, cr_block, cr_busy, cr_congested,
current_block, current_busy, current_congested
,lost ,cr_2hop ,cr_3hop ,current_2hop ,current_3hop
,cr_block_time ,cr_busy_time ,cr_congested_time ,current_block_time
,current_busy_time ,current_congested_time ,lost_time ,cr_2hop_time
,cr_3hop_time ,current_2hop_time ,current_3hop_time,
decode(ict.con_dbid, 0, ict.dbid, ict.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_INST_CACHE_TRANSFER ict
where sn.snap_id = ict.snap_id
and sn.dbid = ict.dbid
and sn.instance_number = ict.instance_number
SELECT ICT.SNAP_ID
, ICT.DBID
, ICT.INSTANCE_NUMBER
,
INSTANCE
, CLASS
, CR_BLOCK
, CR_BUSY
, CR_CONGESTED
,
CURRENT_BLOCK
, CURRENT_BUSY
, CURRENT_CONGESTED
, LOST
, CR_2HOP
, CR_3HOP
, CURRENT_2HOP
, CURRENT_3HOP
, CR_BLOCK_TIME
, CR_BUSY_TIME
, CR_CONGESTED_TIME
, CURRENT_BLOCK_TIME
, CURRENT_BUSY_TIME
, CURRENT_CONGESTED_TIME
, LOST_TIME
, CR_2HOP_TIME
, CR_3HOP_TIME
, CURRENT_2HOP_TIME
, CURRENT_3HOP_TIME
,
DECODE(ICT.CON_DBID
, 0
, ICT.DBID
, ICT.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_INST_CACHE_TRANSFER ICT
WHERE SN.SNAP_ID = ICT.SNAP_ID
AND SN.DBID = ICT.DBID
AND SN.INSTANCE_NUMBER = ICT.INSTANCE_NUMBER
|
|
|