Cluster Gobbling Space. Help!

From: Chakravarthy KM Nalamotu <kittu_at_Hawaii.Edu>
Date: 22 Jul 1999 22:16:57 GMT
Message-ID: <7n858p$ql8@news.Hawaii.Edu>

Dear Oracle Users,
I am having a serious space problem with a table cluster on a 8.0.4.3 database on Solaris.

I have two tables A and B in a CLUSTER. table A has 3 million rows
table B has 6 million rows

I have obtained the average rowsize for each table using

select avg(nvl(vsize(col_a),0))
from table_A;

Avg Row length = 55 and Rows per 4K block = ~50
#of blocks required = 3 million/50 = 60,000 blocks
spacre required= approx 300MB

select avg(nvl(vsize(col_b),0))
from table_B;

Avg Row length = 41 and Rows per 4K block = ~75
#of blocks required = 6 million/75 = 30,000 blocks
space required= approx 400MB

My cluster is taking up a whopping 2895360 blocks = 12GB space. It shouldn't even be using 1GB since I should have saved space using a cluster.
Can someone explain what's happening?

Thank you for your feedback.

Kittu. Received on Thu Jul 22 1999 - 17:16:57 CDT