RE: locking issues

yes. which is why Oracle recommends you not use bitmap indexes on tables that have that column frequently updated

>From: "Koivu, Lisa" <lkoivu_at_qode.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: locking issues
>Date: Tue, 08 Aug 2000 10:06:07 -0800
>
>WHAT?
>
>"whenever any row that the bitmap points to is locked"
>
>Do you mean that an entire table ends up being locked if I am updating one
>row and there is a bitmap index on it?
>
>-----Original Message-----
>Sent: Tuesday, August 08, 2000 1:37 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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).