| 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: 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
"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_at_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_at_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_at_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_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). ------_=_NextPart_001_01C0774E.96A37CA8 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: What can free space in a TS?</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Rich, by chance is this TS somebody's temp = tablespace? </FONT> <BR><FONT SIZE=3D2>An obvious one but just a thought. </FONT> </P> <P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT> <BR><FONT SIZE=3D2>Oracle Database Administrator</FONT> <BR><FONT SIZE=3D2>Qode.com</FONT> <BR><FONT SIZE=3D2>4850 North State Road 7</FONT> <BR><FONT SIZE=3D2>Suite G104</FONT> <BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT> </P> <P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT> <BR><FONT SIZE=3D2>F: 954.484.2933 </FONT> <BR><FONT SIZE=3D2>C: 954.658.5849</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" = TARGET=3D"_blank">http://www.qode.com</A></FONT> </P> <P><FONT SIZE=3D2>"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."</FONT></P> <BR> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Jesse, Rich [<A = HREF=3D"mailto:Rich.Jesse_at_qtiworld.com">mailto:Rich.Jesse_at_qtiworld.com</= A>]</FONT> <BR><FONT SIZE=3D2>Sent: Friday, January 05, 2001 2:06 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: What can free space in a TS?</FONT> </P> <BR> <P><FONT SIZE=3D2>So, there I am, with a 20GB 8.0.5 DB. I don't = like the idea of using</FONT> <BR><FONT SIZE=3D2>PCTINCREASE>0 in anything non-SYS, so some our = TSs will get freespaces that</FONT> <BR><FONT SIZE=3D2>need manual coalescing -- no biggie.</FONT> </P> <P><FONT SIZE=3D2>However, we have one of TS that regularly shows up in = the</FONT> <BR><FONT SIZE=3D2>DBA_FREE_SPACE_COALESCED view with a = PERCENT_EXTENTS_COALESCED < 100 or a</FONT> <BR><FONT SIZE=3D2>PERCENT_BLOCKS_COALESCED < 100, yet it has no = tables (no other objects</FONT> <BR><FONT SIZE=3D2>exist) that are either deleted or truncated. = I've confirmed this with</FONT> <BR><FONT SIZE=3D2>auditing of TRUNCATE and DROP.</FONT> </P> <P><FONT SIZE=3D2>Given that, how else could freespace fragment?</FONT> </P> <P><FONT SIZE=3D2>I'm guessing it's something simple, but yesterday was = Beer Day (erm,</FONT> <BR><FONT SIZE=3D2>"Payday"). ;)</FONT> </P> <P><FONT SIZE=3D2>TIA,</FONT> <BR><FONT SIZE=3D2>Rich = Jesse &= nbsp; &= nbsp; System/Database Administrator</FONT> <BR><FONT = SIZE=3D2>Rich.Jesse_at_qtiworld.com &nbs= p; Quad/Tech International, Sussex, WI = USA</FONT> </P> <BR> <P><FONT = SIZE=3D2>---------------------------------------------------------------= --------</FONT> </P> <P><FONT SIZE=3D2>This message has been scanned for viruses with Trend = Micro's Interscan VirusWall.</FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Jesse, Rich</FONT> <BR><FONT SIZE=3D2> INET: Rich.Jesse_at_qtiworld.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT>Received on Fri Jan 05 2001 - 13:34:57 CST
 |
 |