select
sn.snap_id, sn.dbid, sn.instance_number,
t.target_instance, t.cnt_500b, t.wait_500b, t.waitsq_500b,
t.cnt_8k, t.wait_8k, t.waitsq_8k,
decode(t.con_dbid, 0, t.dbid, t.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_INTERCONNECT_PINGS t
where sn.snap_id = t.snap_id
and sn.dbid = t.dbid
and sn.instance_number = t.instance_number
SELECT
SN.SNAP_ID
, SN.DBID
, SN.INSTANCE_NUMBER
,
T.TARGET_INSTANCE
, T.CNT_500B
, T.WAIT_500B
, T.WAITSQ_500B
,
T.CNT_8K
, T.WAIT_8K
, T.WAITSQ_8K
,
DECODE(T.CON_DBID
, 0
, T.DBID
, T.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_INTERCONNECT_PINGS T
WHERE SN.SNAP_ID = T.SNAP_ID
AND SN.DBID = T.DBID
AND SN.INSTANCE_NUMBER = T.INSTANCE_NUMBER
|
|
|