Re: process takes a long- BULK COLLECT

From: DA Morgan <>
Date: Wed, 13 Aug 2008 13:17:45 -0700
Message-ID: <>

EliasFigueroa wrote:
> The loading process is very slow as optimize
> are 500000 records and takes 5 hours to insert in another table.

The demo code under BULK COLLECT and FORALL in Morgan's Library at easily inserts 400,000 records/second on my laptop.

Try the demo code on your system and see how it performs. If there are issues then you need to look at operating system, init params, and storage infrastructure.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Aug 13 2008 - 15:17:45 CDT

Original text of this message