Re: process takes a long- BULK COLLECT
Date: Wed, 13 Aug 2008 13:17:45 -0700
> 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 www.psoug.org 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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Aug 13 2008 - 15:17:45 CDT