Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Index Creation question

Index Creation question

From: Steve McClure <steve_at_pactr.com>
Date: Fri, 8 Sep 2000 15:40:34 -0700
Message-Id: <10613.116561@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_0191_01C019AB.2091C520 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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_0191_01C019AB.2091C520 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 have a question about creating an =
index on a=20
production OLTP database.&nbsp; This type of work I usually schedule for =

weekends or late at night when downtime would cause minimal = problems.&nbsp; The=20
client I am currently working for, as a developer not a DBA--I learn = about all=20
things DBA as I go--, is asking me to do this in the middle of the = day.&nbsp;=20
The deal is I am going away for the weekend and won't be able to do it = until=20
next week when I return.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Anyway my reservation has to do with =
incoming=20
transactions during the index build.&nbsp; First I have this thought in = the back=20
of my head that creating an index will lock the table, but I can't = really say=20
where that is coming from.&nbsp; Secondly I am certain that it will have = a=20
negative impact on transactions during the index creation.&nbsp; We are = talking=20
about 4 million rows in the table, and it is THE table read and written = to=20
during OLTP.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Am I just being paranoid, or should I =
make them=20

wait?</FONT></DIV>

<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Steve =
McClure</FONT></DIV></BODY></HTML> Received on Fri Sep 08 2000 - 17:40:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US