yep that works -- that is the total ALLOCATED extents in the
tablespace.
--- Viraj Luthra <viraj999_at_lycos.com> wrote:
> Could I use the following query to get the total used extents :-
>
> SELECT t.tablespace_name, t.initial_extent,
> t.next_extent, t.min_extents, t.max_extents,
> t.pct_increase, status, contents, sum(extents)
> 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
> /
>
>
> There is addition of sum(extents) from dba_segments?
>
> Rgds,
>
> Raj
> --
>
> On Wed, 30 Jan 2002 21:25:21
> Viraj Luthra wrote:
> >Hi all,
> >
> >I want to come to know if I can get the Total number of Used Extents
> in addition to what I am getting in the following query :-
> >
> >SELECT tablespace_name, initial_extent,
> > next_extent, min_extents, max_extents,
> > pct_increase, status, contents
> > FROM sys.dba_tablespaces
> > ORDER BY tablespace_name
> >
> >
> >Is it possible? How?
> >
> >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).
> >
>
>
> --
> 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).
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 - 07:35:36 CST
