storage parameters
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