RE: Unix Command

From: <oracle-l-bounce_at_freelists.org>
Date: Thu, 20 Apr 2006 13:59:52 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34171D24C@ADMINMAIL1.ui.uillinois.edu>

Fopen

Oracle is not responsible for releasing the space, the OS is. This will happen everytime you try to rm a file that is open. However, if you dropped from Oracle before rm'ing it, than this scenario would be a little confusing. =)

-----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 1: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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 20 2006 - 13:59:52 CDT