+ Reply to Thread
Page 3 of 3 FirstFirst 1 2 3
Results 21 to 23 of 23
  1. 03-14-2002 05:02 PM #21
    Shestakov
    Shestakov is offline Senior Advisor
    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)
    Reply With Quote Reply With Quote
  2. 03-14-2002 05:15 PM #22
    tamilselvan
    tamilselvan is offline Moderator
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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 %.

    Reply With Quote Reply With Quote
  3. 03-14-2002 05:27 PM #23
    Shestakov
    Shestakov is offline Senior Advisor
    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"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width