OraFAQ Forum: SQL & PL/SQL » Spooling takes too much time

Home » SQL & PL/SQL » SQL & PL/SQL » Spooling takes too much time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Spooling takes too much time [message #21185]

Wed, 17 July 2002 10:03

Azmat
Messages: 8
Registered: July 2002

Junior Member

Hi All,

I have to create a FLAT File of 700K records. I am using a script that is spooling the result sets to the flat file. But its taking 23 hours. I am running my script from server side and my OS environment is SUN SOLARIS 2.6 with 4 processors.

The query itself returns the result in 1/2 hour but spooling is taking too much time ... IS THERE ANY OTHER WAY AROUND .. plzzzz let me know ..

Regards
Muhammad Azmat

Report message to a moderator

Re: Spooling takes too much time [message #21195 is a reply to message #21185]

Wed, 17 July 2002 13:30

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

For a better performance in spooling the select statement, do the following:
set linesize <actual number of characters in the
columns selected (or record length)>;
or
set trimspool off;
anyhow, i am not very sure, whether it is very helpful.
i would recomend pro*c to do the job.its faster.

Report message to a moderator

Re: Spooling takes too much time [message #21225 is a reply to message #21195]

Thu, 18 July 2002 13:59

andrew again
Messages: 2577
Registered: March 2000

Senior Member

I'd use the "set trimspool on" as suggested - else you get trailing spaces. Also - try "set termout off". If you have an interactive session, you don't want the records to be spooled to your - that could take ages.

Report message to a moderator

Previous Topic:	About sql table
Next Topic:	sql*loader Create a field in loading

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 07:17:55 CDT 2024