Re: Faster option than utl_file

Perl is also significantly faster than sqlplus at writing to a file.

YMMV, but I've seen up to 100% faster, dependent on platform and Oracle version.

I tested it just now on RH Linux, Oracle 10.1 and Perl was about 20% faster.

Jared

On 2/22/06, Guang Mei <GMei_at_ph.com> wrote:
>
> If you can use sqlplus to do the job, I found that spool is faster than
> utl_file.
> Or you can use perl's print , it is faster than utl_file.
> But if you have to use utl_file, instead of writing out each short line,
> you can concate the string to make it long enough, then write it out once
> (the limit is something like 32K).
>
> HTH.
>
> Guang
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of John Dunn
> Sent: Wednesday, February 22, 2006 11:04 AM
> To: oracle-l_at_freelists.org
> Subject: Faster option than utl_file
>
>
> I find utl_file too slow for reading and writing large text files.
>
> In fact it seems faster to read/write files from a Windows Visual Basic
> client application over NFS then to read/write using utl_file on the
> server.
>
> Is there a faster alternative? Or any way to tune utl_file?
>
> Platform is Oracle 9i on AIX 5.
>
> John
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l