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 vote235 views1 answer
Cast for print sql
SQL
0 vote225 views1 answer
Search db for table name
SQL
8 votes259 views1 answer
Racle create auto increment column
SQL
0 vote221 views10 answers
John the ripper mysql
SQL
0 vote265 views1 answer
Error code 1451 sql
SQL
0 vote264 views1 answer
Create table like sql
SQL
0 vote233 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote191 views1 answer
Mysql select top 2
SQL
0 vote253 views1 answer
Sql sum if
SQL
0 vote269 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL