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.