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

25 votes230 views5 answers
Mysql replace text
SQL
0 vote176 views1 answer
Sql case when exists in another table
SQL
0 vote178 views1 answer
Drop constraint in ms sql
SQL
3 votes163 views3 answers
Print in pl sql
SQL
1 vote197 views2 answers
Intersect sql
SQL
3 votes182 views1 answer
Ssh check mysql version
SQL
0 vote178 views3 answers
Group_concat sql server
SQL
0 vote184 views1 answer
Mysql workbench view
SQL
0 vote205 views1 answer
Sql show founctions
SQL
1 vote186 views1 answer
Postgres power
SQL