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 vote125 views1 answer
Mysql bash execute sql file
SQL
0 vote130 views1 answer
Mysql select where field is a value
SQL
0 vote193 views1 answer
Trigger
SQL
0 vote117 views1 answer
Insert data from stored procedure into table
SQL
0 vote129 views1 answer
Sql list dates between two dates
SQL
0 vote134 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote119 views1 answer
Sql right characters
SQL
3 votes146 views2 answers
Synonym oracle
SQL
0 vote127 views1 answer
Psotgres multiple values
SQL
7 votes121 views1 answer
Sql server convert string to date
SQL