| Pctfree and Pctused [message #54521] |
Wed, 20 November 2002 09:12  |
kiran
Messages: 503
Registered: July 2000
|
Senior Member |
|
|
Hi All,
What values of Pctfree and Pctused are suitable for a typical batch environment?
Regards,
Kiran
|
|
|
|
| Re: Pctfree and Pctused [message #54538 is a reply to message #54521] |
Wed, 20 November 2002 22:00  |
gp
Messages: 46
Registered: September 2002
|
Member |
|
|
it all depends or the update,insert,select activity of your table !! so plan accordingly
high updates then higher pctfree and lower pctused and vice versa
|
|
|
|
| Re: Pctfree and Pctused [message #54568 is a reply to message #54538] |
Thu, 21 November 2002 19:21 |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
|
You reduce pctfree to save space, but at the increased risk of having chained rows when updates run out of space in the block. The default is 10, so reducing that to 0 (say for big read only tables) only save a small amount of data. Increasing pctused makes the block become available sooner for new inserts at the expense of more overhead during DML )because the space is being more actively managed). Batch vs online shouldn't affect the settings. It's pretty rare to get big benefits by chaning these values.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
