select mt.snap_id, mt.dbid, mt.instance_number, mttr_target_for_estimate,
advice_status, dirty_limit,
estd_cache_writes, estd_cache_write_factor,
estd_total_writes, estd_total_write_factor,
estd_total_ios, estd_total_io_factor,
decode(mt.con_dbid, 0, mt.dbid, mt.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_MTTR_TARGET_ADVICE mt
where sn.snap_id = mt.snap_id
and sn.dbid = mt.dbid
and sn.instance_number = mt.instance_number
SELECT MT.SNAP_ID
, MT.DBID
, MT.INSTANCE_NUMBER
, MTTR_TARGET_FOR_ESTIMATE
,
ADVICE_STATUS
, DIRTY_LIMIT
,
ESTD_CACHE_WRITES
, ESTD_CACHE_WRITE_FACTOR
,
ESTD_TOTAL_WRITES
, ESTD_TOTAL_WRITE_FACTOR
,
ESTD_TOTAL_IOS
, ESTD_TOTAL_IO_FACTOR
,
DECODE(MT.CON_DBID
, 0
, MT.DBID
, MT.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_MTTR_TARGET_ADVICE MT
WHERE SN.SNAP_ID = MT.SNAP_ID
AND SN.DBID = MT.DBID
AND SN.INSTANCE_NUMBER = MT.INSTANCE_NUMBER
|
|
|