OraFAQ Forum: SQL & PL/SQL » UTL_FILE file handling capacity

Home » SQL & PL/SQL » SQL & PL/SQL » UTL_FILE file handling capacity

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

UTL_FILE file handling capacity [message #234513]

Tue, 01 May 2007 23:03

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.

Report message to a moderator

Re: UTL_FILE file handling capacity [message #234544 is a reply to message #234513]

Wed, 02 May 2007 01:43

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: UTL_FILE file handling capacity [message #236730 is a reply to message #234544]

Thu, 10 May 2007 14:01

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

Report message to a moderator

Previous Topic:	Select from different database
Next Topic:	tkprof

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 07 00:29:29 CST 2024