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 vote203 views1 answer
Sql get count without group by
SQL
0 vote228 views1 answer
Repeatable read trong sql server
SQL
0 vote179 views1 answer
Oracle sql replace string in clob
SQL
0 vote172 views1 answer
Sqlalchemy existing database
SQL
0 vote244 views1 answer
Sql server datetime
SQL
0 vote183 views1 answer
Mysql last 6 months
SQL
0 vote196 views1 answer
Sql server convert date to weekday
SQL
5 votes248 views1 answer
Mysql created at yesterdau
SQL
1 vote240 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
0 vote227 views1 answer
Update sqlite
SQL