Re: Large record count in fet$ for TEMP tablespace

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Tue, 19 Mar 2002 09:08:39 -0800
Message-ID: <F001.0042D4DC.20020319090839@fatcity.com>

I've seen some hacks in the past involving dropping all segments for that tspace, direct deletes from fet$ and then dropping the tablespace...

Not for the faint hearted, certainly not supported and you never heard it from me :-)

Cheers
Connor

• "Casey A. Jordan" <cjordan_at_imcwv.com> wrote: > When trying to select * from
  > DBA_FREE_SPACE_COALESCED the query hangs. It also
  > hangs when trying to calculate free space from the
  > DBA_FREE_SPACE view. I looked in the sys.fet$ table
  > and found that the TEMP tablespace has 21423
  > entries and I believe this is my problem.
  >
  > Now for my questions.
  >
  > 1. Is coalescing the best solution for this
  > problem?
  > 1. Can I coalesce the tablespace without changing
  > it to a permanent tablespace?
  > 2. Is there a faster way to drop the exents then
  > the alter tablespace coalesce command? I ran it for
  > about 10 minutes and canceled it.
  > 3. Is this normal and do I need to coalesce the
  > TEMP tablespace on a regular basis to avoid this
  > happening again?
  >
  >
  > Thanks,
  > CAJ
  >
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

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 Tue Mar 19 2002 - 11:08:39 CST