RE: Unix Command

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 20 Apr 2006 15:42:33 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF681161@EXCNYSM0A1AJ.nysemail.nyenet>

Thanks Paul. I submitted an SR asking for advice (restart the database or reboot the server). I'm guessing the space will either appear over night or we will have to schedule a reboot.

Tom

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Baumgartel, Paul Sent: Thursday, April 20, 2006 3:37 PM
To: Oracle-L Freelists
Subject: RE: Unix Command

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 - 14:42:33 CDT