Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Multiple freelist groups to reduce BBW in non-RAC systems?
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