select mro.snap_id, mro.dbid, mro.instance_number,
component, oper_type, start_time, end_time,
target_size, oper_mode, parameter, initial_size,
final_size, mro.status,
decode(mro.con_dbid, 0, mro.dbid, mro.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_MEMORY_RESIZE_OPS mro
where sn.snap_id = mro.snap_id
and sn.dbid = mro.dbid
and sn.instance_number = mro.instance_number
SELECT MRO.SNAP_ID
, MRO.DBID
, MRO.INSTANCE_NUMBER
,
COMPONENT
, OPER_TYPE
, START_TIME
, END_TIME
,
TARGET_SIZE
, OPER_MODE
, PARAMETER
, INITIAL_SIZE
,
FINAL_SIZE
, MRO.STATUS
,
DECODE(MRO.CON_DBID
, 0
, MRO.DBID
, MRO.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_MEMORY_RESIZE_OPS MRO
WHERE SN.SNAP_ID = MRO.SNAP_ID
AND SN.DBID = MRO.DBID
AND SN.INSTANCE_NUMBER = MRO.INSTANCE_NUMBER
|
|
|