Re: using temp tables for staging databases?

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: Binley.Lim_at_xtra.co.nz

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: ListGuru_at_fatcity.com (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).