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
- nlzanen1_at_EY.NL wrote:
>
> Hi,
>
>
> I'd use count i.s.o. sum if you want the number of extents
>
> Jack
>
>
>
>
> "Viraj Luthra" <viraj999_at_lycos.com>@fatcity.com on 31-01-2002
> 08:05:19
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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: 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).
>
>
>
>
> ==================================================================
> 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: nlzanen1_at_EY.NL
>
> 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 - 08:09:54 CST
