Skip to Content
0
Former Member
Sep 11, 2007 at 02:11 AM

Question - changing the NEXT extend size manually

153 Views

Hi Guys,

I would like to get clarification on the subjected topic. During DB reorg, we have an option to change the next extend size manulay. If I want to change the next extend size , which is the best practise to follow on deciding the next extend size? Is there any method to calculate the best next extend size?

Also, I would like to know , after a DB reorg - how continuous freespace in a tablespace changes...(i.e) DB02 --> Freespace statistics --> Tablespace --> freespace analysis

Does the continuous freespace has any direct relation with the next extend size that we choos during the DB reorg?

Please also share the link if there is any literature on this topic.

Best regards,

Vinodh.