Oracle Database Discussions

Any idea,from the deadlock trace file how to find out the username. i can see the session id but not username of the session. Any value which can matches to dba_users..



** 2006-09-03 04:06:41.968
*** SESSION ID:(32.7817) 2006-09-03 04:06:41.693
DEADLOCK DETECTED
Current SQL statement for this session:
UPDATE ACCOUNTSAOD SET BALANCECURRENT=:b1,BALANCE30=:b2,BALANCE60=:b3,BALANCE90=:b4,BALANCE120=:b5,BALANCE150=:b6,BALANCE180=:b7,BALANCE210=:b8,BASEBALANCECURRENT=:b9,BASEBALANCE30=:b10,BASEBALANCE60=:b11,BASEBALANCE90=:b12,BASEBALANCE120=:b13,BASEBALANCE150=:b14,BASEBALANCE180=:b15,BASEBALANCE210=:b16,NEXTREVIEWDAY=:b17 WHERE ACCOUNTS1 = :b18
----- PL/SQL Call Stack -----
object line object
handle number name
40ccb2308 359 procedure TALLYMAN.AGE_DEBT_DAILY
4122217f0 1 anonymous block
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-001400be-000d2100 162 32 X 164 142 X
TX-0013009c-000d183e 164 142 X 162 32 X
session 32: DID 0001-00A2-00000002 session 142: DID 0001-00A4-00481DDB
session 142: DID 0001-00A4-00481DDB session 32: DID 0001-00A2-00000002
Rows waited on:
Session 142: obj - rowid = 00006C70 - AAAQ4UAAXAABPsnAB6
Session 32: obj - rowid = 00006C70 - AAAQ4UAAXAABPspAA4
===================================================