FW: Unix Command

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