Message-Id: <22528.293306@fatcity.com> From: "Brooks, Russ" Date: Tue, 10 Sep 2002 10:41:00 -0400 Subject: Reorganizing a database 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
Hi,
  = 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.
  = 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.
  = About how=20 long should this take (ballpark)?
 
Thanks,
Russ =20
------_=_NextPart_001_01C258D8.149F2730--