Re: Oracle 8.05 hanging on batch inserts.

In article <290620011105581954%dischner_at_klch.med.uni-muenchen.de>, Anton says...
>
>Hi,
>
>did you have a look at alert_<your_SID>.ora.
>
>Do you still have redo-log switches?
>Do you still have CPU activity?
>
>If you have a commit after every insert, there should be no problem wih
>gazillion of rows.
>

except that performance would weeze and scalability would be limited.

You never want to commit after every insert -- thats the worst thing you can do. It'll generate EXTRA (more) redo, it'll consume MORE cpu, it'll make you WAIT much longer.

wait as long as you can between commits, configure sufficient rollback to do the job.

>good luck,
>
>Toni
>
>--
>ZXR750H, 55 Mm.
>Viereckige Räder sind suboptimal, da sie hoppeln. Besser sind
>dreieckige Räder, denn sie hoppeln pro Umdrehung einmal weniger.
>Posen fuer Anfaenger: http://www.w-klch.med.uni-muenchen.de/dischner

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp