Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: locking issues
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C0015A.36D06D8C
Content-Type: text/plain;
charset="iso-8859-1"
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-----
From: Toepke, Kevin M [mailto:ktoepke_at_cms.cendant.com]
Sent: Tuesday, August 08, 2000 1:37 PM
To: Multiple recipients of list ORACLE-L
Subject: 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).
>
-- 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). ------_=_NextPart_001_01C0015A.36D06D8C Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: locking issues</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>WHAT? </FONT> </P> <P><FONT SIZE=3D2>"whenever any row that the bitmap points to is = locked"</FONT> </P> <P><FONT SIZE=3D2>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?</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Toepke, Kevin M [<A = HREF=3D"mailto:ktoepke_at_cms.cendant.com">mailto:ktoepke_at_cms.cendant.com</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Tuesday, August 08, 2000 1:37 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: RE: locking issues</FONT> </P> <BR> <P><FONT SIZE=3D2>Yes. Bitmap indexes are locked whenever any row that = the bitmap points to is</FONT> <BR><FONT SIZE=3D2>locked -- which could mean 1000s of rows are locked = whenever 1 row is</FONT> <BR><FONT SIZE=3D2>updated!</FONT> </P> <P><FONT SIZE=3D2>And, yes. This was part of the original problem. When = we dropped the bitmap</FONT> <BR><FONT SIZE=3D2>index, we still got deadlocking -- until I rewrote = the code to clean up the</FONT> <BR><FONT SIZE=3D2>logic.</FONT> </P> <P><FONT SIZE=3D2>Kevin</FONT> </P> <P><FONT SIZE=3D2>> -----Original Message-----</FONT> <BR><FONT SIZE=3D2>> From: Jamadagni, Rajendra [<A = HREF=3D"mailto:rajendra.jamadagni_at_espn.com">mailto:rajendra.jamadagni_at_es= pn.com</A>]</FONT> <BR><FONT SIZE=3D2>> Sent: Tuesday, August 08, 2000 12:33 PM</FONT> <BR><FONT SIZE=3D2>> To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>> Subject: RE: locking issues</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Isn't it true that Bitmap indexes lock more = than necessary </FONT> <BR><FONT SIZE=3D2>> rows ? I mean if</FONT> <BR><FONT SIZE=3D2>> you are updating only one row, when bitmap = index gets </FONT> <BR><FONT SIZE=3D2>> updated, it locks all</FONT> <BR><FONT SIZE=3D2>> the rows that are in the same (index) data = block. Could this </FONT> <BR><FONT SIZE=3D2>> be one of the</FONT> <BR><FONT SIZE=3D2>> problem?</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> I may be wrong, but I know someone will correct = me on this ...</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Cheers</FONT> <BR><FONT SIZE=3D2>> Raj</FONT> <BR><FONT SIZE=3D2>> = ______________________________________________________</FONT> <BR><FONT SIZE=3D2>> Rajendra Jamadagni = MIS, ESPN Inc.</FONT> <BR><FONT SIZE=3D2>> Rajendra dot Jamadagni at ESPN dot com</FONT> <BR><FONT SIZE=3D2>> QOTD: Any clod can have facts, but having an = opinion is an art !</FONT> <BR><FONT SIZE=3D2>> Any opinion expressed here is personal and = doesn't reflect </FONT> <BR><FONT SIZE=3D2>> that of ESPN Inc.</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> -- </FONT> <BR><FONT SIZE=3D2>> Author: Jamadagni, Rajendra</FONT> <BR><FONT SIZE=3D2>> INET: = rajendra.jamadagni_at_espn.com</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>> Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>> San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT SIZE=3D2>> = --------------------------------------------------------------------</FO= NT> <BR><FONT SIZE=3D2>> To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>> to: ListGuru_at_fatcity.com (note EXACT spelling = of 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>> the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>> (or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>> also send the HELP command for other = information (like subscribing).</FONT> <BR><FONT SIZE=3D2>> </FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Toepke, Kevin M</FONT> <BR><FONT SIZE=3D2> INET: ktoepke_at_cms.cendant.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Tue Aug 08 2000 - 12:00:50 CDT