Re: Is sqlplus too slow to unload data?

wangbin_at_start.com.au (wangbin) writes:

> Thanks for all reply.
>
> Sybrand,
> The following is my set parameters in sqlplus. The result is the same.
> set pages 0;
> set lines 10000;
> set termout off;
> set trimspool on;
> set trimout on;
> set echo off;
> set feedback off;
> set verify off;
> set recsep off;
> set arraysize 20;
>

If you do end up using SQL*Plus for this task you might want to benchmark these settings as well:

SET SERVEROUTPUT OFF
SET APPINFO OFF
SET DEFINE OFF
SET AUTOPRINT OFF Play with SET TAB and SET FLUSH. Tune LONGCHUNKSIZE if LONGS or LOBs are being fetched. Keep LINESIZE as small as possible to avoid extra memory allocations/copying.

Chris

-- 
Christopher Jones, Oracle Corporation, Australia.