You basically point out my question: when is it required? If I set it to grow "unlimited", am I pretty safe?
I currently have only one file for the tablespace. However, it now grows to 6GB and I'd like to have the second datafile. Honestly, I am not sure if it's necessary because I have 0+1 RAID. I am just curious how Oracle and what settings determine which table/data goes to which datafile, if I don't explicitly speicify it?
Is it still preferred to have several datafiles for a single tablespace even if it's 0+1?
If I worked with a DBA who set the datafile size to UNLIMITED AND AUTOEXTEND ON, I'd kick his arse from one side of the room to the other. That is STUPID IMO! Set AUTOEXTEND ON BUT ALSOset it to a reasonable MAXSIZE (Mine is 2GB for < 8i, 4GB >= 8i). BUT, it also depends on DB size and filesystems. When do you add another? When it hit's your critical limit... maybe 80 - 90% of capacity... whatever. This is why we monitor the DB. Also, the "A" in DBA does stand for Adminstration.