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

4 votes226 views1 answer
Mysql delete last row
SQL
3 votes189 views2 answers
Update Query in SQL Server
SQL
0 vote215 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote222 views1 answer
Mysql auto increment default value with prefix month and year
SQL
2 votes190 views1 answer
Oracle sql day of month from date
SQL
5 votes201 views4 answers
Upload database mysql command line
SQL
6 votes237 views1 answer
Identify primary key in oracle table
SQL
1 vote190 views1 answer
Partition by sql server
SQL
0 vote198 views1 answer
T-sql check if data exists
SQL
1 vote207 views1 answer
Sql convert month name to number
SQL