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 vote246 views1 answer
Oracle string substitution
SQL
0 vote255 views2 answers
Sql join on comma separated field
SQL
0 vote249 views1 answer
Sql server cannot create database diagram
SQL
0 vote226 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote248 views1 answer
Sql server delete records with specific date
SQL
0 vote285 views1 answer
Error code 1451 sql
SQL
0 vote269 views1 answer
Query builder doctrien return sql
SQL
0 vote247 views1 answer
Order by with where clause in mysql
SQL
0 vote257 views1 answer
View to table sql
SQL
0 vote265 views1 answer
Query by column for substring sql
SQL