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

Home -> Community -> Usenet -> c.d.o.server -> Re: How Long to Update a table with 33 Million records

Re: How Long to Update a table with 33 Million records

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Mon, 18 Aug 2003 11:03:52 +1000
Message-ID: <3f402619$0$10354$afc38c87@news.optusnet.com.au>


You've got a serious problem.
I can update 180K rows in a 17million
table in my PC in a small fraction of
that time.

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
"chan01" <chandra_2000_us_at_yahoo.com> wrote in message news:480cb9d4.0308171658.dd19b33_at_posting.google.com...

> This is my config. SunFire 3800 with 745x8 CPUs and 8 GB RAM DB
> 8.1.6.0 Veritas QI file system on Sun T3's. i have a 17 million rows
> in a table which i am updating with 18 byets per record. For 180k
> records to update it took us 2 minutes.
>
Received on Sun Aug 17 2003 - 20:03:52 CDT

Original text of this message

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