Have Geek Brain

Utl_file.FCLOSE () is slower with large files

We use utl_file in Oracle 10g to copy a blob from a table row to a file on the filesystem and when we call utl_file.fclose () it takes a long time. It's a 10MB file, not very large, and it takes just over a minute to complete. Does anyone know why it would be so slow?

thanks

EDIT It looks like it has something to do with our filesystem. When we write to local disk, it works great.

+2


a source to share


2 answers


We have determined that this is a network filesystem problem. When we remove this from the problem and store the file on the local drive, it works great. We were able to test this in a different environment with the same configuration and it is fast and works as expected.

Now we need to get our network guys involved and understand why NFS transfers are so slow in this environment.



EDIT This was the network speed between oracle server and UNIX server. It was configured for 10 MB half duplex. So we came across 100Mb full duplex and now it works great!

+2


a source


Are you doing fflush before? If not, then fclose does fflush for you, and it might be time. Check it out by fflush before closing.



+1


a source






More articles:


All Articles