How to find what all DML statements executed
I have one severe problem...
Some user has deleted all the rows from one table called tab1...
Now management has asked me to get the details of the user who has done this alongwith timestamp....
I have checked V$SQL, V$SQLAREA and V$SQLTEXT to find any row contains tab1 in the sql statement...All the retrieved rows are just select statements and no any update or delete statement i found...
I dont have enabled sql_trace...Even LogMiner is also not configured..
Can any one help me out to find the solution..
Is there any view / table which stores all the executed sql's..
Click Here to Expand Forum to Full Width