select
sn.snap_id, sn.dbid, sn.instance_number,
t.name, t.bytes_sent, t.bytes_received,
decode(t.con_dbid, 0, t.dbid, t.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_IC_CLIENT_STATS 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.NAME
, T.BYTES_SENT
, T.BYTES_RECEIVED
,
DECODE(T.CON_DBID
, 0
, T.DBID
, T.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_IC_CLIENT_STATS T
WHERE SN.SNAP_ID = T.SNAP_ID
AND SN.DBID = T.DBID
AND SN.INSTANCE_NUMBER = T.INSTANCE_NUMBER
|
|
|