Re: PCTFREE and data warehousing

--- Ben <poelsb@xxxxxxxxxxxxxxx> wrote:
> Hi
<snip>
> What I am wondering is if a block
> has a PCTFREE of zero and is filled by inserts, does
> it never make it back
> onto the free list?

> Thanks,

> Ben

Ben,

check the method via which the data is being loaded.
Both sqlldr in DIRECT mode and INSERT /*+ append */ as
a NOLOGGING operation write above the high water mark.
This would imply that regardless of the segment
storage parameters, the existing blocks below the high
water mark would never be written to during loads.

Pd
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: