Some one seems to have 'resource' role giving them 'unlimited tablespace'
priv and they could be creating some 'temp' tables in it.. If so, try taking
it away (after you put your pager in coffee by mistake ;)
> -----Original Message-----
> From: Kimberly Smith [SMTP:kimberly.smith_at_gmd.fujitsu.com]
> Sent: Friday, January 05, 2001 2:22 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: What can free space in a TS?
>
> 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-----
> Sent: Friday, January 05, 2001 11:06 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.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 - 15:42:39 CST
