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/ _/_/_/
HI,
You can analyze the table with the compute statistics parameter.
Then look at all_tables with that tablename. The empty blocks field
will tell you if you have wasted space. Also avg row length will let
you compute how many rows can be added to each block. This should
give you some indication as to how well you guessed at the initial
table size.
Hope this helps.
Dick
Received on Mon Aug 18 1997 - 00:00:00 CDT
