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 vote265 views1 answer
Sql drop with dependencies
SQL
0 vote302 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote287 views1 answer
Sql pad left 0
SQL
2 votes277 views1 answer
Oracle apex who is connected
SQL
0 vote293 views1 answer
Gcloud sql instance list
SQL
1 vote289 views1 answer
Get create table query existing table mysql
SQL
4 votes264 views1 answer
Check database name postgresql
SQL
0 vote300 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
4 votes274 views1 answer
Sql any
SQL
0 vote275 views1 answer
Dump db only triggers mysql
SQL