slow imports

Is it wise to drop the PK index of the table (tables already exist before import) before importing. The documentation states that even if you specify INDEXES=N for the import, the unique indexes are still created.

Also, should I make 1 huge rollback segment for the import or set COMMIT and BUFFER parameters. What would be a reasonable BUFFER setting?

My imports are very slow!! Also, I noticed by looking at the alert.log file that I am doing a log switch very frequently. My redo logs are 10Megs. Is this unusually small? Should they be more on the magnitude of 100M?

By the way, I am doing direct mode exports. Platform: Solaris 2.6

Thanks for any insight!
Lisa Received on Tue Dec 22 1998 - 22:26:27 CET