RE: What can free space in a TS?

From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
Date: Fri, 5 Jan 2001 12:17:10 -0800
Message-Id: <10732.125889@fatcity.com>

There could be some code out there that drops and recreates tables. You would never know unless you checked at the right time (or turned auditing on).

-----Original Message-----
From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Sent: Friday, January 05, 2001 11:06 AM
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). Received on Fri Jan 05 2001 - 14:17:10 CST