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 vote263 views1 answer
Not equal to blank in mysql
SQL
0 vote223 views3 answers
Mysql calculate age from date of birth
SQL
1 vote266 views2 answers
How to add amount between date in sql
SQL
10 votes276 views2 answers
Oracle alter sequence nextval
SQL
2 votes265 views4 answers
List databases in sql server
SQL
0 vote271 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote284 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote256 views1 answer
Mysql command prompt date insert format
SQL
0 vote254 views1 answer
Date diff sql
SQL
13 votes290 views4 answers
Mysql remove foreign key constraint
SQL