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 vote264 views4 answers
Fatal database postgres does not exist
SQL
2 votes290 views1 answer
How to find constraints on a table in oracle
SQL
0 vote290 views1 answer
Search column name sql
SQL
0 vote275 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote280 views1 answer
Drop all triggers oracle
SQL
2 votes285 views2 answers
How to view created temporary tables in mysql
SQL
0 vote279 views1 answer
Mysql server not running
SQL
0 vote295 views1 answer
OFFSET consulta mysql
SQL
1 vote317 views1 answer
Mysql previous year
SQL
5 votes275 views1 answer
Ascending order and where in sql
SQL