List SQL Run Dates for a Given Plan Hash Value 
--
-- List SQL Run Dates for a Given Plan Hash Value
--
 
SET PAUSE ON
SET PAUSE 'Press Return to Continue'
SET PAGESIZE 60
SET LINESIZE 300
 
SELECT DISTINCT 
     sql_plan_hash_value,
     to_char(sample_time,'DD-Mon-YYYY') as st 
FROM DBA_HIST_ACTIVE_SESS_HISTORY 
WHERE sql_plan_hash_value=&Enter_Plan_Hash_Value
ORDER BY st
/

Related Scripts

Get Historical Plans from the AWR Using SQLID
Displays SQL Statement for the Specified Address or Hash
List Distinct SQL ID's for a Given Session

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License