Re: Oracle is painfully slow when doing massive INSERTs

In article <3506e57f.7310326_at_news.anc.net>, John Coy <jcoy@??shizz.net> wrote:
>On Wed, 11 Mar 1998 20:00:17 +0100, "Morten Myrvold"
><someone_at_somwehere.no> wrote:
>>
>>It seems to me that it all boils down to one thing: Oracle's just plain
>>painfully slow on massive INSERT's....
>>
>Just kind of a followup to this, I've also noticed that on Oracle 7.3
>the import utility is painfully slow as well. I can export data quite
>speedily, but when I use the import utility, it takes *hours* to
>import data that only took a few minutes to export.
>
>Is this normal?

Various sources vary, but import is alleged to be 4 to 8 x slower than export according to the last person who helped me from O support. My experience at that time was 4 hours to do a compressed(unix and oracle)/direct exp, 120+ to import it with precreated tables... it appeared to be slowing down as time went on. 7.3.4, with or without indexes, 12G data.
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!