Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index Creation question
This is a multi-part message in MIME format.
------=_NextPart_000_002B_01C01A47.0915D5C0 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I think you are right. When I do index rebuilds I have to be the only = one able to hold locks.
Allan
I have a question about creating an index on a production OLTP = database. This type of work I usually schedule for weekends or late at = night when downtime would cause minimal problems. The client I am = currently working for, as a developer not a DBA--I learn about all = things DBA as I go--, is asking me to do this in the middle of the day. = The deal is I am going away for the weekend and won't be able to do it = until next week when I return.
Anyway my reservation has to do with incoming transactions during the = index build. First I have this thought in the back of my head that = creating an index will lock the table, but I can't really say where that = is coming from. Secondly I am certain that it will have a negative = impact on transactions during the index creation. We are talking about = 4 million rows in the table, and it is THE table read and written to = during OLTP.
Am I just being paranoid, or should I make them wait?
Steve McClure
------=_NextPart_000_002B_01C01A47.0915D5C0 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; =charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I think you are right. When I do =index=20
<DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Allan</FONT></DIV> <BLOCKQUOTE dir=3Dltr=20
day. The deal is I am going away for the weekend and won't be =
able to do=20
it until next week when I return.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Anyway my reservation has to do with =
incoming=20
transactions during the index build. First I have this thought =
in the=20
back of my head that creating an index will lock the table, but I =
can't really=20
say where that is coming from. Secondly I am certain that it =
will have a=20
negative impact on transactions during the index creation. We =
are=20
talking about 4 million rows in the table, and it is THE table read =
and=20
written to during OLTP.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Am I just being paranoid, or should I =
make them=20
wait?</FONT></DIV>