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

13 votes241 views3 answers
Mysqldump structure only
SQL
0 vote183 views1 answer
Mysql add root password
SQL
14 votes184 views5 answers
Set password for postgres user ubuntu
SQL
0 vote187 views1 answer
Restore backup mysql .gz
SQL
0 vote177 views2 answers
Sql having multiple conditions
SQL
-1 vote179 views1 answer
Sql oracle take only last results
SQL
0 vote168 views1 answer
Clear query cache sql server
SQL
0 vote173 views1 answer
Get number of table colums in sql query
SQL
15 votes163 views4 answers
T-sql drop function if exists
SQL
0 vote256 views1 answer
Sql developer format sql
SQL