RE: Unix question

without knowing too much about your setup, this type of behaviour will happen if a process still has the file open. When you delete a file in unix, you are only removing the directory entry. The inode (and therefore the used space) doesn't go away until its link count drops to zero (no directory entries) *and* its usage count drops to zero (not in use by any process).

At 08:45 AM 5/1/00 -0800, Ben Poels wrote:
>Hi,
>
>Unix may still think that the files are locked by an Oracle process.
>First shutdown the database. Then kill any oracle processes that remain
>even after the shutdown.
>If the free space still does not show up then a re-boot will be necessary.
>
>Ben Poels
>Queen's University
>Kingston, Ontario
>(613)533-2449
>
>-----Original Message-----
>Solaris 2.6, using Veritas
>
>I am spending a lovely Sunday afternoon working on rearranging wasted space
>in
>our largest database. I deleted a large number of files ~30 min ago and
>the
>space does not show up as free in df. Does it take a while for this to
>happen?
>If it's not going to free up the exact amount of space I am deleting in
>database
>files this is a waste of my time !!!
>
>Thanks
>Lisa
>
>
>--
>Author:
> INET: Lisa_Koivu_at_gelco.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>--
>Author:
> INET: CHUCK_HAMILTON_at_qvc.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>--
>Author: Ben Poels
> INET: poelsb_at_post.queensu.ca
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>

---
Dennis Taylor