select st.snap_id, st.dbid, st.instance_number, st.object_name,
st.session_type, st.session_module, st.sga_used, st.sga_allocated,
decode(st.con_dbid, 0, st.dbid, st.con_dbid),
con_dbid_to_id(decode(st.con_dbid, 0, st.dbid, st.con_dbid)) con_id
from DBA_HIST_SNAPSHOT sn, WRH$_SESS_SGA_STATS st
where st.snap_id = sn.snap_id
and st.dbid = sn.dbid
and st.instance_number = sn.instance_number
SELECT ST.SNAP_ID
, ST.DBID
, ST.INSTANCE_NUMBER
, ST.OBJECT_NAME
,
ST.SESSION_TYPE
, ST.SESSION_MODULE
, ST.SGA_USED
, ST.SGA_ALLOCATED
,
DECODE(ST.CON_DBID
, 0
, ST.DBID
, ST.CON_DBID)
,
CON_DBID_TO_ID(DECODE(ST.CON_DBID
, 0
, ST.DBID
, ST.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SESS_SGA_STATS ST
WHERE ST.SNAP_ID = SN.SNAP_ID
AND ST.DBID = SN.DBID
AND ST.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
|
|
|