There will be no bottlenect if you have more datafiles for a single TS, assure that you have span all the Datafile on different disk to avoid I/O, The size of each datafile is OS depanded but dont forget to consider the DBWR Average scan depth.
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?.
Auto extend feature will prevent any error which could occor during transaction in case of lack of space, if autoextent is off you have to manually extend the size which could coz delay. If Autoextend is on then maintain the data growth rate and disk space.
Hope it helps..
Stand up for your principles even if you stand alone!