Re: spool performance

From: Brian Dick <bdick_at_cox.net>
Date: Wed, 3 Nov 2004 12:58:01 -0500
Message-ID: <smyuddc7drox.4ccrmg6zsw8p.dlg@40tude.net>

On Wed, 3 Nov 2004 07:12:58 -0500, Mark C. Stock wrote:

> "chan01" <chandra_2000_us_at_yahoo.com> wrote in message
> news:480cb9d4.0411030400.7fe935ea_at_posting.google.com...

>| I have sql query, it will create a data file. The query execution is
>| taking 20minutes but spool is taking 4 hours to create 600MB file. My
>| question is do we have any other way to handle this condition? I would
>| appreciate your openions.
>|
>| Thanks.

>
> did you try SET TERMOUT OFF and SET TRIMSPOOL ON? (and make sure you're
> executing the SQL from a script file not interactively, since TERMOUT OFF
> only applies to output from script files.
>
> ++ mcs

Also try SET ARRAYSIZE nnn. The default value of nnn is 10, which is way too small for large data transfers. Try larger and larger values of nnn until response improvements are insignificant. Received on Wed Nov 03 2004 - 11:58:01 CST