I'm sorry U rignt.Quote:
Originally posted by tamilselvan
Set PCTFREE to 60 % and PCTUSED 30 %.
PCT_FREE = 100-35%(not 35)
Printable View
I'm sorry U rignt.Quote:
Originally posted by tamilselvan
Set PCTFREE to 60 % and PCTUSED 30 %.
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 %.
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"Quote:
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 %.