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

5 votes303 views1 answer
Find table from column name in sql
SQL
0 vote294 views1 answer
Mysql Error Code: 1005
SQL
4 votes292 views1 answer
Create column mysql terminal
SQL
8 votes301 views1 answer
Oracle search source code
SQL
3 votes326 views3 answers
Raw select laravel
SQL
0 vote287 views1 answer
Sql select rows between 1000 and 2000
SQL
5 votes312 views1 answer
Mysql count newlines in field
SQL
0 vote330 views1 answer
Alter table change default
SQL
1 vote294 views1 answer
Error code 1055
SQL
0 vote288 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL