Sql Loader - Rejects processing takes long - 2 time

Hi all

I conducted the following test using SQL Loader (8.1.5) conventional path method.

1. A load of 103389 records took 2:57.32 mins to load and consumed 5.45 secs CPU
2. The same load with 10% primary key errors took 17:28.31 mins to load and consumed 49.73 secs CPU.

The load with the rejects takes about 9-10 times more time!!! Any ideas as to what is happening. Why is Oracle taking so long for reject processing.

Your comments are highly appreciated. Received on Mon Sep 04 2000 - 06:25:31 CDT