Re: Oracle vs DB2 on heavy OLTP loads

On Mon, 16 May 2005 15:35:53 -0700, dbguy456 interested us by writing:

> 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?

Oracle has a number of nifty things to help out with such a load, especially related to space pre-alocation.

IN addition, zero-to-minimal change to application needed to get RAC working - RAC being the *database* 'clustering' solution allowing more physical machines to coordinate on one database.

Based on one of my former customers (previous company) being able to feed data at roughly 4500 records per minute without the systems breaking out in a sweat during testing 4 years ago, I'd say you will probably not run into an issue.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com