Oracle plan hash value

SELECT DISTINCT sql_id, plan_hash_value
FROM dba_hist_sqlstat dhs,
    (
    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 - 4) AND SYSDATE
    ) s
WHERE dhs.snap_id BETWEEN s.min_snap AND s.max_snap
  AND dhs.sql_id IN ('my_sql_id');

Similar codes

0 vote291 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote279 views2 answers
2nd max salary query in sql
SQL
0 vote294 views1 answer
How to move a column to different spot mysql
SQL
11 votes281 views1 answer
Ddl materialized view
SQL
1 vote304 views1 answer
How to subtract from the value of a table in sql
SQL
6 votes284 views2 answers
Sql display max value
SQL
0 vote282 views1 answer
Sql server order by nulls last
SQL
4 votes263 views1 answer
Mac install mysql
SQL
2 votes333 views1 answer
Install postgresql centos 5
SQL
21 votes301 views1 answer
Cheatsheet for sql
SQL