Re: Free Space within Table or Index

This is a multi-part message in MIME format.

--------------6FCCFEAF394A5EEB510F9CDF
Content-Type: text/plain; charset=iso-8859-1
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Content-Transfer-Encoding: 8bit

Neil Boemio wrote:

> When creating a new table or index and after loading up the data, I'd
> like to be able to tell if I have sized the object too small or much
> too
> big. Is there any view which will tell me how much free space exists
> within a table or index?
>
> ___________________________________________
> _/_/_/ Neil Boemio _/_/_/
> _/_/_/ nboemio_at_bway.net _/_/_/
> _/_/_/ http://www.bway.net/~nboemio/ _/_/_/

  select sum(extent_id), sum(bytes) from sys.dba_extents  where segment_name='TABLE_NAME'
  group by segment_name

If there a lot of extents used already, then it will be better to recreate the table with the initial set to sum(bytes) from above.

Pady Srinivasan

--
MZ


--------------6FCCFEAF394A5EEB510F9CDF
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for pady  Srinivasan
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             pady  Srinivasan
n:              Srinivasan;pady 
org:            Integrated Medical Networks
email;internet: pady_at_imncorp.com
title:          Oracle DBA/UNIX sysadmin
x-mozilla-cpt:  ;0
x-mozilla-html: FALSE
end:            vcard


--------------6FCCFEAF394A5EEB510F9CDF--