select swh.snap_id, swh.dbid, swh.instance_number, low_optimal_size,
high_optimal_size, optimal_executions, onepass_executions,
multipasses_executions, total_executions,
decode(swh.con_dbid, 0, swh.dbid, swh.con_dbid),
0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_SQL_WORKAREA_HISTOGRAM swh
where sn.snap_id = swh.snap_id
and sn.dbid = swh.dbid
and sn.instance_number = swh.instance_number
SELECT SWH.SNAP_ID
, SWH.DBID
, SWH.INSTANCE_NUMBER
, LOW_OPTIMAL_SIZE
,
HIGH_OPTIMAL_SIZE
, OPTIMAL_EXECUTIONS
, ONEPASS_EXECUTIONS
,
MULTIPASSES_EXECUTIONS
, TOTAL_EXECUTIONS
,
DECODE(SWH.CON_DBID
, 0
, SWH.DBID
, SWH.CON_DBID)
,
0 CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SQL_WORKAREA_HISTOGRAM SWH
WHERE SN.SNAP_ID = SWH.SNAP_ID
AND SN.DBID = SWH.DBID
AND SN.INSTANCE_NUMBER = SWH.INSTANCE_NUMBER
|
|
|