RE: locking issues

Kevin,

Did you take a look at 'DEADLOCKS' in the Oracle Concepts Manual?

There's info there on avoiding them. I bring this up because I haven't seen it mentioned in this thread. The order that locks are taken out can be a cause of deadlocks.

Jared

On Tue, 8 Aug 2000, Toepke, Kevin M wrote:

> Yes. Bitmap indexes are locked whenever any row that the bitmap points to is
> locked -- which could mean 1000s of rows are locked whenever 1 row is
> updated!
>
> And, yes. This was part of the original problem. When we dropped the bitmap
> index, we still got deadlocking -- until I rewrote the code to clean up the
> logic.
>
> Kevin
>
> > -----Original Message-----
> > From: Jamadagni, Rajendra [mailto:rajendra.jamadagni_at_espn.com]
> > Sent: Tuesday, August 08, 2000 12:33 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: locking issues
> >
> >
> > Isn't it true that Bitmap indexes lock more than necessary
> > rows ? I mean if
> > you are updating only one row, when bitmap index gets
> > updated, it locks all
> > the rows that are in the same (index) data block. Could this
> > be one of the
> > problem?
> >
> > I may be wrong, but I know someone will correct me on this ...
> >
> > Cheers
> > Raj
> > ______________________________________________________
> > Rajendra Jamadagni MIS, ESPN Inc.
> > Rajendra dot Jamadagni at ESPN dot com
> > QOTD: Any clod can have facts, but having an opinion is an art !
> > Any opinion expressed here is personal and doesn't reflect
> > that of ESPN Inc.
> >
> > --
> > Author: Jamadagni, Rajendra
> > INET: rajendra.jamadagni_at_espn.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Author: Toepke, Kevin M
> INET: ktoepke_at_cms.cendant.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;-) Regence BlueCross BlueShield of Oregon
jkstill_at_bcbso.com - Work - preferred address Received on Fri Aug 11 2000 - 10:16:51 CDT