Re: Calculating average row len in Oracle

Hi Kenny,

The size of the table reflects the size of the first extent and then any subsequent extents allocated to it and most likely will not resemble the number of rows and average row length (unless the table is completely full and about to extend, in which case it may be close. The size of the table is going to be the equivalent (or at least close to) the number of blocks allocated to the table.

Hope this helps!

Cheers,

Dave

Kenny Leow wrote in message <7e05iu$ldc$1_at_mawar.singnet.com.sg>...
>Hi there,
>
>I hope you can enlighten me. Recently, I had been doing database tuning and
>trying to size my tables probably. I had done analyze compute statistics on
>all my tables. After doing the analyze, I use the schema manager to view my
>average row len, number of rows in the table and the table size. However, I
>find that the results are very confusing.
>
>Result:
>
>Average row len: 255 bytes
>Total rows in table100
>Table size: 0.04 MB.
>
>I thought that current table size should equal to average row len * total
>rows in table. However, the result is not the same. Can someone please
>enlighten me?
>
>Thanks a million.
>
>
>
>
Received on Thu Apr 01 1999 - 10:33:56 CST