finding last dml done in database

[mkumarnk]

Try the follsowing query.


select a.address,a.PIECE,a.sql_text ,b.logon_time from v$sqltext a,v$session b
where b.sql_address=a.ADDRESS
and trunc(logon_time) =trunc(sysdate)
order by a.address,a.PIECE ,b.logon_time