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

-1 vote269 views1 answer
Condition in orderby mysql
SQL
0 vote280 views2 answers
Py sqlite if entry exists
SQL
1 vote284 views1 answer
Add many column to sap iq table
SQL
12 votes282 views3 answers
Install sqlite driver ubuntu
SQL
0 vote292 views1 answer
SQL check if record exist
SQL
2 votes300 views1 answer
Install postgresql centos 5
SQL
0 vote275 views1 answer
How to combine first and last nae into one columb sql
SQL
6 votes272 views5 answers
Sql add months to date
SQL
1 vote293 views3 answers
How to create a table structure from another table in mysql
SQL
11 votes268 views1 answer
Sql insert multiple rows from select
SQL