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: 18 Aug 2003 05:58:26 -0700
Message-ID: <480cb9d4.0308180458.16833573@posting.google.com>


Cheers,
what do you mean by small fraction? the small fraction means nano second or micro second?
while i am doing the math, my database condition is: Regular traffice is on + 10% IO during this time + reports are running + bulk loads are running.

chan

"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message news:<3f402619$0$10354$afc38c87_at_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 Mon Aug 18 2003 - 07:58:26 CDT

Original text of this message

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