What is the relation
between SGA and import utility?
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.
Ans:
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