Hi Admin, I got that solution for DDL but whats about DML statement? And my question is for some specific days. So please let me know this. If any script could have made would be helpful. Regards Pablo n
One way is –
- Create a new table like .
create table DML_MONIT ( action_date , insert,update,delete) .
2. Create a triggers with condition, that when any insert,update,delete happens on ur original table, the new table DML_MONIT will be updated accordingly.
like, for each insert, DML_MONIT table column ACTION_DATE will be updated with sysdate and insert will be flagged as 1.
However trigger may impact the performance of the DML operation on the original table, If transactions are very high.