What to set pctfree and pctused to for a work table? - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: What to set pctfree and pctused to for a work table?

  1. #21
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by tamilselvan
    Set PCTFREE to 60 % and PCTUSED 30 %.
    I'm sorry U rignt.
    PCT_FREE = 100-35%(not 35)

  2. #22
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Never set PCTFREE+PCTUSED= 100.
    This will cause over head on extent management.

    For a OLTP system,
    you can set PCTFREE to 75 % and PCTUSED 15 %.


  3. #23
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Originally posted by tamilselvan
    Never set PCTFREE+PCTUSED= 100.
    This will cause over head on extent management.

    For a OLTP system,
    you can set PCTFREE to 75 % and PCTUSED 15 %.

    I know it. We can disscass this question more detail. Becase we are neighbors. I live in Highland park and we can meet somewhere in "Somerset Diner"

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