| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Total extents
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:Received on Thu Jan 31 2002 - 01:14:23 CST
>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).
 |
 |