FW: Unix Command

  • From: "Ray Feighery" <ray@xxxxxxxxxxxxxxxxxxxxx>
  • To: "'Oracle-L Freelists'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 21 Apr 2006 09:54:49 +1000

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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]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


--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » FW: Unix Command