Find time of execution of old query in Oracle
It means you have the SQL_ID of the SQL statement and now you want to know when it was executed. 

You can use the following query where you can supply the SQL_ID of the SQL query that you have in DBA_HIST_SQLTEXT. 

SQL&gt; SELECT timstamp FROM dba_hist_sql_plan WHERE sql_id='your sql_id';