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: chan01 <chandra_2000_us_at_yahoo.com>
Date: 17 Aug 2003 17:58:13 -0700
Message-ID: <480cb9d4.0308171658.dd19b33@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.

Billy Verreynne <vslabs_at_dualabsamail.co.za> wrote in message news:<3f3d444a$0$226_at_hades.is.co.za>...
> DOKNIK wrote:
>
> > I am just trying to find info on how long it will take to update a table
> > with 33 million records .
>
> How long is this piece of string I'm holding up to the monitor? You can
> see it can't you?
Received on Sun Aug 17 2003 - 19:58:13 CDT

Original text of this message

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