RE: Reorganizing a database

[Cary Millsap]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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, Russ