select ss.snap_id, ss.dbid, ss.instance_number,
total_sql, total_sql_mem,
single_use_sql, single_use_sql_mem,
decode(ss.con_dbid, 0, ss.dbid, ss.con_dbid),
con_dbid_to_id(decode(ss.con_dbid, 0, ss.dbid, ss.con_dbid)) con_id
from DBA_HIST_SNAPSHOT sn, WRH$_SQL_SUMMARY ss
where sn.snap_id = ss.snap_id
and sn.dbid = ss.dbid
and sn.instance_number = ss.instance_number
SELECT SS.SNAP_ID
, SS.DBID
, SS.INSTANCE_NUMBER
,
TOTAL_SQL
, TOTAL_SQL_MEM
,
SINGLE_USE_SQL
, SINGLE_USE_SQL_MEM
,
DECODE(SS.CON_DBID
, 0
, SS.DBID
, SS.CON_DBID)
,
CON_DBID_TO_ID(DECODE(SS.CON_DBID
, 0
, SS.DBID
, SS.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SQL_SUMMARY SS
WHERE SN.SNAP_ID = SS.SNAP_ID
AND SN.DBID = SS.DBID
AND SN.INSTANCE_NUMBER = SS.INSTANCE_NUMBER
|
|
|