Re: write blob to file

can you please try to create a SQL_TRACE for your test-run? I hope you can find reasonable wait events and timings there to investigate better.

Martin

On Tue, Aug 21, 2012 at 5:43 PM, Jeff Chirco <JChirco_at_innout.com> wrote:
> We have pdf's stored in our database as blob as a secure file which is encrypted and we want to write these blobs out to the file system. I have written this procedure below but it is very slow. The files range from about 90kb to 500kb. I did a test with 10 files and it writes the first two files instantly which happened to be the biggest files 440kb and 180kb but then starts to slow down for each of the next files (which are all around 90kb) and by the time it gets to the 10 file it is crawling. It took about 10 minutes to all 10 files. Am I doing something wrong in this procedure? Is there a better way?
> Thanks

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