| Regarding Monitoring Database Changes ... [message #185018] |
Sun, 30 July 2006 01:46  |
frank.svs
Messages: 162
Registered: February 2006
|
Senior Member |
|
|
Hi Frns,
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,
frank
|
|
|
|
|
|
|
|
| Re: Regarding Monitoring Database Changes ... [message #185057 is a reply to message #185021] |
Sun, 30 July 2006 15:16  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Salaries were here just because of your example.
But, why would you want to invent something else when Oracle already provides auditing? Or do you really want to write triggers all around to keep trace of users' activities?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
