How to find what all DML statements executed
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: How to find what all DML statements executed

Hybrid View

  1. #1
    Join Date
    Feb 2004
    Location
    Ahmedabad, INDIA
    Posts
    7

    How to find what all DML statements executed

    Hi..

    I have one severe problem...

    Some user has deleted all the rows from one table called tab1...

    Now management has asked me to get the details of the user who has done this alongwith timestamp....

    I have checked V$SQL, V$SQLAREA and V$SQLTEXT to find any row contains tab1 in the sql statement...All the retrieved rows are just select statements and no any update or delete statement i found...

    I dont have enabled sql_trace...Even LogMiner is also not configured..

    Can any one help me out to find the solution..

    Is there any view / table which stores all the executed sql's..

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    unless you have auditing/log miner.. there no chance..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Apr 2005
    Posts
    7
    I do not think u could get the DML operations unless u previously
    opened auditing on the tables.
    You can track the DML operations done on the tables by enabling auditing option in oracle database. But it increases the load of the server on each DML operation. Should be carefull when and the extent of the auditing.
    regards,

  4. #4
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by syucel
    I do not think u could get the DML operations unless u previously
    opened auditing on the tables.
    You can track the DML operations done on the tables by enabling auditing option in oracle database. But it increases the load of the server on each DML operation. Should be carefull when and the extent of the auditing.
    regards,
    LOG MINER will do.

  5. #5
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Check all those userid u had granted delete to that table and maybe
    you got security user time logs who was there at the time the crime
    took place

    Ms C3

    PS. i just love lots of my name appering on the forum and overwrite
    papa reydp

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by kris123
    Check all those userid u had granted delete to that table and maybe
    you got security user time logs who was there at the time the crime
    took place

    Ms C3

    PS. i just love lots of my name appering on the forum and overwrite
    papa reydp
    This doesn't give you concrete proof.

  7. #7
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    Better than nothing, at least u done something to make ur boss see ur
    working on it

  8. #8
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by kris123
    Better than nothing, at least u done something to make ur boss see ur
    working on it
    It is much impressive to your boss when you can identify who had done it with proof.

  9. #9
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    He cant coz he said he didnt configure auditing and arhiving and
    logminer

    Ok back to work now....i still have to test the applications if it
    will run on my new migrated 10g. I just got stuck on that invalid
    procedure that blinded me with that numder(40)

    You can now have all ur names appear here papa
    Last edited by kris123; 04-29-2005 at 03:33 AM.

  10. #10
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    LogMiner need to be configure.
    You only run it when it's necessary.

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