Gregory,
This will give you the number of extents allocated and the the last used
block# for a given segment.
select extent_id+1, block_id
from dba_extents
where extent_id = (select max(extent_id)
from dba_extents
where segment_name =
Also use dbms_space.unused_space procedure. This gives the number of unused
blocks. You need to subtract this from the below formula to get the exact
size.
-Original Message-
Sent: Wednesday, April 04, 2001 2:48 PM
To: '[EMAIL PROTECTED]'
Gregory,
This will give you the number of