How do I determine my extent size on a table.
Posted on 2008-06-16
I have two tables I have to set extents for - I am doing this as I am still a beginner. I have on table with 500 hundred rows, and I calcualted that the average row size is 30 bytes, cloumns 41bytes.
I am yet to understand how to predict growth rates in regards to extents and bytes.
If one of table grows at 26000 or 660000 a month, how would I determine what intitial extent to set, as well as the next extent sizes. It is obviously a table that requires a hire percent used like 50+ and percent used at around 10.
Any expert clarification to this would be helpful...