RE: Unix Command
- From: "Fenstermacher, Robert" <Robert_Fenstermacher@xxxxxxxxxxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Apr 2006 21:44:47 -0600
This is both an oracle and O/S 'issue'.
In unix, when you delete a file, the filename is removed from the directory,
but the space is only freed up when all other processes that had that file open
have closed the file.
So, until the file's 'use count' goes to zero, the O/S cannot physically remove
the file and the space that it occupies.
So, in effect, until SMON, DBWR, etc gets around to closing the file descriptor
for those datafiles, the space will not be physically freed up. In my
experience on Solaris and HP/UX, this typically takes hours for this to occur.
If you can't wait for hours for the space, and you can't bounce the instance,
then do as someone else already pointed out:
drop all of the objects in the tablespace
shrink the datafiles down as much as you can (down to a meg or so)
then drop the tablespace including contents and datafiles.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Steve Perry
Sent: Thursday, April 20, 2006 8:44 PM
To: Oracle-L Freelists
Subject: Re: Unix Command
Somebody else mentioned the same thing with 9i, AIX on EMC Symmetrix.
She dropped a tablespace and datafiles. It took 12 hours or more
before they could reuse it.
i'd love to know if this is an oracle issue or OS.
Right now it's just finger pointing.
Steve
On Apr 20, 2006, at 02:36 PM, Baumgartel, Paul wrote:
> Just yesterday I did a "drop tablespace ... including contents and
> datafiles" (9.2.0.6 on Solaris). The filesystem space freed up
> later, but not immediately after the drop.
>
> Paul Baumgartel
> paul.baumgartel@xxxxxxxxxxxxxxxxx
> 212.538.1143
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mercadante,
> Thomas F
> (LABOR)
> Sent: Thursday, April 20, 2006 2:43 PM
> To: Oracle-L Freelists
> Subject: Unix Command
>
>
> All,
>
> There is a unix command to show who has what files open on a mount
> point
> - anybody remember what it is?
>
> We dropped a tablespace along with the data files, but the space
> was not
> released. I'm thinking that somehow Oracle did not release the space
> yet. Anybody remember something like this?
>
> This is on Sun Solaris/9.2.0.5.
>
> Thanks
>
> Tom
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> ======================================================================
> ========
> Please access the attached hyperlink for an important electronic
> communications disclaimer:
>
> http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
> ======================================================================
> ========
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
