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 vote76 views1 answer
Print sum of values sql
SQL
0 vote119 views1 answer
Google sheets data validation custom formula filter
SQL
7 votes128 views3 answers
Sql server reset auto increment
SQL
4 votes119 views2 answers
Mysql show indexes on table
SQL
6 votes125 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes126 views1 answer
How to find table table in stored procedure sql server
SQL
0 vote114 views1 answer
Postgresql get current user name
SQL
0 vote123 views1 answer
Create boolean column in MySQL with false as default value?
SQL
-1 vote119 views1 answer
How to open blade file from blade in laravel
SQL
0 vote120 views1 answer
Search In the Database using Text
SQL