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

Thread: Regarding Monitoring Database changes ...

  1. #1
    Join Date
    Apr 2006
    Posts
    3

    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,
    frank

  2. #2
    Join Date
    Sep 2005
    Posts
    278
    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
    Location
    England
    Posts
    7,333
    look in v$sql

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

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Jun 2006
    Posts
    259
    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