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

From: Serge Rielau <>
Date: Thu, 07 Feb 2008 21:35:44 -0500
Message-ID: <>

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.


Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Thu Feb 07 2008 - 20:35:44 CST

Original text of this message