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

From: Ken Naim <kennaim_at_gmail.com>
Date: Fri, 7 Jul 2006 21:17:41 -0500
Message-ID: <018b01c6a234$b17ce7f0$b4ae6a44@KenHome>

Just lsof and the full path of the file or if it was multiple file from the same tablespace lsof | grep tablespacename. Tablespace name was included included in all our file names. Second option does take a little while.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Greg Norris
Sent: Friday, July 07, 2006 7:23 PM
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 Fri Jul 07 2006 - 21:17:41 CDT