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@(protected)]
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@(protected):
>
> 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