Re: Free Space within Table or Index

pady srinivasan wrote:
>
> 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
> You can analyze the table compute statistics and then look at user or all_tables at the empty blocks and blocks used fields. It also tells you what the average row length is so you can compute anticipated growth.

Hope this helps. Dick Allie
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for pady Srinivasan
  Received on Wed Aug 13 1997 - 00:00:00 CDT