Table Sizing Calculations
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
( initial 200k
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Are you using dictionary managed tablespace or locally managed tablespace for said schema creation.
Click Here to Expand Forum to Full Width