Fragmentation solution

I am running Oracle 6.0.37 on a MicroVax 4200. The users have been complaining about the speed their jobs have been running. I have run the data cache checks and everything looks pretty good there. Oracle recommended that I do a full export and import to reduce fragmentation. I pretty much understand the procedure they gave me, but there are some fine points I would appreciate some help on.

After I back up all the vms files which make up the database file, redo logs, and control files, do I actually have to delete them before I recreate the database, or will it work just as well to let oracle write over them?

The create command in ora_db is a very skeletal compared to the number of datafiles in my system now. Is it true the import will create all the proper files in the proper places, or should I edit the create command before I execute it?

When I create my additional rollback segment in the system tablespace, do I need to make it identical to the one created originally or does it matter?

Is the Maxdatafiles 32 and maxlogfiles 32 contained anywhere but the initial create command? I would like to raise this total if possible. Could not find limits in the Oracle manuals.

If anybody has any other pitfalls to watch out for, or added instructions, I would appreciate it. Thanks! Received on Mon Aug 29 1994 - 11:15:19 CEST