RE: Using functions in sqlldr cripples performance

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn
Sent: Wednesday, 7 March 2007 11:09 PM
To: oracle-l
Subject: Using functions in sqlldr cripples performance

I have a Oracle 9 direct load sqlldr routine which provides adequate performance but have now had a request to delete some characters from the data during the load and set some fields to upper case. However tests show that using UPPER or TRANSLATE in the sqlldr control file has huge negative impact on performance of the load.  

Anyone got a solution to this ?      

John Dunn  

This was a well publicised bug - there was all this hoopla about "direct load NOW with functions as well" when v9 came out, and it was pretty easy to prove that it ran like a dog...in fact, conventional load ran much faster than the direct counterpart.  

So I'd try conventional load - otherwise look at doing the equivalent functions before the load (eg in C or perl)  

hth
connor

--
http://www.freelists.org/webpage/oracle-l