RE: Linux does not show the freed space by a drop tablespace
- From: "Ken Naim" <kennaim@xxxxxxxxx>
- To: <spikey.mcmarbles@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 Jul 2006 21:17:41 -0500
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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@xxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
