Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Multiple freelist groups to reduce BBW in non-RAC systems?

Multiple freelist groups to reduce BBW in non-RAC systems?

From: Don Burleson <don_at_burleson.cc>
Date: 16 Jan 2003 18:59:58 -0800
Message-ID: <998d28f7.0301161859.201a5063@posting.google.com>


Rich Niemiec, president of IOUG writes in Oracle magazine (page 100, Jan 2003):

Buffer Busy - "This is a wait for a buffer that is being used in an unshareable way or is being read into the buffer cache. . . . wait is on a segment header. If this is the case, increase the freelist groups or increase the pctused to pctfree gap."

I was always under the impression (from Oracle Support) that:

1 - An instance is only able to attach to one freelist group, and multiple freelists groups are only for OPS/RAC systems.

2 - The best way to reduce segment header contention is to add multiple freelists, not freelist groups.

Has anyone ever tried multiple freelists groups or increasing the PCTUSED-PCTFREE "gap" top reduce segment header contention? Received on Thu Jan 16 2003 - 20:59:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US