Re: Stuck between a rock and an IO Bottleneck
From: <rtproffitt_at_my-deja.com>
Date: Thu, 28 Oct 1999 23:32:06 GMT
Message-ID: <7vamdm$lnb$1_at_nnrp1.deja.com>
Date: Thu, 28 Oct 1999 23:32:06 GMT
Message-ID: <7vamdm$lnb$1_at_nnrp1.deja.com>
What if you broke the thing into multiple steps
for less I/O...
example.. create as select where rownum < 1 (this creates the table)
now a Pl/sql block, with perhaps a cursor
to fetch rows and insert, and periodically
COMMIT to keep rollback size small....
Or perhaps insert from the first table,
then use the new table and update, adding
in rows from the second table, then third..
etc... keeping overall memory usage and i/o
perhaps less....
Just some thoughts
Good Luck,
Robert Proffitt
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 29 1999 - 01:32:06 CEST