Re: Oracle performance on Large loads.

Good suggestions, I have one more.
Look up and use the buffer parameter in the import. I have been told :

specify BUFFER as part of the import. default is 4096 (4K). we can give it 10M, oracle will use it based on availability, i.e. it won't give an error even if it's not able to find 10M of memory.

Haven't tried it yet myself. good luck.

janet

Lun Wing San (Oracle) wrote:
>
> thielm wrote:
>
> > Does anyone have any experience with loading very large amounts of
> > fairly complicated data
> > and if so does 140 hours seem normal ? I've tried SQL Loader but because
> > of the complexity
> > of the relations in one record and the possible relations to other
> > records it seems almost
>
> Two recommendations:
> 1 disable all database triggers before loading.
> 2 drop all indices before loading.
  Received on Thu Dec 12 1996 - 00:00:00 CET