I can't seem to find a few queries I ran a few months ago and it seems my settings were altered today after my computer improperly shut down so they don't show up in the spool sql option. But I am more interested in a comprehensive history of queries have run including the username of the person running, the number of rows processed, the db accessed, the time the query started running and finished, along with length of the query and its text.
Can I retrieve this somehow using V$session or stats. Doesn't seem like it.
I basically just want what was in my query viewer to be accessible. I am no longer logged into that session. I was to see the queries that resulted in errors as well. That is very important.
Is there a solution?
Thanks for having me on these forums and apologize for the length of this question given it is my first question and haven't been around here long enough to be able to help others the way I wast to.