Happy rebuild story :o)

From: Eric Lansu <eric.lansu_at_quicknet.nl>
Date: Thu, 3 Aug 2000 08:23:24 +0200
Message-Id: <10577.113685@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0EF8_01BFFD24.17A718A0 Content-Type: text/plain;

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

Hello dear listers,

Last 3 nights I have been busy rebuilding a machine for Oracle. It was a = system with tablespace-striping over different disks / controllers, and = I rebuild it to 10 disks without striping 4 disks have application data. = there is are seperate disks for system, rollback, temp and archive. the = datafiles are IO-balanced over the application-data-disks. I applyed the = tricks of uniform-sized extents, seperarate mountpoint for every disk = etc.

There is running a night-process always taking 3 hours to complete. Now, after rebuild, it is 45 minutes! Same machine, same amount of = disks, memory etc., just the way it is divided over the system. =20

I'm very tired, and off for a 2-week vacation in a couple of hours.

May the database be with you, but I leave it in the office ;-) Eric Lansu

------=_NextPart_000_0EF8_01BFFD24.17A718A0 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 content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DCourier size=3D2>Hello dear listers,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>Last 3 nights I have been busy =
rebuilding a=20
machine for Oracle. It was a system with tablespace-striping over = different=20
disks / controllers, and I rebuild it to 10 disks without striping 4 = disks have=20
application data. there is are seperate disks for system, rollback, temp = and=20
archive. the datafiles are IO-balanced over the = application-data-disks. I=20
applyed the tricks of uniform-sized extents, seperarate mountpoint for = every=20
disk etc.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2></FONT> </DIV>
<DIV><FONT face=3DCourier size=3D2>There is running a night-process =
always taking 3=20
hours to complete.</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>Now, after rebuild, it is 45 minutes! =
Same=20
machine, same amount of disks, memory etc., just the way it is divided = over the=20
system.  </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>I'm very tired, and off for a 2-week =
vacation in=20
a couple of hours.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DCourier size=3D2>May the database be with you, but I =
leave it in=20
the office ;-)</FONT></DIV>
<DIV><FONT face=3DCourier size=3D2>Eric Lansu</FONT></DIV>
<DIV> </DIV></BODY></HTML>
Received on Thu Aug 03 2000 - 01:23:24 CDT