Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Toad for Oracle - How to get a history of queries/(including those resulting in errors)?

60a0a733-b017-49ca-b8a1-eee1b4fc65ffApr 4 2017 — edited Apr 5 2017

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2017
Added on Apr 4 2017
2 comments
11,483 views