Auditing a Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Auditing a Table

  1. #1
    Join Date
    Feb 2001
    Location
    Location: Boston, MA
    Posts
    20

    Post

    I need to log the update statements against a particular table to trouble shoot a deadlock problem. If I use oracle's auditing: AUDIT UPDATE ON EMP; I can't find anywhere in any of the audit tables that captures the sql. Is there a way to get this or do I need to write a seperate trigger on that table and how woyld I do so? The reason for doing this is because when the trace file writes after the deadlock only the bind variables are printed not the actual values of the update. I need to see those to know which row is causing the deadlock.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    The row being updated is actually indicated in the trace file. See http://metalink.oracle.com/metalink/...T&p_id=62365.1 for details.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2001
    Location
    Location: Boston, MA
    Posts
    20
    I've used that article and it does give some useful information but I get NO ROWS in the ROWS WAITED ON section. I've included the deadlock graph for clarification.

    Deadlock graph:
    ---------Blocker(s)-------- ---------Waiter(s)---------
    Resource Name process session holds waits process session holds waits
    TX-00020004-00006118 102 92 X 114 113 S
    TX-000b0032-00005f94 114 113 X 102 92 S
    session 92: DID 0001-0066-00000002 session 113: DID 0001-0072-00000002
    session 113: DID 0001-0072-00000002 session 92: DID 0001-0066-00000002
    Rows waited on:
    Session 113: no row
    Session 92: no row

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