RE: Unix Command

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]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_at_credit-suisse.com
> 212.538.1143
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]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
> --
> http://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
> ======================================================================
> ========
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l