RE: Linux does not show the freed space by a drop tablespace

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Sat, 8 Jul 2006 13:07:06 +0800
Message-ID: <005101c6a24c$5d238160$176a8420$@poder.003@mail.ee>

It could be 2 cases:

somebody has the files still open, lsof or fuser -m would help identifying the process
if the tablespace was temporary tablespace and its files were unused sparse files, then the files weren't using much disk space anyway - thus there was no space to release back to filesystem.

Tanel.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Greg Norris
Sent: 08 July 2006 08:23
To: oracle-l
Subject: Re: Linux does not show the freed space by a drop tablespace

On 7/7/06, Alfonso León <aleon68_at_gmail.com> wrote:

> yep, I used lsof, but it doesn't show a process using the filesystem
> where it was the datafile.

What arguments did you pass to lsof? I've found "lsof +L1" to work rather well in your scenario, although it may need to be run by root rather than the oracle account.

--
"I'm too sexy for my code." - Awk Sed Fred.
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Sat Jul 08 2006 - 00:07:06 CDT