Thursday, July 8, 2021
Show the Plan Hash Values for a Given SQLID Over a Given Period
--
-- Show the Plan Hash Values for a Given SQLID Over a Given Period
--
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
SELECT DISTINCT sql_id, plan_hash_value
FROM dba_hist_sqlstat q,
(
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 q.snap_id BETWEEN s.min_snap AND s.max_snap
AND q.sql_id IN ( '&SQLID')
/
Subscribe to:
Post Comments (Atom)
-
Prerequisites High level migration workflow Detailed migration workflow Migration process explained Appendix Cross platform database migra...
-
The information in this document applies to Oracle E-Business Suite Release 11 i and R12.x . The most current version of this document ...
-
Oracle Web Applications Desktop Integrator (Web ADI) Tips for Troubleshooting (Doc ID 390476.1) To Bottom ...
No comments:
Post a Comment