At this point, I would like to suggest that you use the AUTOALLOCATE
method for your Locally Managed Tablespace. I use LMTs with
AUTOALLOCATE exclusively for my tablespaces. I stopped thinking about
extent sizes over two years ago and have never looked back. Why worry
about an "appropriate uniform extent size" when Oracle and AUTOALLOCATE
does a really good job of worrying about extent sizes for you? Change
your LMTs to AUTOALLOCATE and start living!
This was first published in July 2004