Re: spool performance

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 3 Nov 2004 07:12:58 -0500
Message-ID: <pb2dnW_iVL3RVhXcRVn-1w@comcast.com>

"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 Received on Wed Nov 03 2004 - 06:12:58 CST