Hello;

Set the BUFFER-Val very high ( Increasing the INSERT-rowset-size );
and it would be best if the dumps has been created with DIRECT=Y

Is your DB in ARchive-log-Mode?
Probably switching the DB to NONARCHIVELOG-MODE
Then importing
Then ARCHIVELOG-MODE
Then Full-backup of DB

would be faster too

Your IO between Online-Redo and Datafiles should be seperated
Your Redo-files should be large due to less checkpointes >= 64M

The Dumpfiles may not be in the Storage of the Database at all; Best : own disk and controller;



COMMIT=N could overflow the ROLLBACK-Segments

Orca




[Edited by Orca777 on 06-12-2002 at 02:31 AM]