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

2 votes258 views1 answer
Query to check cpu utilization in oracle database
SQL
1 vote138 views1 answer
Mssql string length
SQL
0 vote180 views1 answer
Show database not empty tables postgres
SQL
5 votes187 views2 answers
Sql server check port number
SQL
0 vote176 views1 answer
Create function syntax sql server
SQL
0 vote205 views1 answer
How to map sql column to custom names
SQL
3 votes248 views1 answer
Apex call duration
SQL
0 vote192 views1 answer
How get data from database if id not found then search another column
SQL
0 vote197 views1 answer
Mysql regex exact match
SQL
0 vote200 views1 answer
Add sqlcmd to path linux
SQL