Re: How to handle large, frequent SQL*Loads?

Hi there,

Since you are doing a bulk insert on a table, consider the following.

1.Increase free list parameter for that table. This is one of the storage clause when you create a table. By default it is 0. You can increase and it will give a performance gain for tables where frequent inserts are being performed.

2. Drop all indexes, constraints in the table.

3. Try to load using DIRECT=Y. SQL*loader will directly update the data files and it will bypass all the redo logs

4. Create the table with a very large initial extent, so that you can prevent row chaining and migration, set PCTINCREASE to 0 (zero)

5. Specify a low PCTFREE parameter .

There are other parameters which can be considered, but I feel the above should definitely improve performance for large loads.

Hope the above helps you..

Regards

N.Prabhakar   Received on Tue Dec 31 1996 - 00:00:00 CST