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 vote393 views1 answer
Convert to hexadecimal sql
SQL
0 vote348 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote364 views1 answer
Like date sql server not working
SQL
9 votes334 views3 answers
Where in sql
SQL
7 votes348 views1 answer
Append column sql
SQL
0 vote350 views1 answer
How to use select union and loop
SQL
5 votes342 views1 answer
How to check port number for postgresql
SQL
-1 vote344 views1 answer
How to open blade file from blade in laravel
SQL
4 votes341 views1 answer
What are the data types in sql
SQL
0 vote351 views1 answer
Calculate date and convert to yearsmysql
SQL