Re: Convert SAP Oracle Database to IBM DB2 Database??
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 07 Feb 2008 15:28:26 -0800
Message-ID: <1202426881.339734@bubbleator.drizzle.com>
> 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
Date: Thu, 07 Feb 2008 15:28:26 -0800
Message-ID: <1202426881.339734@bubbleator.drizzle.com>
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>
-- Daniel A. Morgan Oracle Ace Director & Instructor University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Feb 07 2008 - 17:28:26 CST