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

2 votes154 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
11 votes153 views3 answers
Sql line numbers
SQL
0 vote255 views1 answer
Android sqlite add column if not exists
SQL
2 votes126 views1 answer
Mysql find tables with name
SQL
27 votes131 views5 answers
Add column in table
SQL
4 votes123 views1 answer
Sql group by year
SQL
0 vote182 views1 answer
T-sql delete view if exists
SQL
1 vote143 views1 answer
How to select multiple columns from different tables in mysql
SQL
28 votes129 views4 answers
Delete database mysql
SQL
1 vote129 views1 answer
Store select query result in variable sql server
SQL