utl_file.FCLOSE() is slow with large files

Posted by Dan on Stack Overflow See other posts from Stack Overflow or by Dan
Published on 2010-05-10T18:41:53Z Indexed on 2010/05/10 18:44 UTC
Read the original article Hit count: 205

Filed under:
|
|

We are using utl_file in Oracle 10g to copy a blob from a table row to a file on the file system and when we call utl_file.fclose() it takes a long time. It's a 10mb file, not very big, and it takes just over a minute to complete. Anyone know why this would be so slow?

Thanks

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about oracle10g