spool vs utl_file

[etprash]

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

 

[SantaMufasa]

Prashant,

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

Cheers,

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[etprash]

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

 

[SantaMufasa]

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.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]