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

18 votes344 views4 answers
Uninstall mysql ubuntu 18.04
SQL
1 vote297 views1 answer
Unique vs distinct sql
SQL
1 vote345 views1 answer
Sql server: query to find out all the places where the table is used
SQL
-1 vote340 views4 answers
Restart mysql server ubuntu
SQL
2 votes352 views2 answers
Postgres trigger insert into another table
SQL
0 vote359 views1 answer
Firebase sql
SQL
7 votes347 views2 answers
Postgres concat
SQL
0 vote303 views1 answer
Count column of tables psql
SQL
11 votes312 views2 answers
Having keyword sql
SQL
0 vote367 views1 answer
Time data type in mysql
SQL