You are mostly right.I prefer to extend, rather then auto extend, my data files except for special cases.
It is more troubling as I do not know of a tool that take into account both auto extend and the host file system and gives a warning that if you auto extent to the limit you will fill up the available space on the file system.
Adar Yechiel Rechovot, Israel De DBA wrote:
Auto-extend is just a feel-good marketing tool, imho.
-- //www.freelists.org/webpage/oracle-l