Originally posted by fordikon
will there be any performance bottleneck if we have more datafiles for single tablespace? is it recommended to give auto extend or manually extend the size. what are the precautions to be taken when giving autoextend?.

I don't think there will be any bottle necks if u have more datafiles.
Autoextend is fine but take care to give a max limit.Never give unlimited.Also check for the os limitations

Cheers
Murali