Regarding Monitoring Database changes ... Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Regarding Monitoring Database changes ...

  1. #1
    Join Date
    Apr 2006

    Regarding Monitoring Database changes ...

    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,

  2. #2
    Join Date
    Sep 2005
    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.

  3. #3
    Join Date
    Sep 2002
    look in v$sql

  4. #4
    Join Date
    Apr 2001
    Bangalore, India
    Oracle Flashback features will give you transaction information ( if you are in 10g) within UNDO_RETENTION period.
    Thomas Saviour(
    Technical Lead (Databases)
    Thomson Reuters (Markets)

  5. #5
    Join Date
    Jun 2006
    Logminer. May help depending upon your redo log size and amounts of data you've processed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width