How to know when a query was executed? How to find out when a query was executed? I ran a query couple of days ago, I'm not sure about the exact time. I want to know at what date and time the query was executed.
Is it possible to get that information?
How to check the server status when a query is running? What information should be checked?


version -oracle 11g
select LAST_LOAD_TIME, LAST_ACTIVE_TIME 
from v$sql
where sql_id = Your SQL ID


Hope this will give you the expected result