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.
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.
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