select
sn.snap_id, sn.dbid, sn.instance_number,
s.remaster_type, s.remaster_ops, s.remaster_time, s.remastered_objects,
s.quiesce_time, s.freeze_time, s.cleanup_time,
s.replay_time, s.fixwrite_time, s.sync_time,
s.resources_cleaned, s.replayed_locks_sent,
s.replayed_locks_received, s.current_objects,
decode(s.con_dbid, 0, s.dbid, s.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_DYN_REMASTER_STATS s
where sn.snap_id = s.snap_id
and sn.dbid = s.dbid
and sn.instance_number = s.instance_number
SELECT
SN.SNAP_ID
, SN.DBID
, SN.INSTANCE_NUMBER
,
S.REMASTER_TYPE
, S.REMASTER_OPS
, S.REMASTER_TIME
, S.REMASTERED_OBJECTS
,
S.QUIESCE_TIME
, S.FREEZE_TIME
, S.CLEANUP_TIME
,
S.REPLAY_TIME
, S.FIXWRITE_TIME
, S.SYNC_TIME
,
S.RESOURCES_CLEANED
, S.REPLAYED_LOCKS_SENT
,
S.REPLAYED_LOCKS_RECEIVED
, S.CURRENT_OBJECTS
,
DECODE(S.CON_DBID
, 0
, S.DBID
, S.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_DYN_REMASTER_STATS S
WHERE SN.SNAP_ID = S.SNAP_ID
AND SN.DBID = S.DBID
AND SN.INSTANCE_NUMBER = S.INSTANCE_NUMBER
|
|
|