Message-Id: <10577.113685@fatcity.com> From: "Eric Lansu" Date: Thu, 3 Aug 2000 08:23:24 +0200 Subject: Happy rebuild story :o) 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

Hello dear listers,

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.

There is running a night-process = always taking 3=20 hours to complete.

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.

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

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

Eric Lansu