if you use count, then you need to replace dba_segments with dba_extents each row in dba_segments has a column called "extents" which is the total number of extents allocated to that segment.
there is one row in dba_extents for each allocated extent for a segment. either way will work, but there should be fewer reads if you use dba_segments --- [EMAIL PROTECTED] wrote: > > Hi, > > > I'd use count i.s.o. sum if you want the number of extents > > Jack > > > > > "Viraj Luthra" <[EMAIL PROTECTED]>@fatcity.com on 31-01-2002 > 08:05:19 > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) > > 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). > > > > > ================================================================== > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking van deze > informatie aan > derden is, behoudens voorafgaande schriftelijke toestemming van Ernst > & > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de inhoud van een verzonden e-mailbericht, > noch > voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat > een > verzonden e-mailbericht vrij is van virussen, noch dat > e-mailberichten > worden overgebracht zonder inbreuk of tussenkomst van onbevoegde > derden. > > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij > u > vriendelijk doch dringend het e-mailbericht te retourneren aan de > verzender > en het origineel en eventuele kopieën te verwijderen en te > vernietigen. > > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden > algemene > voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. > De > algemene voorwaarden worden u op verzoek kosteloos toegezonden. > ===================================================================== > The information contained in this communication is confidential and > is > intended solely for the use of the individual or entity to whom it is > addressed. You should not copy, disclose or distribute this > communication > without the authority of Ernst & Young. Ernst & Young is neither > liable for > the proper and complete transmission of the information contained in > this > communication nor for any delay in its receipt. Ernst & Young does > not > guarantee that the integrity of this communication has been > maintained nor > that the communication is free of viruses, interceptions or > interference. > > If you are not the intended recipient of this communication please > return > the communication to the sender and delete and destroy all copies. > > In carrying out its engagements, Ernst & Young applies general terms > and > conditions, which contain a clause that limits its liability. A copy > of > these terms and conditions is available on request free of charge. > =================================================================== > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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).