Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-600 Deadlock Issues

Re: ORA-600 Deadlock Issues

From: Deepak Sharma <sharmakdeep_oracle_at_yahoo.com>
Date: Sat, 25 Jun 2005 13:40:18 -0700 (PDT)
Message-ID: <20050625204019.64238.qmail@web31208.mail.mud.yahoo.com>


Is the table(s) partitioned? Do they have Bitmap indexes?

> Hello,
>
> I have code that consistently bombs due to ORA-600 -
> Deadlock Detected.
> The code base is very complex, and a bunch of
> tables get updated via
> direct updates/triggers etc., so debugging at the
> app level is proving
> nightmarish.
>
> Is there any way I can get a hint (from alert.log or
> elsewhere) where
> the contention is?
>
> Thanks for your help.
> Karthik
>
> --
> http://www.freelists.org/webpage/oracle-l
>



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
Received on Sat Jun 25 2005 - 16:45:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US