Re: 10g RAC and db_multi_block_read_count
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 6 Aug 2009 08:32:37 -0700
Message-ID: <a9c093440908060832x1a8b0734s24abf2748fb13935_at_mail.gmail.com>
On Thu, Aug 6, 2009 at 7:28 AM, Yong Huang<yong321_at_yahoo.com> wrote:
> This question was recently raised in another forum. The poster
> had 9208 RAC FOR AIX and dfmbrc was 16, set by itself, and had
> lots of 'global cache cr request' waits (and UDP "socket buffer
> overflows" in `netstat -s'). He changed the parameter to 4 and
> solved the problem. He finally posted this reference:
> http://www-900.ibm.com/cn/support/viewdoc/detail?DocId=2411083L10001
> and quoted Note:228647.1. I couldn't read the Metalink note, but
> after lots of reading pretty much concluded it's a port-specific
> bug although I can't point out the exact bug number (most are
> marked duplicate or incomplete).
Date: Thu, 6 Aug 2009 08:32:37 -0700
Message-ID: <a9c093440908060832x1a8b0734s24abf2748fb13935_at_mail.gmail.com>
On Thu, Aug 6, 2009 at 7:28 AM, Yong Huang<yong321_at_yahoo.com> wrote:
> This question was recently raised in another forum. The poster
> had 9208 RAC FOR AIX and dfmbrc was 16, set by itself, and had
> lots of 'global cache cr request' waits (and UDP "socket buffer
> overflows" in `netstat -s'). He changed the parameter to 4 and
> solved the problem. He finally posted this reference:
> http://www-900.ibm.com/cn/support/viewdoc/detail?DocId=2411083L10001
> and quoted Note:228647.1. I couldn't read the Metalink note, but
> after lots of reading pretty much concluded it's a port-specific
> bug although I can't point out the exact bug number (most are
> marked duplicate or incomplete).
That ML notes points to bug 2475236 in 9.2.0.2 on AIX & Linux. Fixed with a 1 off as well as 9.2.0.3.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 06 2009 - 10:32:37 CDT