Post date: 03-Apr-2014 10:22:08
SELECT distinct PLAN_HASH_VALUE
FROM dba_hist_sqlstat q, ( SELECT /*+ NO_MERGE */ MIN(snap_id) min_snap, MAX(snap_id) max_snap
FROM dba_hist_snapshot ss WHERE ss.begin_interval_time BETWEEN (SYSDATE - $SDS_range) AND SYSDATE ) s
WHERE q.snap_id BETWEEN s.min_snap
AND s.max_snap AND q.sql_id IN ( $SDS_sqlid)
AND q.plan_hash_value not in ($SDS_hash_values) ;