Re: Full Import Strategy and SGA sizing

Hi John,
answers to your questions
1 It will not be faster. The import utility issues ordinary inserts. If you want to speed up the import there are three recommendations: - increase the buffersize of the import (buffer= in command-line mode), however on NT the maximum is still 64k (c/o Bill Gates) -do not forget to specify commit=y, this will commit every array, instead of once per table
-run the import with indexes=n may be advantageous 2 No, this is untrue, as the import issues ordinary inserts

Hth,

Sybrand Bakker, Oracle DBA

John Vernes wrote:

> Hello,
>
> I will be doing a full import of a database soon and have a question
> regarding the sizing of the SGA (db_block_buffers and shared_pool).
> Will a Full Import be faster if the SGA is very small and the other
> memory is free to the system itself?
> The buffers and shared pool are not necesarry until the Full Import is
> done!! Right??
> I hope there is someone out there who tested this allready or can clearify
> it in some way.
>
> Thanks in advance
>
> -John

Received on Mon Mar 15 1999 - 17:12:12 CST