Now you can check the codes with below query and change the code
accordingly.

You might want to issue a commit after a delete...or start a automoneous
transction ..or can make a session specific temporary table so that no
one can lock the table.

I mean, you should be able to avoid deadlock by changing your code.


-----Original Message-----
From: Sreedhar_Bhaskararaju
[mailto:oracledba-ezmlmshield-x76687426.[Email address protected]
Sent: Thursday, November 02, 2006 9:35 AM
To: LazyDBA Discussion
Subject: RE: ORA-000060: Deadlock

I fond the information from my trace file. The sessions which I am
seeing in trace file are expired.

delete V_SCH where site_code='IA002X'
and ord_type = 'DISCRETE'

Deadlock graph:
---------Blocker(s)--------
---------Waiter(s)---------
Resource Name process session holds waits process session
holds waits
TX-00040029-000e6772 47 84 X 65 24
X
TX-000a001b-000588b2 65 24 X 47 84
X
session 84: DID 0001-002F-00000071 session 24: DID 0001-0041-000001C6
session 24: DID 0001-0041-000001C6 session 84: DID 0001-002F-00000071
Rows waited on:
Session 24: obj - rowid = 000065E4 - AAAGXkAAjAAAFk3AAE
(dictionary objn - 26084, file - 35, block - 22839, slot - 4)
Session 84: obj - rowid = 000065E4 - AAAGXkAAjAAAFlPAAA
(dictionary objn - 26084, file - 35, block - 22863, slot - 0)
Information on the OTHER waiting sessions:
Session 24:

Remaining trace file unable to understand.

Regards,
Sreedhar

________________________________

From: Gaurav Shrivastava [mailto:G.[Email address protected]
Sent: Thu 02/11/2006 19:53
To: Sreedhar_Bhaskararaju
Subject: RE: ORA-000060: Deadlock



**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Check in your trace files, you will get details there

-----Original Message-----
From: Sreedhar_Bhaskararaju
[Email address protected]
Sent: Thursday, November 02, 2006 9:21 AM
To: LazyDBA Discussion
Subject: ORA-000060: Deadlock

Hi All,

I am getting dead lock error often. If I check I got the following
transactions

TX-00040029-000e6772
TX-000a001b-000588b2

select object_id,owner, object_name from all_objects
where object_id in ( to_number( '0029', 'xxxx' ), to_number( '001b',
'xxxx' ) );

object_id,owner, object_name
27,SYS,I_COBJ#
41,SYS,I_USER1

How do I find exactly which objects are casuing this error?

Regards,
Sree


DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html









DISCLAIMER:
This email (including any attachments) is intended for the sole use of
the intended recipient/s and may contain material that is CONFIDENTIAL
AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or
copying or distribution or forwarding of any or all of the contents in
this message is STRICTLY PROHIBITED. If you are not the intended
recipient, please contact the sender by email and delete all copies;
your cooperation in this regard is appreciated.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page