---- List SQL Run Dates for a Given Plan Hash Value--SET PAUSE ONSET PAUSE 'Press Return to Continue'SET PAGESIZE 60SET LINESIZE 300SELECTDISTINCT 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_ValueORDERBY st