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
