Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Unix Command

Re: Unix Command

From: Steve Perry <sperry_at_sprynet.com>
Date: Thu, 20 Apr 2006 21:44:12 -0500
Message-Id: <B6BC222D-A01E-4B6A-A9D4-12A415F81467@sprynet.com>


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
Received on Thu Apr 20 2006 - 21:44:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US