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 vote266 views1 answer
How to check the mysql version mac
SQL
0 vote290 views1 answer
Create a plsql object
SQL
0 vote275 views1 answer
Sql convert float to string
SQL
0 vote334 views1 answer
How to check foreign key constraint in sql
SQL
8 votes254 views2 answers
Phpmyadmin password
SQL
2 votes269 views1 answer
Get hour from date sql
SQL
0 vote249 views1 answer
What is the essence of SQL?
SQL
0 vote265 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote289 views1 answer
How to install sql in anaconda
SQL
0 vote300 views1 answer
Sql date with year
SQL