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.