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

5 votes282 views4 answers
Rollback to in sql
SQL
5 votes258 views2 answers
Update all rows mysql
SQL
2 votes276 views2 answers
How to DROP a table in mysql
SQL
0 vote261 views1 answer
Difference between cross apply and inner join
SQL
4 votes328 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
2 votes267 views2 answers
Mysql get time from datetime
SQL
0 vote315 views1 answer
Sql to search who modified
SQL
0 vote270 views1 answer
Sql server remove 0 from left
SQL
3 votes289 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote270 views1 answer
Events not working db
SQL