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 votes105 views1 answer
Force drop all tables postgres
SQL
0 vote104 views1 answer
Sql last 7 days
SQL
1 vote123 views1 answer
Drop primary key oracle
SQL
0 vote100 views1 answer
Oracle DROP PROGRAM
SQL
0 vote128 views1 answer
Sql delete caracter list
SQL
0 vote113 views1 answer
R write csv without index
SQL
11 votes116 views3 answers
Python sqlite3 create table if not exists
SQL
0 vote103 views1 answer
What is between keyword used for
SQL
0 vote105 views1 answer
Sqlite update only if greater
SQL
16 votes117 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL