Ora Dummy wrote:
> hi,
>
> Next week, I will be attempting to load 6GB of dump files into
> two tables. I have a 4 WAY CPU and 8GB machine in IBM aix 5L.
>
> Prior to the load, what areas do I need to consider to maximize the
> import performance? I am thinking these are the areas that will affect
> the load greatly
>
> 1. Give Buffer Pool size like 5GB memory (can't give more than that,
> some appl running)
> 2. Use BUFFER=4,000,000,000 during import
> 3. Use COMMIT=Y
>
Yeah, make sure every record is committed....
That will surely impact performance, like you said.
--
Regards,
Frank van Bortel
Received on Mon Apr 18 2005 - 11:05:22 CDT
