Regarding Monitoring Database changes ...
I need some small help from u. Here is my problem. In my oracle database there is one schema say "scott".
I am not running my database in Archive log mode nor i turned on my auditing on scott user account. Now see,
Assume that i have logged in as scott user and not performed any DML operations for say one hour. After one hour assume that i
have updated salaries of all employees(say sal=sal+1000) in EMP table. Now question is , as a DBA can i know what changes
have been made on objects which belongs to scott user. Is there any dynamic performance view to check whether what changes
have been made by what users and and what time they made the modifcations to the database. Can we get this informatlion.
or else is there any tool from which we can get this info.
Pls help me.Its urgent for me to know this.
Thanks and Regards,
There are few ways to accomplish ur requirement,
1) Audit the DML actions
2) Write after trigger on the tables which requires auditing, and store the results in a table.
Oracle Flashback features will give you transaction information ( if you are in 10g) within UNDO_RETENTION period.
Logminer. May help depending upon your redo log size and amounts of data you've processed.
Click Here to Expand Forum to Full Width