Mark, Straight SQL output via sqlplus will be affected by ARRAYSIZE. The drawback with dbms_output is it outputs once block is complete. However I have two (more) ideas for you. 1. do all you need to in a pipelined function, which outputs data in a format you want, preferable connect using bequeth or ipc connection rather than SQLNET. If you must use SQLNET see if you can use large sdu/tdu and set larger arraysize (in sqlplus) and let it rip. I have not tried using parallel pipelined but it may help too. 2. if you can instead of dbms_output, try using dbms_system.ksdwrt(1,'whatever'); This uses buildin c functions to write to session trace file. Once tracefile is written, a bit of trimming might be needed to remove headers and periodic date-timestamps oracle tends to write there. Raj On Wed, Sep 29, 2010 at 12:49 PM, Mark Strickland <strickland.mark@xxxxxxxxx > wrote: > Oracle 10gR2 on Windows 2008R2 with Cygwin and Bash Scripts, 4 CPUs and > 4-GB RAM > >