select sp.snap_id, sp.dbid, sp.instance_number,
shared_pool_size_for_estimate,
shared_pool_size_factor, estd_lc_size, estd_lc_memory_objects,
estd_lc_time_saved, estd_lc_time_saved_factor,
estd_lc_load_time, estd_lc_load_time_factor,
estd_lc_memory_object_hits,
decode(sp.con_dbid, 0, sp.dbid, sp.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_SHARED_POOL_ADVICE sp
where sn.snap_id = sp.snap_id
and sn.dbid = sp.dbid
and sn.instance_number = sp.instance_number
SELECT SP.SNAP_ID
, SP.DBID
, SP.INSTANCE_NUMBER
,
SHARED_POOL_SIZE_FOR_ESTIMATE
,
SHARED_POOL_SIZE_FACTOR
, ESTD_LC_SIZE
, ESTD_LC_MEMORY_OBJECTS
,
ESTD_LC_TIME_SAVED
, ESTD_LC_TIME_SAVED_FACTOR
,
ESTD_LC_LOAD_TIME
, ESTD_LC_LOAD_TIME_FACTOR
,
ESTD_LC_MEMORY_OBJECT_HITS
,
DECODE(SP.CON_DBID
, 0
, SP.DBID
, SP.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SHARED_POOL_ADVICE SP
WHERE SN.SNAP_ID = SP.SNAP_ID
AND SN.DBID = SP.DBID
AND SN.INSTANCE_NUMBER = SP.INSTANCE_NUMBER
|
|
|