RE: Sql Loader - Rejects processing takes long - 2 time

We also found that any and all constraint violations take a LONG time to reject (Primary/Unique Key, Unique index, foreign key, check). We wrote Q&D PRO*C programs to pre-validate the input files then SQL*Loaded the good records.

Kevin

> -----Original Message-----
> From: Surjit Sharma [mailto:surjits_at_ozemail.com.au]
> Sent: Monday, September 04, 2000 8:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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.
>
>
> Surjit
>
>
>
>
> --
> Author: Surjit Sharma
> INET: surjits_at_ozemail.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Sep 05 2000 - 06:34:30 CDT