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 vote269 views2 answers
Update all columns in one update
SQL
13 votes453 views4 answers
Sql joining 3 tables
SQL
0 vote269 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
2 votes273 views1 answer
Mysql clear screen
SQL
11 votes290 views3 answers
Sql_mode=only_full_group_by
SQL
5 votes266 views1 answer
How to check nls format in oracle
SQL
6 votes313 views2 answers
Install psql mac
SQL
21 votes272 views4 answers
Add column mssql
SQL
1 vote269 views1 answer
Rermove categories woocommerce sql
SQL
2 votes272 views1 answer
How to get weekday from old date in sql
SQL