RE: Total Extents

From: Post, Ethan <Ethan.Post_at_ps.net>
Date: Thu, 28 Feb 2002 11:18:54 -0800
Message-ID: <F001.0041B97A.20020228111854@fatcity.com>

Thanks Connor, that is a lot faster. I think I will go with the idea of just watching for any dramatic drops in DBA_FREE_SPACE. I have everything tied down pretty tight but if a single object on a near empty tablespace started to grow uncontrollably I wouldn't pick it up till tablespace hit 75% or so or the next time I review my daily reports. This way I will get notified a bit sooner.

• Ethan

-----Original Message-----
Sent: Thursday, February 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L

dba_segments is a view on sys_dba_segs which is:

all "normal" segments
union all
all temp segs
union all
all rollback segs

the last two of which we rarely care about when it comes to checking space etc. You can get (some) gains by creating your own view on just the "normal" segs

hth
connor
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Post, Ethan
  INET: Ethan.Post_at_ps.net

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 Thu Feb 28 2002 - 13:18:54 CST