Re: Oracle is painfully slow when doing massive INSERTs
From: Halley Pacheco de Oliveira <halley_at_domain.com.br>
Date: 1998/03/14
Message-ID: <350a7107.4321129_at_news.domain.com.br>#1/1
Date: 1998/03/14
Message-ID: <350a7107.4321129_at_news.domain.com.br>#1/1
Hi,
To do massive inserts you should commit after inserting a determined number of lines. The import utility has this option. If you don´t commit, for the rollback be possible, the insert process becomes extremely low.
Best regards,
Halley
Received on Sat Mar 14 1998 - 00:00:00 CET