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 vote257 views2 answers
Install sql server management studio ubuntu
SQL
8 votes223 views5 answers
Grant permission in postgres
SQL
1 vote214 views2 answers
Change table name phpmyadmin
SQL
7 votes265 views1 answer
Show line number in sql server
SQL
0 vote232 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
1 vote211 views1 answer
How much every mysql database record takes from diskspace
SQL
0 vote232 views1 answer
Kill a pid redshift
SQL
0 vote236 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
1 vote215 views1 answer
Sql to mongodb query converter
SQL
0 vote215 views1 answer
Sql menampilkan data tabel
SQL