Re: Unix question

From: <Lisa_Koivu_at_gelco.com>
Date: Mon, 1 May 2000 10:05:45 -0500
Message-Id: <10484.104548@fatcity.com>

Thanks Chuck and Ruth for your replies.
Chuck, I think you are answering the question about WHY this happened. It does make sense to me, considering that bouncing the db cleared it all up.

Thanks again
Lisa

CHUCK_HAMILTON_at_qvc.com on 05/01/2000 09:46:25 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Subject: Re: Unix question

I assume you mean tables and not files. Oracle converts deleted tables to temporary segments and them one of the background processes, SMON I believe, is supposed to clean them up later. Sometimes it takes a while for that to happen. I think Steve has something on his website about how to post SMON to clean up immediately with an undocumented command. Check out www.ixora.com.au. You might also try offlining and re-onlining the tablespace(s) in question. I think this has the same effect.
--

Chuck Hamilton
Oracle DBA
Enterprise Technical Services

                    Lisa_Koivu_at_ge
                    lco.com              To:     Multiple recipients of list
ORACLE-L <ORACLE-L_at_fatcity.com>
                    Ext: NA              cc:     (bcc: CHUCK HAMILTON/QVC)
                    Sent by:             Subject:     Unix question
                    root_at_fatcity.
                    com


                    04/30/00
                    03:14 PM
                    Please
                    respond to
                    ORACLE-L

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