Message-Id: <10732.125881@fatcity.com> From: "Koivu, Lisa" Date: Fri, 5 Jan 2001 14:34:57 -0500 Subject: RE: What can free space in a TS? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0774E.96A37CA8 Content-Type: text/plain; charset="iso-8859-1" Rich, by chance is this TS somebody's temp tablespace? An obvious one but just a thought. Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -----Original Message----- From: Jesse, Rich [mailto:Rich.Jesse@qtiworld.com] Sent: Friday, January 05, 2001 2:06 PM To: Multiple recipients of list ORACLE-L Subject: What can free space in a TS? So, there I am, with a 20GB 8.0.5 DB. I don't like the idea of using PCTINCREASE>0 in anything non-SYS, so some our TSs will get freespaces that need manual coalescing -- no biggie. However, we have one of TS that regularly shows up in the DBA_FREE_SPACE_COALESCED view with a PERCENT_EXTENTS_COALESCED < 100 or a PERCENT_BLOCKS_COALESCED < 100, yet it has no tables (no other objects exist) that are either deleted or truncated. I've confirmed this with auditing of TRUNCATE and DROP. Given that, how else could freespace fragment? I'm guessing it's something simple, but yesterday was Beer Day (erm, "Payday"). ;) TIA, Rich Jesse System/Database Administrator Rich.Jesse@qtiworld.com Quad/Tech International, Sussex, WI USA ----------------------------------------------------------------------- This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: Rich.Jesse@qtiworld.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@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). ------_=_NextPart_001_01C0774E.96A37CA8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: What can free space in a TS?

Rich, by chance is this TS somebody's temp = tablespace? 
An obvious one but just a thought.

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The information contained herein does not = express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."


-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse@qtiworld.com]
Sent: Friday, January 05, 2001 2:06 PM
To: Multiple recipients of list ORACLE-L
Subject: What can free space in a TS?


So, there I am, with a 20GB 8.0.5 DB.  I don't = like the idea of using
PCTINCREASE>0 in anything non-SYS, so some our = TSs will get freespaces that
need manual coalescing -- no biggie.

However, we have one of TS that regularly shows up in = the
DBA_FREE_SPACE_COALESCED view with a = PERCENT_EXTENTS_COALESCED < 100 or a
PERCENT_BLOCKS_COALESCED < 100, yet it has no = tables (no other objects
exist) that are either deleted or truncated.  = I've confirmed this with
auditing of TRUNCATE and DROP.

Given that, how else could freespace fragment?

I'm guessing it's something simple, but yesterday was = Beer Day (erm,
"Payday").  ;)

TIA,
Rich = Jesse           &= nbsp;           &= nbsp;  System/Database Administrator
Rich.Jesse@qtiworld.com      &nbs= p;      Quad/Tech International, Sussex, WI = USA


---------------------------------------------------------------= --------

This message has been scanned for viruses with Trend = Micro's Interscan VirusWall.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
  INET: Rich.Jesse@qtiworld.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@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