Re: Convert SAP Oracle Database to IBM DB2 Database??

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Thu, 07 Feb 2008 21:35:44 -0500
Message-ID: <611tg8F1sn9cmU2@mid.individual.net>

DA Morgan wrote:
> Serge Rielau wrote:

>> joel garry wrote:
>>> Since most systems I've seen are eventually pushed to their limits, I
>>> think this sort of trade-off can bring the day of necessary hardware
>>> upgrade closer.  But maybe the DB2 world is different.
>> The design point is that most systems are I/O and/or main memory bound 
>> and have have some headroom on CPU. If the system is CPU bound then 
>> performance is less likely to improve.
>>
>> Cheers
>> Serge

>
> Though the time required to read 100 blocks is still going to be less
> than the time required to read 300-400 blocks. So while you wouldn't
> want to add additional CPU overhead you might still see a performance
> improvement.
>
> PS: You ought to measure the CPU required in Oracle 11g. A hint ...
> it is very very small. Not like what some other vendors have done. <g>
Apparently Oracle assumed CPU bound systems.. we all make our choices. Time will tell.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Received on Thu Feb 07 2008 - 20:35:44 CST