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

2 votes227 views2 answers
Postgres set user as superuser
SQL
1 vote170 views2 answers
Pl sql case
SQL
0 vote126 views1 answer
Big query add table rows to another table
SQL
12 votes186 views1 answer
Run mysql instance in docker
SQL
16 votes173 views3 answers
Update table from another table
SQL
34 votes184 views5 answers
Oracle alter table add column
SQL
4 votes178 views3 answers
Is not null sql
SQL
0 vote169 views1 answer
Postgres in operator with comma separated values
SQL
1 vote168 views1 answer
Postgresql transaction discard all
SQL
9 votes201 views3 answers
Sequence postgresql
SQL