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 vote308 views1 answer
In mysql workbench contnent not feching
SQL
-1 vote344 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote315 views1 answer
Mysql min value row
SQL
0 vote304 views1 answer
Conda install pymysql "windows"
SQL
4 votes310 views2 answers
Convert utc to est sql
SQL
7 votes320 views3 answers
Foreign key oracle
SQL
0 vote315 views1 answer
Isnull in sqlite
SQL
0 vote294 views1 answer
Redirection 301 htaccess nom de domaine
SQL
3 votes318 views2 answers
Find string in stored procedure sql server
SQL
0 vote306 views2 answers
How to get json data mysql
SQL