It could happen in case if you have a bitmap index on those columns.
OLTP tables should not have bitmap indexes.
-----Original Message-----
From: Sreedhar_Bhaskararaju
[mailto:oracledba-ezmlmshield-x76687426.[Email address protected]
Sent: Thursday, November 02, 2006 6: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