| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 Liststo: 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). Received on Mon May 01 2000 - 08:38:17 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |