DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Table Sizing Calculations

  1. #1
    Join Date
    Dec 2009

    Table Sizing Calculations

    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
    ( .....
    ) pctfree 20 pctused 60
    ( initial 200k
    next 200k
    maxextents unlimited
    pctincrease 0

  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    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.

  3. #3
    Join Date
    Mar 2001
    Are you using dictionary managed tablespace or locally managed tablespace for said schema creation.
    Thanks and Regards,
    Gitesh Trivedi
    Dbametrix Solutions
    Database DBA support

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width