How to find dml operations on a table in oracle
In this post , we will be discuss about How to find dml operations on a table in oracle. We can use the help of this below sql to find out the dml operations details for 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 operations for some specific table in oracle. Here below , is the complete detail about how to find dml operations on a table in oracle.
 |
| How to find dml operations on a table in oracle |
3 Important Table used by SQL Query find dml operations on a table in oracle
1.dba_tables2.v$session
3.v$sqltext
Detail SQL Query to find dml operations on table in oracle
select t.table_name, x.sql_text fromdba_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 find dml operations on a table in oracle |
0 comments:
Post a Comment