I'm unclear how BBW is related to PCTUSED. PCTUSED is used to control when blocks are returned to the freelist due to deletions. Blocks already-off the freelist, and above PCTUSED, remain unavailable for inserts.
PCTUSED does not prevent a "block contains too many rows" -since a low PCTFREE will pack the rows tightly anyway. If BBW wait is a problem, then there are other causes. PCTUSED is not one of them, or at least should not be an attempted solution. > I will also add to Tim's response of justifying a smaller PCTUSED. In > addition to the freelist problem he mentioned, there is also a greater > chance of buffer busy waits occuring when a block contains too many rows. In > an OLTP database that is certainly likely to happen - another case for the > default 40 setting for the parameter. In DW, however, the chances of BBW are > low, hence a higher setting may be possible. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
