Reorganizing a database

From: Brooks, Russ <Russ.Brooks_at_dayzim.com>
Date: Tue, 10 Sep 2002 10:41:00 -0400
Message-Id: <22528.293306@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPartTM-000-01b191bd-2b4e-409f-84bf-b48bee43092e Content-Type: multipart/alternative;

boundary="----_=_NextPart_001_01C258D8.149F2730"

------_=_NextPart_001_01C258D8.149F2730
Content-Type: text/plain;

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

Hi,
  We are creating a 45GB database from a restore of a current system. = My boss has requested that I reorganize the entire new database. I have = my doubts that this will provide as much benefit as he seems to expect, = but they are adamant that this is what they want. One of the desired = effects is to resize all the datafiles to uniform sizes and distribute = some I/O. I'm thinking of using a full export as the base of this = activity, splitting the export. This will be done on an HP L class with = 2 500MHz processors and 3 GB of memory.
  What is the best way of accomplishing this as quickly and painlessly = as possible? I've looked through Metalink and various books without = finding a good general procedure for changing the location and sizes of = the datafiles during the import.
  About how long should this take (ballpark)? =20
Thanks,
Russ =20

------_=_NextPart_001_01C258D8.149F2730
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=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D897092014-10092002><FONT face=3DArial=20
size=3D2>Hi,</FONT></SPAN></DIV>
<DIV><SPAN class=3D897092014-10092002><FONT face=3DArial size=3D2>  =
We are=20
creating a 45GB database from a restore of a current system.  My = boss has=20
requested that I reorganize the entire new database.  I have my = doubts that=20
this will provide as much benefit as he seems to expect, but they are = adamant=20
that this is what they want.  One of the desired effects is to = resize all=20
the datafiles to uniform sizes and distribute some I/O.  I'm = thinking of=20
using a full export as the base of this activity, splitting the = export. =20
This will be done on an HP L class with 2 500MHz processors and 3 GB of=20 memory.</FONT></SPAN></DIV>
<DIV><SPAN class=3D897092014-10092002><FONT face=3DArial size=3D2>  =
What is the=20
best way of accomplishing this as quickly and painlessly as = possible?  I've=20
looked through Metalink and various books without finding a good general =

procedure for changing the location and sizes of the datafiles during = the=20
import.</FONT></SPAN></DIV>
<DIV><SPAN class=3D897092014-10092002><FONT face=3DArial size=3D2>  =
About how=20
long should this take (ballpark)?</FONT></SPAN></DIV>
<DIV><SPAN class=3D897092014-10092002><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D897092014-10092002><FONT face=3DArial=20
size=3D2>Thanks,</FONT></SPAN></DIV>
<DIV><SPAN class=3D897092014-10092002><FONT face=3DArial =
size=3D2>Russ =20
</FONT></SPAN></DIV></BODY></HTML>

------_=_NextPart_001_01C258D8.149F2730-- Received on Tue Sep 10 2002 - 09:41:00 CDT