Table Sizing Calculations

[gibbs_wesley]

Hello all,

What I'm looking for out of my posting is an Oracle URL that will explain in detail what I am unsure on.

What I am unclear on is when I'm creating a new set of tables (defined from an ERD) under a single schema, how should I decide when creating these individual tables what their specific values like the ones I included below should be, what should be considered when determining these values and what should be used to figure them out:

create table CUSTOMER
( .....
STORAGE (INITIAL 200K NEXT 200K),
) pctfree 20 pctused 60
storage
( initial 200k
next 200k
maxextents unlimited
pctincrease 0
);

[PAVB]

No silver bullet, this is too broad of a question and the right answer depends on you specific environment.

Start here go get the basic storage attributes concepts... http://youngcow.net/doc/oracle10g/se...clauses007.htm
... then research ASSM and MSMM, finally research physical implementation.

Are you going to know how to do it right after reading all the above mentioned material? unfortunatelly the anser is NO but, you are going to get a feeling about what are you dealing with.

[giteshtrivedi]

Hi,
Are you using dictionary managed tablespace or locally managed tablespace for said schema creation.