RE: Linux does not show the freed space by a drop tablespace
- From: "Tanel Poder" <tanel.poder.003@xxxxxxx>
- To: "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 8 Jul 2006 13:07:06 +0800
It could be 2 cases:
1) somebody has the files still open, lsof or fuser -m would help
identifying the process
2) 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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@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:
