Re: PCTFREE and data warehousing

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Mon, 21 Jun 2004 11:46:54 -0700 (PDT)
Message-ID: <20040621184654.69478.qmail@web20421.mail.yahoo.com>

• Ben <poelsb_at_post.queensu.ca> 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_at_freelists.org 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
-----------------------------------------------------------------

Received on Mon Jun 21 2004 - 13:43:43 CDT