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

Thread: Table Sizing Calculations

  1. #1
    Join Date
    Dec 2009
    Posts
    1

    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
    ( .....
    STORAGE (INITIAL 200K NEXT 200K),
    ) pctfree 20 pctused 60
    storage
    ( initial 200k
    next 200k
    maxextents unlimited
    pctincrease 0
    );

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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
    Location
    India
    Posts
    57
    Hi,
    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