Re: Total Extents

From: Viraj Luthra <viraj999_at_lycos.com>
Date: Thu, 31 Jan 2002 15:36:40 -0800
Message-ID: <F001.00402BAF.20020131153524@fatcity.com>

Hello All,

Thanks for your responses. I am listing the query, if any one else wants to use the query :-

SELECT t.tablespace_name, t.initial_extent,

               t.next_extent, t.min_extents, t.max_extents,
               t.pct_increase, status, contents, nvl(sum(extents),0)

FROM sys.dba_tablespaces t, sys.dba_segments s where t.tablespace_name=s.tablespace_name(+) group by t.tablespace_name, t.initial_extent,t.next_extent,

      t.min_extents, t.max_extents,
      t.pct_increase, status, contents

Rgds,

Raj

--

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

Author: Viraj Luthra
INET: viraj999_at_lycos.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 Thu Jan 31 2002 - 17:36:40 CST

Re: Total Extents - Thanks