storage parameters

From: <simon.rear_at_almac.co.uk>
Date: 1 Oct 92 12:00:16 GMT
Message-ID: <19921.493.346_at_ALMAC>


Hi all,

I'm using oracle v6 for netware. While busily calculating the storage parameters for my first oracle system and creating the tables I noticed something strange perhaps some of you oracle guru's could explain ??

Within the system there are a couple of very small static tables which will hold at most 30 or 40 records, hence the storage parameters are small ie

CREATE TABLE CATEGORY
 (CATEGORY_REF CHAR(2) NOT NULL,
  CATEGORY_DESC CHAR(15))

 STORAGE (INITIAL      4096
          NEXT         4096
          MINEXTENTS   1
          MAXEXTENTS   1
          PCTINCREASE  0)

After creating the table and querying USER_EXTENTS I find that the above table actually occupies 8192 bytes not 4096 ie 2 oracle blocks ?!?!

The remaining larger tables size is expected, as per the create table statement.

I also confirmed that the oracle block size for the database was 4096 with the sqldba show parameters command.

Not a major problem I admit, but I'd like to know why this happens....

Any ideas?

Simon.Rear_at_Almac.co.uk

---
 ~ OLX 2.1 TD ~ Thesaurus: Ancient reptile with excellent vocabulary
--
ALMAC BBS Ltd. 0324-665371
Dos based USENET access,  call for details!
Received on Thu Oct 01 1992 - 13:00:16 CET

Original text of this message