Re: Out of space. Again.

Nick,
  I am not understanding. Is the database on this filesystem or just the oracle software. Have you removed everything from bdump,cdump, udump, etc. One other thing to note about unix is that if a process has a file open and you remove it, you have only removed the name reference to it, the actual file data will continue to show up in the amount of diskspace used until the process is killed or shutdown.

So if for example filea which uses 100MB is open by process 1 and you remove filea, you will no longer see filea with an ls, but if you do a df you will still see 100MB being used. Once process 1 dies then the 100MB will be freed. This is because Unix uses the name initially to find the inode and then from that point on is uses the inode. If you know a process has a file open and that file is really not needed, but you can't kill the process, try doing a cp /dev/null [file]. This will free the space up without requiring the process to be shutdown.

Mike H.
Nick wrote in message <381FC010.CFD7C63_at_mailcity.com>...
>Hi all,
>
>I have a slight dilemma. Our Oracle server has filled itself up:
>
>/dev/dsk/c0t0d0s7 7104533 6986912 46576 100% /export/home
>
>And I need to fix it temporarily, until everyone goes home and I can
>partition off some space somewhere. Any ideas? I've killed all the core
>files, and I can't find anything else to clean, all thats on
>/export/home is Oracle. Any clues would be great. Thanks,
>
>-Nick
>
Received on Wed Nov 03 1999 - 08:14:07 CST