cc:
Sent by: Subject: Total Extents
root@fatcity.
com
February 27,
2002 05:13 PM
Please
respond
ORACLE-L [EMAIL PROTECTED]
s.net cc:
Sent by: Subject:
Total Extents
root@fatcity.
com
February 27,
2002 05:13 PM
Post, Ethan
Ethan.Post@pTo: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
s.net cc:
Sent by: Subject: Total Extents
root@fatcity.
com
cc:
Sent by: Subject: Total Extents
root@fatcity.
com
February 27,
2002 05:13 PM
Please
respond to
ORACLE
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%
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
Ethan.Post@pTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
s.net cc:
Sent by: Subject: 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,
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
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
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,
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)
FROM
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
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
14 matches
Mail list logo