select rt.snap_id, rt.dbid, rt.instance_number,
rt.object_name, rt.session_type, rt.session_module, rt.source_database,
rt.source_txn_id, rt.first_lcr_time, rt.total_lcrs_count,
decode(rt.con_dbid, 0, rt.dbid, rt.con_dbid),
con_dbid_to_id(decode(rt.con_dbid, 0, rt.dbid, rt.con_dbid)) con_id
from DBA_HIST_SNAPSHOT sn, WRH$_REPLICATION_TXN_STATS rt
where rt.snap_id = sn.snap_id
and rt.dbid = sn.dbid
and rt.instance_number = sn.instance_number
SELECT RT.SNAP_ID
, RT.DBID
, RT.INSTANCE_NUMBER
,
RT.OBJECT_NAME
, RT.SESSION_TYPE
, RT.SESSION_MODULE
, RT.SOURCE_DATABASE
,
RT.SOURCE_TXN_ID
, RT.FIRST_LCR_TIME
, RT.TOTAL_LCRS_COUNT
,
DECODE(RT.CON_DBID
, 0
, RT.DBID
, RT.CON_DBID)
,
CON_DBID_TO_ID(DECODE(RT.CON_DBID
, 0
, RT.DBID
, RT.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_REPLICATION_TXN_STATS RT
WHERE RT.SNAP_ID = SN.SNAP_ID
AND RT.DBID = SN.DBID
AND RT.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
|
|
|