Re: Faster imports

From: rob van laarhoven <rob_at_dsdelft.nl>
Date: Wed, 19 Jan 2000 15:47:18 +0100
Message-ID: <948293306.130604@newsreader2.wirehub.nl>

This is what I can think of. Maybe one of the suggestions can be used in your shop.

Disable archiving, but you'll have to make a backup immediatly after enabling archiving.
Place dmp file on a different disk than redo-logs, rollback segment, data tablespaces; reducing IO contention.
Create character-separated file and use direct sqlload, this is faster than export.
start database with a init.ora designed to speed up an import
Use a lot of (5?) big redo logs(10Mb?).

One of the reasons why the unrecoverable option is so much faster is that it's bypassing the rollback segments. This can not be done using import. The dml done with the unrecoverable option is lost after a database recovery.

Regards,
Rob.

Rob. Received on Wed Jan 19 2000 - 08:47:18 CST