How to check last dml statement executed on a table in oracle

How to check last dml statement executed on a table in oracle

In this post , we will be discuss about how to check last dml statement executed on a table in oracle. We can use the help of this below sql to find out the dml statement executed on a table in oracle. It helps to provide the dml operations details based on the DB sessions running in oracle DB. This is one of the usefully sql query to keep track or to do debugging the dml statement for some specific table in oracle. Here below , is the complete detail about how to check last dml statement executed on a table in oracle.

how to check last dml statement executed on a table in oracle

3 Important Table used by SQL Query to check last dml statement executed on a table in oracle

1.dba_tables
2.v$session
3.v$sqltext

Detail SQL Query to check last dml statement executed on a table in oracle

select t.table_name, x.sql_text from 
dba_tables t, 
v$session s,
 v$sqltext x
where x.sql_id=s.sql_id 
and t.owner=s.schemaname
 and t.owner='OWNER_NAME' 
and t.table_name=:P_TABLE_NAME;

how to check last dml statement executed on a table in oracle

how to check last dml statement executed on a table in oracle