Calculating average row len in Oracle

From: Kenny Leow <kennyg_at_singnet.com.sg>
Date: Fri, 2 Apr 1999 12:03:17 +0800
Message-ID: <7e05iu$ldc$1@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 - 22:03:17 CST