yep that works -- that is the total ALLOCATED extents in the tablespace. --- Viraj Luthra <[EMAIL PROTECTED]> 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: [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).
__________________________________________________ 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: [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).