UTL_FILE in 9iR2

All posts relating to Oracle PL/SQL development.

Moderator: Tim...


UTL_FILE in 9iR2

Postby Guest » Mon Nov 01, 2004 6:09 pm


I was just reading the article you posted on UTL_FILE improvements in 9iR2. Do you know if there are any performance improvements also? I'm using UTL_FILE to create large (4GB+) output flat files in stored procedures in 8i and 9.0.x. The write performance is horrendous but it would be worth upgrading to r2 if it would improve.

Thanks for your input,


Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

RE: UTL_FILE in 9iR2

Postby Tim... » Mon Nov 01, 2004 6:09 pm

I don't think the mechanism has changed at all so I don't think it will be any faster.


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: https://oracle-base.com
My blog: https://oracle-base.com/blog

Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 3 guests