Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 10G and UFS - long write times

Re: 10G and UFS - long write times

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Thu, 8 Jun 2006 10:12:31 -0400
Message-ID: <BAY103-DAV250754E3D31A01FA09E97A68B0@phx.gbl>


How about a 100000 row table and doing
for all in select * from mytable
loop
insert
commit every time

That would be an interesting test. It should be faster in 10g because of automatic bulk inserts, but would show that the same code across different versions is implemented differently.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 08 2006 - 09:12:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US