Rule of thumb: AUTOALLOCATE or UNIFORM size for tablespaces Is there a rule of thumb for creating a tablespace with extent management AUTOALLOCATE or UNIFORM? If the latter applies, how to estimate a reasonable extent size?

Even more, what should apply for default tablespaces like SYSTEM, SYSAUX, UNDO, and TEMP?
I agree with Tom Kyte's 2005+ assessment of this:


  I actually am a fan of system allocated extents now.  It grows the
  extent allocation size as the table grows.





  Autoallocate is not going to cause widespread fragmentation.





  IF you know PRECISELY how big the object is, will be or will grow by -- go 
  ahead, do the math, feel  free to use uniform.  Else, use autoallocate...