RE: SQLLDR or UTL_FILE package? Which is faster?

From: Randy Johnson <randyjo_at_sbcglobal.net>
Date: Thu, 14 Jun 2007 19:14:17 -0500
Message-ID: <007501c7aee2$1d4d0fe0$6601a8c0@scraunch>

If you can do parallel direct loads it would be tough to beat SQL Loader. Clear back in '98 using Oracle 7.3.4 I was getting 15000 rows per second. I'm sure with the hardware and SAN systems available today you could beat that by a large margin.

I'm looking forward to hearing from anyone who has more current benchmarks than mine.

-Randy

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ram Srinivasan
Sent: Thursday, June 14, 2007 4:55 PM
To: Oracle-L
Subject: RE: SQLLDR or UTL_FILE package? Which is faster?

All:
Is SQLLDR faster or UTL_FILE utility faster? For loads of 130 million rows with about 200 columns, which tool is better?
We are on 8.1.7 on Sun server.

Thanks for your input.

--

Sincerely
Ram Srinivasan
Charlottesville, VA.

No virus found in this incoming message. Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.15/848 - Release Date: 6/13/2007 12:50 PM

No virus found in this outgoing message. Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.15/848 - Release Date: 6/13/2007 12:50 PM

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 14 2007 - 19:14:17 CDT