Re: Fast output of SQL statement to file SQL Plus

On Wed, 13 Jun 2007 15:19:57 -0700, William Robertson <williamr2019_at_googlemail.com> wrote:

>On Jun 13, 7:40 pm, sybra..._at_hccnet.nl wrote:
>> On Wed, 13 Jun 2007 10:46:14 -0700, Mensur <mmedic..._at_gmail.com>
>> wrote:
>>
>> >Is there a way to quickly output large number of rows from a SQL
>> >statement to a file through SQL plus. I tried using spool but that is
>> >slow. Is there another way? I am using Oracle 10g.
>>
>> >Thanks!
>>
>> Put the sql in a file, the spool command prior to the select, and you
>> won't have to scroll your output over the screen.
>>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>
>Also worth setting TERM OFF, TRIM ON and ARRAYSIZE to a hundred or so.
>I've always found it very fast.

IIRC TERM is always off during SPOOL and TRIM always ON. ARRAY 100 can result in delays when output length * ARRAY > SDU.

-- 
Sybrand Bakker
Senior Oracle DBA