RE: Reorganizing a database

From: Inka Bezdziecka <IBezdziecka_at_cupe.ca>
Date: Tue, 10 Sep 2002 12:16:51 -0400
Message-Id: <22528.293338@fatcity.com>

This is a multi-part message in MIME format.

------_=_NextPart_001_01C258E5.78F5C826
Content-Type: text/plain;

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

You can drop/re-create users and tablespaces, and import users. Down = time also depend on i/o bus and disk system.=20 =20
inka
=20
-----Original Message-----
From: Brooks, Russ [mailto:Russ.Brooks_at_dayzim.com] Sent: Tuesday, September 10, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Subject: Reorganizing a database

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_01C258E5.78F5C826
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 6.00.2716.2200" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D768420016-10092002>You=20
can drop/re-create users and tablespaces, and import users. Down = time also=20
depend on i/o bus and disk system. </SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D768420016-10092002></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D768420016-10092002>inka</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D768420016-10092002></SPAN></FONT><FONT face=3DArial = color=3D#0000ff=20
size=3D2><SPAN class=3D768420016-10092002></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D768420016-10092002></SPAN></FONT><FONT face=3DArial = color=3D#0000ff=20

size=3D2><SPAN class=3D768420016-10092002></SPAN></FONT><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Brooks, Russ=20

[mailto:Russ.Brooks_at_dayzim.com]<BR><B>Sent:</B> Tuesday, September 10, = 2002=20
11:44 AM<BR><B>To:</B> Multiple recipients of list = ORACLE-L<BR><B>Subject:</B>=20
Reorganizing a database<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
  <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=20
  that this will provide as much benefit as he seems to expect, but they = are=20
  adamant that this is what they want.  One of the desired effects = is to=20
  resize all the datafiles to uniform sizes and distribute some = I/O.  I'm=20
  thinking of using a full export as the base of this activity, = splitting the=20
  export.  This will be done on an HP L class with 2 500MHz = processors and=20
  3 GB of 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? =20
  I've looked through Metalink and various books without finding a good = general=20
  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 Received on Tue Sep 10 2002 - 11:16:51 CDT