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 vote163 views1 answer
Postgres list all triggers
SQL
0 vote137 views1 answer
If exist column in table drop sql query mysql
SQL
6 votes153 views2 answers
Drop foreign key
SQL
1 vote151 views1 answer
Postgresql contains
SQL
3 votes154 views1 answer
Sql multi column index performance
SQL
0 vote147 views1 answer
Mariadb select limit offset
SQL
1 vote147 views1 answer
Convert rows to string sql server
SQL
0 vote150 views1 answer
Mysql foreach insert
SQL
0 vote169 views1 answer
Set root password mysql xampp
SQL
0 vote146 views1 answer
How to know if table in rigt or left in sql
SQL