From Martin.Kendall@Rubus.com Tue, 27 Mar 2001 02:50:34 -0800 From: Martin Kendall Date: Tue, 27 Mar 2001 02:50:34 -0800 Subject: RE: Which is faster?? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Thanks guys. -----Original Message----- Sent: 26 March 2001 18:26 To: Multiple recipients of list ORACLE-L Direct patch sqlldr (and insert-append) do allow indexes - its just that you get slugged a little more on rollback and redo... I don't have any metrics to compare - typical usage of either tends be to the ol' a) drop ind, b) load, c) redindex hth connor --- Martin Kendall wrote: > I know that Direct Path of sqlldr does not allow > Indexes > so what is the comparative performance of this > suggestion if > the given Table is indexed ? > > Martin > > -----Original Message----- > Sent: 23 March 2001 09:05 > To: Multiple recipients of list ORACLE-L > > > If you're on 8.0 or higher, try > > insert /*+ APPEND */ > into table > select * from other_table; > > where "table" is defined as nologging. Then you > won't > hit either redo logs or rollback segments..Its the > equivalent of a sqlldr direct load > > hth > connor > > --- CC Harvest wrote: > I have > the following scripts: > > > > insert into table > > select * from table2 > > ; > > > > So if use the about bulk statement in my > > application, and the table2 is big, say 10 > > million records, my concern is that it's > > going to fail because of the possible rollback > > segments failure. So then I have to use PL/SQL > > to create a cursor and commit every 50000 records. > > What's the disadvantage of this?Will it be much > > slower > > than a bulk insert? > > > > Can I do it another way: create a stored procedure > > for this bulk insert, then pin this procedure in > > memory, does it still have RBS problem? > > > > Anyone has similar experience? > > > > Thanks in Advance, > > > > Chris > > > > > > __________________________________________________ > > Do You Yahoo!? > > Get email at your own domain with Yahoo! Mail. > > http://personal.mail.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: CC Harvest > > INET: ccharvest@yahoo.com > > > > Fat City Network Services -- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: ListGuru@fatcity.com (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > ===== > Connor McDonald > http://www.oracledba.co.uk (mirrored at > http://www.oradba.freeserve.co.uk) > > "Some days you're the pigeon, some days you're the > statue" > > ____________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.co.uk address at > http://mail.yahoo.co.uk > or your free @yahoo.ie address at > http://mail.yahoo.ie > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Connor=20McDonald?= > INET: hamcdc@yahoo.co.uk > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Martin Kendall > INET: Martin.Kendall@Rubus.com > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: ListGuru@fatcity.com (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: hamcdc@yahoo.co.uk Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Martin Kendall INET: Martin.Kendall@Rubus.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).