Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How Long to Update a table with 33 Million records
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...Received on Sun Aug 17 2003 - 20:03:52 CDT
> 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.
>