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_01C00179.8B9D9AAA
Content-Type: text/plain;
charset="iso-8859-1"
Oh. I thought it was just because the bitmap indexes expand like crazy when the indexed column is updated - not because there was locking issues.
Thanks Rachel.
-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
Sent: Tuesday, August 08, 2000 4:35 PM
To: Multiple recipients of list ORACLE-L
Subject: 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).
-- Author: Rachel Carmichael INET: carmichr_at_hotmail.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_01C00179.8B9D9AAA 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>Oh. I thought it was just because the bitmap = indexes expand like crazy when the indexed column is updated - not = because there was locking issues. </FONT></P> <P><FONT SIZE=3D2>Thanks Rachel.</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Rachel Carmichael [<A = HREF=3D"mailto:carmichr_at_hotmail.com">mailto:carmichr_at_hotmail.com</A>]</F= ONT> <BR><FONT SIZE=3D2>Sent: Tuesday, August 08, 2000 4:35 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. which is why Oracle recommends you not use = bitmap indexes on tables </FONT> <BR><FONT SIZE=3D2>that have that column frequently updated</FONT> </P> <BR> <P><FONT SIZE=3D2>>From: "Koivu, Lisa" = <lkoivu_at_qode.com></FONT> <BR><FONT SIZE=3D2>>Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>>To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>>Subject: RE: locking issues</FONT> <BR><FONT SIZE=3D2>>Date: Tue, 08 Aug 2000 10:06:07 -0800</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>WHAT?</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>"whenever any row that the bitmap points to = is locked"</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Do you mean that an entire table ends up being = locked if I am updating one</FONT> <BR><FONT SIZE=3D2>>row and there is a bitmap index on it?</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>-----Original Message-----</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>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Yes. Bitmap indexes are locked whenever any row = that the bitmap points to </FONT> <BR><FONT SIZE=3D2>>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> <BR><FONT SIZE=3D2>></FONT> <BR><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> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Kevin</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><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> <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>>-----------------------------------------------------------= ---------</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 from). You may</FONT> <BR><FONT SIZE=3D2>>also send the HELP command for other information = (like subscribing).</FONT> </P> <P><FONT = SIZE=3D2>_______________________________________________________________= _________</FONT> <BR><FONT SIZE=3D2>Get Your Private, Free E-mail from MSN Hotmail at <A = HREF=3D"http://www.hotmail.com" = TARGET=3D"_blank">http://www.hotmail.com</A></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Rachel Carmichael</FONT> <BR><FONT SIZE=3D2> INET: carmichr_at_hotmail.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 =Received on Tue Aug 08 2000 - 15:45:01 CDT