RE: [sap-basis] ORA-00060: Deadlock detected on oracle 10g
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by Dave Thornburgh on Mar 22 at 4:05 PM |  Mark as helpful |
Mangesh -
There's really no _question_ in your post. If there were, I suspect it
would have nothing to do with SAP Basis.
Dave
From: Mangesh Chede via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: Sunday, March 21, 2010 11:46 PM
To: Dave Thornburgh
Subject: [sap-basis] ORA-00060: Deadlock detected on oracle 10g
Posted by mangeshchede (Mangesh
Chede)
on Mar 22 at 2:49 AM
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /ora10gr2/product/10.2.0/db_1
System name: HP-UX
Node name: silbaan
Release: B.11.23
Version: U
Machine: ia64
Instance name: baan4
Redo thread mounted by this instance: 1
Oracle process number: 57
Unix process pid: 11936, image: oraclebaan4@silbaan
*** 2010-03-21 14:29:49.432
*** SERVICE NAME:(SYS$USERS) 2010-03-21 14:29:49.366
*** SESSION ID:(783.14499) 2010-03-21 14:29:49.366
DEADLOCK DETECTED
[Transaction Deadlock]
Current SQL statement for this session:
INSERT INTO baan.ttfgld418785
(t$ocom,t$tror,t$fitr,t$trdt,t$trtm,t$sern,t$line,
t$ttyp,t$docn,t$fcom,t$orno,t$pono,t$cprj,t$prin,t$si nt,t$li
no,t$tmpk,t$Refcntd,t$Refcntu) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:1 5,:16,:17,:18,:19)
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-00020019-000edc6f 57 783 X 62 890 X
TX-000a0029-000d89d0 62 890 X 57 783 S
session 783: DID 0001-0039-00000994 session 890: DID 0001-003E-00000810
session 890: DID 0001-003E-00000810 session 783: DID 0001-0039-00000994
__.____._ There's really no _question_ in your post. If there were, I suspect it
would have nothing to do with SAP Basis.
Dave
From: Mangesh Chede via sap-basis [mailto:sap-basis@Groups.ITtoolbox.com]
Sent: Sunday, March 21, 2010 11:46 PM
To: Dave Thornburgh
Subject: [sap-basis] ORA-00060: Deadlock detected on oracle 10g
Posted by mangeshchede (Mangesh
Chede)
on Mar 22 at 2:49 AM
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /ora10gr2/product/10.2.0/db_1
System name: HP-UX
Node name: silbaan
Release: B.11.23
Version: U
Machine: ia64
Instance name: baan4
Redo thread mounted by this instance: 1
Oracle process number: 57
Unix process pid: 11936, image: oraclebaan4@silbaan
*** 2010-03-21 14:29:49.432
*** SERVICE NAME:(SYS$USERS) 2010-03-21 14:29:49.366
*** SESSION ID:(783.14499) 2010-03-21 14:29:49.366
DEADLOCK DETECTED
[Transaction Deadlock]
Current SQL statement for this session:
INSERT INTO baan.ttfgld418785
(t$ocom,t$tror,t$fitr,t$trdt,t$trtm,t$sern,t$line,
t$ttyp,t$docn,t$fcom,t$orno,t$pono,t$cprj,t$prin,t$si nt,t$li
no,t$tmpk,t$Refcntd,t$Refcntu) VALUES
(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14,:1 5,:16,:17,:18,:19)
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-00020019-000edc6f 57 783 X 62 890 X
TX-000a0029-000d89d0 62 890 X 57 783 S
session 783: DID 0001-0039-00000994 session 890: DID 0001-003E-00000810
session 890: DID 0001-003E-00000810 session 783: DID 0001-0039-00000994
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Dave ThornburghSAP Basis Enthusiast
Contributed 100 posts in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
55% of IT Pros Use Social Media to Advance Their Careers. See the Survey Results
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
_.____.__ 
