I am looking for a general rule for determining the optimal setting for next extent size and max extents for oracle tables in an existing database.
Specifically, is there some sort of formula that helps approximate the best values? Up to now I have been using best guess based on the size of the table and how fast it is growing.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!