Sizing NonClustered Tables. !!!

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Thu, 16 Mar 2000 18:05:15 +1100
Message-ID: <8aq1ia$8t8$1@perki.connect.com.au>

I am doing some teting on the space allocation for tha tables and ...... There is something that I can not explaine. Could you please Explane to me why I am geting such result.

I have create a a table with one column as number create table court
(
Court_id number
);
The block size is 8K
Pctfree is 10
based on the calculation explained in DBA Hand book by Kevin Loney, I could fit about 1041.57 rows in one block.
the calculation is

select avg(nvl(vsize(court_id),0))+4 from court where 4 = 3+ number of columns in the table

if block =8k then
available space = ((8*1024)-90)-(((8*1024)-90)*(pctfree/100)) which in my case =7291

BUT I ONLY COULD INSERT 600 records .

Could you please tell me what is wrong.

Thanks Tom Received on Thu Mar 16 2000 - 01:05:15 CST