Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE file handling capacity
UTL_FILE file handling capacity [message #234513] Tue, 01 May 2007 23:03 Go to next message
sjchanda
Messages: 7
Registered: January 2006
Junior Member
Hi

We have some Pro*C programs which creates extracts from the database. We are planning to convert these into PL/SQL procedures. However, these files can be quite big at times. I wanted to know if there is any limitation in using UTL_FILE or any other packages on the size of the files. We are using Oracle 9.2.0.7 on HP-UX B.11.11

Thanks
SJC.
Re: UTL_FILE file handling capacity [message #234544 is a reply to message #234513] Wed, 02 May 2007 01:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
utl_file writes line per line, as does Pro*C, you have the same limitation.
Remember Pro*C program writes where it is executed (i.e. on the client), PL/SQL writes on the database server.

Regards
Michel
Re: UTL_FILE file handling capacity [message #236730 is a reply to message #234544] Thu, 10 May 2007 14:01 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
UTL_FILE is traditionally quite slow, but things change over time, so you need to benchmark it. utl_file in 9.2.x can be considered slow.


http://asktom.oracle.com/tkyte/flat/

http://www.revealnet.com/pipelines/plsql/tips03.htm#MARCH

Previous Topic: Select from different database
Next Topic: tkprof
Goto Forum:
  


Current Time: Thu Dec 08 00:23:03 CST 2016

Total time taken to generate the page: 0.10277 seconds