Re: PCTFREE and data warehousing
- From: Paul Drake <discgolfdba@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 21 Jun 2004 11:46:54 -0700 (PDT)
--- 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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
