Hi,

This is my SQL Loader parameter.

sqlldr control=JJ_EDWLoadCDR.ctl direct=true log=JJ_EDWLoadCDR_BIND_READSIZE_ARRAY.log READSIZE=20000000 COLUMNARRAYROWS=5000

This is my LOG...

Date conversion cache disabled due to overflow (default size: 1000)

Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes:20000000

Total logical records skipped: 0
Total logical records read: 77829
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 16
Total stream buffers loaded by SQL*Loader load thread: 124

Run began on Tue Nov 15 18:31:48 2005
Run ended on Tue Nov 15 18:32:31 2005

Elapsed time was: 00:00:43.13
CPU time was: 00:00:36.93Date conversion cache disabled due to overflow (default size: 1000)

Bind array size not used in direct path.
Column array rows : 5000
Stream buffer bytes: 256000
Read buffer bytes:20000000

Total logical records skipped: 0
Total logical records read: 77829
Total logical records rejected: 0
Total logical records discarded: 0
Total stream buffers loaded by SQL*Loader main thread: 16
Total stream buffers loaded by SQL*Loader load thread: 124

Run began on Tue Nov 15 18:31:48 2005
Run ended on Tue Nov 15 18:32:31 2005

Elapsed time was: 00:00:43.13
CPU time was: 00:00:36.93

I want this loader job to complete under 20 seconds.

Which is the best approach?

Please guide.

Thanks,
Jegan