PCTFREE Vs PCTUSED - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: PCTFREE Vs PCTUSED

  1. #11
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    shouldn't pctfree be more like 'Zero' for insert-only table ?

    pctfree = 100 means nothing can be inserted !


    Rajeev Suri

  2. #12
    Join Date
    Jan 2001
    Posts
    642
    Hey, Thats correct,

    In that case , for a insert only tables it means
    pctfree = 0
    and
    pctused = 0

    Advisors, what do you say?

  3. #13
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    When PCTFREE is set to 0, then every update on a row requires a row migration.

    When PCTUSED is set to 0 , then after deleting all rows in the block, it will be added into FREELIST.

  4. #14
    Join Date
    Dec 2005
    Posts
    195
    All,I just read this thread and i see very useful information. I just want to share my thoughts for PCTUSED Vs PCTFREE for insert only tables.

    PCTFREE = 0 AND PCTUSED value does matter for insert only tables. PCTUSED will not play the role as long as we are not deleting any data in the block. Another point here is, we can not set PCTUSED=100 or PCTFREE = 100. The value 100 is invalid value. Also sum of PCTUSED and PCTFREE can not exceed 100. Pease reply if any one is not agreeing. Thanks

    SQL> create table test
    2 (no number)
    3 pctused 0
    4 pctfree 100;
    pctfree 100
    *
    ERROR at line 4:
    ORA-02211: invalid value for PCTFREE or PCTUSED


    SQL> create table test(no number)
    2 pctused 60
    3 pctfree 41;
    create table test(no number)
    *
    ERROR at line 1:
    ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100
    Last edited by pranavgovind; 12-20-2007 at 09:20 AM.

  5. #15
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    its 6 years old for gods sake

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width