Russ,

This is OT relative to your = question slightly, but… Be sure to take some good response time = measurements (10046 level 8) before the rebuild so that you can make objective before/after = comparisons. If you’re right about your prediction that all this work = won’t provide much of a performance impact (and I suspect that you are exactly = right), this is the only way you’re going to be able to prove = it.

Cary = Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- Hotsos Clinic, = Oct 1–3 San Francisco, Oct 15–17 Dallas, Dec 9–11 = Honolulu
- 2003 Hotsos = Symposium on Oracle^® System Performance, Feb 9–12 Dallas
- Next event: Miracle Database = Forum, Sep 20–22 Middlefart Denmark

-----Original Message-----
From: root@fatcity.com [mailto:root@fatcity.com] On Behalf = Of Brooks, Russ
Sent: Tuesday, September = 10, 2002 10: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)?

Thanks,