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