Space Usage Question

From: <spam_at_no-spam.com>
Date: Wed, 28 Jan 2004 15:32:59 GMT
Message-ID: <4017cf50.436085858@news.demon.co.uk>

I have a puzzeling question re space usage on a table. we use oracle 8.1.7.4 on Sparc Solaris 8

The tablespace is LMT with 64M extents with autoextend on

we have a table with

avg row len of 390 bytes and
no of rows is 6.7 million
table size 2.6 GB
Block size on the DB is 8K

The table defination is
TABLESPACE BHF
   PCTFREE 10
   PCTUSED 40
   INITRANS 1
   MAXTRANS 255
  STORAGE (
   INITIAL 65536
   MINEXTENTS 1
   MAXEXTENTS 2147483645
   FREELISTS 1 FREELIST GROUPS 1 ) According to our stats the table span 223 extents, But that does not make sense to me, because that mean each exten size is approx 11MB ?

Can any one in the know please explain. I am new to oracle, so please do not flame me if the answer is ovious Received on Wed Jan 28 2004 - 09:32:59 CST