| 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?
do a select from dba_users:
select username from dba_users
where temporary_tablespace='<TS in question>';
If someone has that tablespace as their temporary tablespace, it will fragment it
>From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: What can free space in a TS?
>Date: Fri, 05 Jan 2001 11:06:05 -0800
>
>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).
 |
 |