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

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

FW: Unix Command

From: Ray Feighery <ray_at_seertechsolutions.com>
Date: Fri, 21 Apr 2006 09:54:49 +1000
Message-ID: <008e01c664d5$cf313cc0$96f1fea9@seertechsolutions.com>


Tom

The command to see what user has a file open is fuser.

I have had this exact problem on Solaris. The solution was to restart the Oracle instance.

Now when I have to drop a tablespace on Solaris and I can't reboot. I drop the contents of the tablespace and then resize it down to (say) 1Mb. That space (former size of tablespace -1Mb) is then released at the OS level immediately. I can then drop the tablespace and the extra 1Mb will be available after the next reboot.

Ray

> -----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
Received on Thu Apr 20 2006 - 18:54:49 CDT

Original text of this message

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