RE: Total Extents
That's what I thought too, but it will skip extents from any LMTs in use. And getting extents info when LMTs are is use will be slower as compared to DMTs due the way this info is stored in the bitmap in each datafile for the LMT. - Kirti -Original Message- Sent: Wednesday, February 27, 2002 4:47 PM To: Multiple recipients of list ORACLE-L How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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).
RE: Total Extents
dba_segments is a view on sys_dba_segs which is: all normal segments union all all temp segs union all all rollback segs the last two of which we rarely care about when it comes to checking space etc. You can get (some) gains by creating your own view on just the normal segs hth connor --- Deshpande, Kirti [EMAIL PROTECTED] wrote: That's what I thought too, but it will skip extents from any LMTs in use. And getting extents info when LMTs are is use will be slower as compared to DMTs due the way this info is stored in the bitmap in each datafile for the LMT. - Kirti -Original Message- Sent: Wednesday, February 27, 2002 4:47 PM To: Multiple recipients of list ORACLE-L How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
RE: Total Extents
Kirti, In LMT you can query the X$KTFBUE which is roughly equivalent to UET$ in DMTs. select v.name FILE NAME,count(x.KTFBUEFNO) TOTAL # of EXTENTS from V$datafile v, X$KTFBUE x where v.file#=X.ktfbuefno group by v.name; Ethan, Is this what you are looking for or something else? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Kirti Sent: Thursday, February 28, 2002 7:13 AM To: Multiple recipients of list ORACLE-L That's what I thought too, but it will skip extents from any LMTs in use. And getting extents info when LMTs are is use will be slower as compared to DMTs due the way this info is stored in the bitmap in each datafile for the LMT. - Kirti -Original Message- Sent: Wednesday, February 27, 2002 4:47 PM To: Multiple recipients of list ORACLE-L How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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).
RE: Total Extents
Gopal, Thanks for the info.. - Kirti -Original Message- Sent: Thursday, February 28, 2002 11:53 AM To: Multiple recipients of list ORACLE-L Kirti, In LMT you can query the X$KTFBUE which is roughly equivalent to UET$ in DMTs. select v.name FILE NAME,count(x.KTFBUEFNO) TOTAL # of EXTENTS from V$datafile v, X$KTFBUE x where v.file#=X.ktfbuefno group by v.name; Ethan, Is this what you are looking for or something else? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Kirti Sent: Thursday, February 28, 2002 7:13 AM To: Multiple recipients of list ORACLE-L That's what I thought too, but it will skip extents from any LMTs in use. And getting extents info when LMTs are is use will be slower as compared to DMTs due the way this info is stored in the bitmap in each datafile for the LMT. - Kirti -Original Message- Sent: Wednesday, February 27, 2002 4:47 PM To: Multiple recipients of list ORACLE-L How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan 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: Deshpande, Kirti 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).
RE: Total Extents
Thanks Connor, that is a lot faster. I think I will go with the idea of just watching for any dramatic drops in DBA_FREE_SPACE. I have everything tied down pretty tight but if a single object on a near empty tablespace started to grow uncontrollably I wouldn't pick it up till tablespace hit 75% or so or the next time I review my daily reports. This way I will get notified a bit sooner. - Ethan -Original Message- Sent: Thursday, February 28, 2002 11:23 AM To: Multiple recipients of list ORACLE-L dba_segments is a view on sys_dba_segs which is: all normal segments union all all temp segs union all all rollback segs the last two of which we rarely care about when it comes to checking space etc. You can get (some) gains by creating your own view on just the normal segs hth connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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).
Re: Total Extents
How about counting rows from uet$? I have not tried it. Raj Post, Ethan Ethan.Post@pTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] s.net cc: Sent by: Subject: Total Extents root@fatcity. com February 27, 2002 05:13 PM Please respond to ORACLE-L Anyone recommend a faster access path for getting the total number of extents in the database? select sum(extents) from dba_segments is too slow for my purposes. Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: 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).
Re: Total extents
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) FROMsys.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 FROMsys.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).
Re: Total extents
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) FROMsys.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 FROMsys.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
RE: Total extents
Errata : Change the last line of the query to group by a.tablespace_name Sorry about that !! Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 31 January 2002 13:30 To: Multiple recipients of list ORACLE-L 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) FROMsys.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 FROMsys.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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir 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
RE: Total extents
This query should give u the total number of used extents in a tablespace as well as the number of used blocks and bytes : select a.tablespace_name, NVL(count(extent_id),0) Used Extents, sum(NVL(bytes,0)) Bytes Used, sum(NVL(blocks,0)) Blocks Used from dba_tablespaces a, dba_extents b where a.tablespace_name = b.tablespace_name(+) group by tablespace_name; Hope this helps, Samir Samir Sarkar Oracle DBA - Lennon Team SchlumbergerSema Email : [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +44 (0) 115 - 957 6217 EPABX : +44 (0) 115 - 957 6418 Ext. 76217 Fax : +44 (0) 115 - 957 6018 -Original Message- Sent: 31 January 2002 13:30 To: Multiple recipients of list ORACLE-L 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) FROMsys.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 FROMsys.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). ___ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SARKAR, Samir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Total extents - Thanks
Hello All, Thanks for your responses. I am listing the query, if any one else wants to use the query :- SELECT t.tablespace_name, t.initial_extent, t.next_extent, t.min_extents, t.max_extents, t.pct_increase, status, contents, nvl(sum(extents),0) FROMsys.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 / 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).
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) FROMsys.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 FROMsys.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).
Re: Total extents
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) FROMsys.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 FROMsys.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,