I have a doubt. When adding datafiles, does 'alter tablespace' lock the entire tablespace? What if there are inserts going on into other datafiles which are already existing in that tablespace? Do the inserts stop, till the new datafile gets built?
In my case it takes almost 2.50 minutes for adding a datafile, but I have not noticed if the inserts stop during the alter tablespace.Can you please clarify?