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

1 vote407 views1 answer
How to set up a trigger in sql
SQL
0 vote340 views1 answer
How to get initials in sql
SQL
1 vote364 views3 answers
Nth highest salary
SQL
1 vote350 views1 answer
Error code 1175 mysql fix
SQL
0 vote392 views1 answer
Hashpass
SQL
0 vote338 views1 answer
How to check default value of column in sql server
SQL
2 votes368 views2 answers
Postgresql search all tables for column name
SQL
1 vote341 views1 answer
Add constraint sql
SQL
0 vote340 views1 answer
Drop column from table if exist on live server mysql
SQL
12 votes343 views4 answers
Mysql version
SQL