Tuesday, August 8, 2023
Query to find Plan Hash Values for a SQLID in Oracle
Query to find Plan Hash Values for a SQLID in Oracle
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 - &No_Days) AND SYSDATE
) s
WHERE dhs.snap_id BETWEEN s.min_snap AND s.max_snap
AND dhs.sql_id IN ( '&SQLID')
Subscribe to:
Posts (Atom)