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 vote229 views1 answer
Increase speed of like queries postgres
SQL
0 vote228 views1 answer
Unique element in sql
SQL
0 vote234 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
1 vote230 views2 answers
Login to mysql
SQL
0 vote224 views1 answer
Drop all tables db2
SQL
0 vote225 views2 answers
Sql server set default value equal to auto increment
SQL
1 vote255 views1 answer
Drop primary key oracle
SQL
4 votes223 views2 answers
Postgresql default value
SQL
7 votes235 views4 answers
What is my mysql version
SQL
4 votes195 views1 answer
Sql list users and roles
SQL