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 vote152 views1 answer
Get duplicate entry sql
SQL
0 vote146 views1 answer
Rows, INSERT INTO, Returning with alias
SQL
0 vote141 views1 answer
Sql constarint
SQL
5 votes212 views4 answers
Restart the psql server windows
SQL
6 votes169 views2 answers
Difference between join vs union
SQL
0 vote144 views1 answer
Console output pl sql
SQL
2 votes197 views1 answer
Tcl in sql
SQL
0 vote151 views1 answer
Mysql max number not returning correct value
SQL
1 vote143 views2 answers
Mysql show views
SQL
0 vote183 views1 answer
Postgres list users and roles
SQL