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 vote418 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote391 views1 answer
Oracle current date minus 1 day
SQL
0 vote345 views1 answer
Opensuse start MySQL
SQL
1 vote359 views1 answer
Postgresql reset serial counter after deleting content
SQL
6 votes361 views5 answers
Mysql get last insert id
SQL
5 votes387 views2 answers
Postgresql insert select
SQL
7 votes371 views2 answers
Add column table pl sql
SQL
1 vote345 views2 answers
Find a column in all tables mysql
SQL
0 vote342 views1 answer
2020 new year
SQL
2 votes363 views1 answer
Sql ends with string
SQL