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

3 votes136 views1 answer
System.debug apex
SQL
0 vote185 views1 answer
Can we rollback data that are deleted using DELETE
SQL
11 votes206 views2 answers
Import sql file laravel cmd
SQL
6 votes233 views3 answers
Mysql change auto_increment start value
SQL
0 vote168 views1 answer
Forcefully delete a row in mysql which has references
SQL
25 votes196 views4 answers
Metadata
SQL
0 vote172 views1 answer
Sql select by content lenght
SQL
2 votes157 views2 answers
How to get capital letter first in sql
SQL
1 vote202 views1 answer
Mysql view current queries
SQL
0 vote233 views1 answer
TSQL Find csv file in folder
SQL