In a previous thread I was convinced I should use AUTOEXTEND with MAXSIZE: http://www.dbasupport.com/forums/sho...threadid=34935 and I'm now planning to rebuild my tablespaces bearing this in mind (LMT uniform etc etc as well).

Extending a file takes some time - does anyone see a performance hit when files are extended?

I would expect that nothing would "hang", provided that the buffers were big enough to hold all the dirty blocks that are waiting to be written to that file. Have I missed anything?

TIA - DaPi