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 votes191 views1 answer
Conda install sqlalchemy
SQL
0 vote187 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote182 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote177 views1 answer
SQL Server format datetime
SQL
7 votes190 views1 answer
Connect mysql docker
SQL
0 vote263 views1 answer
How to login to mysql in homestead
SQL
16 votes247 views6 answers
Python sqlite
SQL
0 vote149 views1 answer
Expose db in virtualbox
SQL
4 votes191 views2 answers
Postgre sql create table
SQL
1 vote241 views1 answer
Sql server locks
SQL