Re: Oracle 8.05 hanging on batch inserts.

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.

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