RE: locking issues

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).
Received on Tue Aug 08 2000 - 11:23:49 CDT