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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
