-
Originally posted by tamilselvan
Set PCTFREE to 60 % and PCTUSED 30 %.
I'm sorry U rignt.
PCT_FREE = 100-35%(not 35)
-
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 %.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|