Guys !!!!

I have a UTL_FILE procedure running within a cursor..for LOOP



It is taking around a minute to write 2Mb which is even slower than
spooling ??



Any ideas ??



I have opend the file handle with 32K buffer (I have a feeling it may
STILL be using the 1K buffer) but I don't know.









This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

Oracle LazyDBA home page