Hello everyone,
I got a task to reveal an actual person who has deleted a record in the past today. No one has any idea about the day the information has gone, however, it can be found restoring from daily's backup.
When I have a look at into V$SQL I see it contains over 500 records. Additionally, results from "select max(first_load_time) from v$sql" were generated today, and I guess these are not data I needed. So I am kindly asking your help here to find the actual sql delete statement sent to the database if possible.
Finally, I will pretty appreciate if someone can share a link to get detailed information how enabling a saving all of queries against database should be done since storage space is not big deal for me.
Thank you for your help.