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

0 vote129 views1 answer
Sql describe
SQL
0 vote113 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
1 vote134 views1 answer
Select inside insert query
SQL
0 vote108 views2 answers
Show slave status mysql
SQL
0 vote123 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
3 votes113 views5 answers
Mysql get last inserted id
SQL
0 vote116 views1 answer
Vbscript connect mssql
SQL
0 vote171 views1 answer
Drop view sql
SQL
2 votes112 views2 answers
Mysql on duplicate key ignore
SQL
0 vote112 views1 answer
How to connect pgadmin with excel
SQL