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: Oracle vs DB2 on heavy OLTP loads

Re: Oracle vs DB2 on heavy OLTP loads

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 16 May 2005 18:28:30 -0700
Message-ID: <1116293070.445952@yasure>


dbguy456_at_yahoo.com wrote:
> We're almost ready to give up on DB2 v8 and consider migration to
> Oracle (the reason is DB2 v8 being unstable). The main question is -
> how good and stable properly configured Oracle is under heavy OLTP load
> (10M+ transactions/day)? DB2 v7 handles such loads nicely, but v8 even
> w/FP7 is a disaster (instance crashes as well as other errors), and
> with supported life of v7 coming to the end, we are pressured to look
> for alternatives (with the only real one being Oracle).
>
> So - does anybody has an experience (good or bad) with running heavily
> loaded OLTP systems on Oracle?

Very very heavy loads? Well lets see ... the FBI, Homeland Security, CIA, NSA, MasterCard, Visa, American Express, Bank of America, Washington Mutual Bank, Cingular Wireless, T-Mobile Wireless, Western Wireless, Amazon.com. Will that do?

My personal best ... (and I am so ashamed) ... American Idol TV show ... 20K+ inserts/second.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon May 16 2005 - 20:28:30 CDT

Original text of this message

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