Re: resize datafile contention

<csn233_at_gmail.com> wrote in message
news:1192521592.227312.265160_at_q5g2000prf.googlegroups.com...
>
>> 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 think it's depending on the sort of filesystem you are using. For example, on AIX, I know by experience that the jfs filesystem definitely doesn't release the freed space until after an unmount/mount of the filesystem, while jfs2 does.

Matthias Received on Tue Oct 16 2007 - 04:57:16 CDT