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

1 vote198 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
3 votes218 views2 answers
Mysql select database
SQL
0 vote197 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
14 votes213 views3 answers
How to add default constraint in mysql
SQL
2 votes196 views1 answer
Mysql change data type of column
SQL
1 vote208 views1 answer
Nullif postgresql
SQL
0 vote262 views2 answers
Find lowest number in sql
SQL
0 vote193 views1 answer
Check connections to database postgres
SQL
0 vote249 views9 answers
Linq to sql converter online
SQL
0 vote200 views1 answer
Mysql a from on this page has
SQL