Re: sqlldr and sort_area_size

On 16 Apr 2005 01:39:36 -0700, johnleslie_at_madasafish.com (John Leslie) wrote:

>What oracle init.ora parameters are relevant to sqlldr direct path
>load performance in Oracle 8.1.7? Is sort_area_size significant?

No. Sql loader doesn't sort, does it.
And direct path load bypasses the buffer cache, so that is also irrelevant.
You would need to look into the buffer= parameter of sql*loader. Be aware however, as soon as you are using sql*loader in conjunction with any other protocol than IPC or BEQ, the SDU of sql*net comes into play, and making the buffer larger than the SDU of sql*net (default 2k) will result in a performance hit.

--
Sybrand Bakker, Senior Oracle DBA