Re: resize datafile contention

> Since the tablespace is empty why not take it offline, drop it, and
> then remove the files at the OS level? The space should be
> immediately reclaimed by the OS this way.

Don't know about Windows, but in Unix (Solaris, AIX, etc), it has almost always taken some time before space is released back to the OS. And quite often, it doesn't do so until an instance bounce. I can't claim positively that it never does so until a bounce, because the longest I have ever waited is something like 5 days. You can look at things like file open descriptors and such like, and if it's held by a background process which never seems to release it - it is effectively a bounce.

I've tried various permutations like off-lining/on-lining datafiles/ tablespaces first/last, when I thought I have found a sure-fire sequence of steps to take which works in test - and guess what - it doesn't work in production. Received on Tue Oct 16 2007 - 02:59:52 CDT