Find time of execution of old query in Oracle I have a delete query which was run on a table in Oracle 11g Enterprise Edition about 2 months back. I need to find the exact time of when the query was executed.

I found the query in the DBA_HIST_SQLTEXT view. But I do not see any date/time field in the table to find the exact time of execution. Is there any way that this can be found out?

I also tried to extract the same from AWR report. But snapshots are available only till 1.5 months back.
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';