[oracle@ydcrh04 bdump]$
cat /db/pdhptlt10g/dbdump/udump/pdhptlt10g_ora_10282.trc
Dump file /db/pdhptlt10g/dbdump/udump/pdhptlt10g_ora_10282.trc
Oracle Database 10g Release 10.2.0.4.0 - 64bit Production
ORACLE_HOME = /opt/oracle/product/10.2.0.4.0.as
System name: Linux
Node name: ydcrh04
Release: 2.6.18-128.el5xen
Version: #1 SMP Wed Dec 17 12:01:40 EST 2008
Machine: x86_64
Instance name: pdhptlt10g
Redo thread mounted by this instance: 1
Oracle process number: 34
Unix process pid: 10282, image: oracle@ydcrh04
*** 2010-11-26 13:56:54.855
*** ACTION NAME:() 2010-11-26 13:56:54.847
*** MODULE NAME:(JDBC Thin Client) 2010-11-26 13:56:54.847
*** SERVICE NAME:(SYS$USERS) 2010-11-26 13:56:54.847
*** SESSION ID:(395.657) 2010-11-26 13:56:54.847
DEADLOCK DETECTED ( ORA-00060 )
[Transaction Deadlock]
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-00070011-0001645d 34 395 X 21 420 X
TX-000c000c-000000a7 21 420 X 34 395 X
session 395: DID 0001-0022-0000008E session 420: DID 0001-0015-0000006B
session 420: DID 0001-0015-0000006B session 395: DID 0001-0022-0000008E
Rows waited on:
Session 420: obj - rowid = 000089A4 - AAAImkAAMAAAAT9AA9
(dictionary objn - 35236, file - 12, block - 1277, slot - 61)
Session 395: obj - rowid = 00008D88 - AAAI2IAAMAAAAlKAAH
(dictionary objn - 36232, file - 12, block - 2378, slot - 7)
Information on the OTHER waiting sessions:
Session 420:
pid=21 serial=23 audsid=18888 user: 57/NGENUSR
O/S info: user: loadtest, term: unknown, ospid: 1234, machine: ydcvmapp02
program: JDBC Thin Client
application name: JDBC Thin Client, hash value=2546894660
Current SQL Statement:
select block_id from ags_yard_stack where block_id = :1 and stack_no = :2 and version_stamp = :3 for update
End of information on OTHER waiting sessions.
Current SQL statement for this session:
select 'x' from marshal_sheet where marshal_sheet_id = :1 for update
