Re: Breaking integers into bytes in PL/SQL?
From: Paul Cluiss <paul_cluiss_at_intervoice-brite.com>
Date: Fri, 19 Nov 1999 17:10:05 -0600
Message-ID: <5E97A2F86F8DC999.C792542D71F424D5.6F8B53AC24A50AD1_at_lp.airnews.net>
Date: Fri, 19 Nov 1999 17:10:05 -0600
Message-ID: <5E97A2F86F8DC999.C792542D71F424D5.6F8B53AC24A50AD1_at_lp.airnews.net>
If you want good throughput, you don't want to close and re-open your file handles w/every write.
Paul Cluiss
Dallas, Texas
Jan-Helge Bergesen wrote:
> .. and speaking of SNP jobs .. are there any way of flushing
> the buffers used by the UTL_FILE package explicitly?
> UTL_FILE.FFLUSH does not work when run in such a job.
> How ever if the filehandle is closed after each write -- all is well
> (except from the fact that the listener recieves the error signal
> (SIGPIPE ?), which can be quite annoying and consume some time).
>
> Suggestions?
> --
> Jan-Helge Bergesen
Received on Sat Nov 20 1999 - 00:10:05 CET