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

6 votes173 views4 answers
How to remove unique key in mysql
SQL
1 vote190 views1 answer
Postgres see sequence current state
SQL
3 votes178 views1 answer
Oracle list privileges
SQL
0 vote184 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote156 views1 answer
Oracle list chain steps
SQL
0 vote201 views1 answer
Psql check if sql script is valid
SQL
9 votes366 views2 answers
Current date in postgresql minus 1 day
SQL
1 vote184 views1 answer
Rails run native ssql query
SQL
0 vote154 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
8 votes167 views3 answers
Alter user root mysql
SQL