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 vote211 views2 answers
How to search date in sql query
SQL
6 votes243 views5 answers
Oracle list tablespaces
SQL
1 vote205 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote203 views1 answer
See Foreign Key
SQL
1 vote199 views2 answers
Oracle list partitioned tables
SQL
3 votes205 views1 answer
Oracle revoke grant
SQL
0 vote235 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote202 views1 answer
Drop all data from tables
SQL
0 vote237 views1 answer
Psql create usr
SQL
1 vote230 views1 answer
Trim leading zeros in sql
SQL