Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

spool vs utl_file

Status
Not open for further replies.

etprash

MIS
Nov 19, 2007
13
US
Hi,
Which is a better choice : spooling the file from sql plus OR using utl_file from pl/sql.
Considerations -
* load on CPU
* Time
I take it that from code development point of view, spool wins the race.
Any input will be highly appreciated.
Regards,
Prashant
 
Prashant,

Spool: resulting file can reside only on client.
UTL_FILE: resulting file can reside only on server.

Cheers,

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Hi Santa,
Thanks for a reply.
I was looking in terms of CPU usage and time it takes while using the tools (spool and utl_file). Any word on those lines?
-Prashant
 
Mufasa's First Rule said:
One test is worth 100 expert opinions.
The best way to test such a comparison is to "SET TIMING ON" and output a large number of rows using each method.


Then let us know your findings.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top