precalculating table size

From: Andreas Jung <ajung_at_sz-sb.de>
Date: Wed, 31 May 2000 12:49:26 +0200
Message-Id: <10514.107236@fatcity.com>

Regard the following table:

(docnum number(10,0), contents varchar2(4000) storage(initial 4k next 4k pctincrease 0)

I inserted 1000 rows into the table - each with a contents column of exact 1000 bytes. I expected a complete size of the table to be about 1.0 - 1.1 MB. Looking at the segment this table allocates 1.5 MB on my system. Were is Oracle wasting the space ?! Or how can reduce this wasting of space ? The table is only used for inserts. Playing with PCTFREE and PCTUSED had also no effect.

Any ideas ?

Andreas Jung Received on Wed May 31 2000 - 05:49:26 CDT