Estimation of Table Sizing
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 19

Thread: Estimation of Table Sizing

  1. #1
    Join Date
    Jan 2001
    Posts
    18
    Hi,

    I am in the process of creating 8i database. I would like to know how to estimate sizing information (storage parameters) for the tables. I have a test database where i have all the tables, but with very less number of records when compared to the actuals. I have the estimated number of rows which will be over a period of time too.


    Anybody please tell me how to estimate the sizing?

    It is URGENT.

    Thanks in advance.

    Regards.

    Sundar


    Share on Google+

  2. #2
    Join Date
    Aug 2000
    Posts
    236
    Analyze your test database schema.

    You can get average rowlength of each table. Multiply this with your estimate of number of rows which will be inserted over a peiod of time. This will give you rawsize.

    Now factor in additional space depending on your PCTFREE parameter and the kind of tablespaces you will use, DM or LMT's.

    Hope this helps.

    Nizar
    Share on Google+

  3. #3
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620
    Hi,

    I have recently developed the excel sheet with the help of Oracle Press book for sizing the table.

    Pl. send me your mail id so that I can send that one.

    Thanks,
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart
    Share on Google+

  4. #4
    Join Date
    Jan 2001
    Posts
    18

    Dear Sam,

    Thanks for the update.

    My email id is kssundaralingam@hotmail.com

    Thanks in advance.

    Sundar
    Share on Google+

  5. #5

    Lightbulb Me 2

    Please send a copy to 2hm8zvl3001@sneakemail.com as well.

    Thanks,
    -Jason Martin
    Share on Google+

  6. #6
    Join Date
    Mar 2001
    Posts
    41
    can i have a copy too? my email is hrluna@stsi.com.ph
    thanks in advance....
    Share on Google+

  7. #7
    Join Date
    May 2001
    Posts
    57
    I would also like to be shared with the xl matrix for the sizing info. I have been look to get one of this kind for a long time now. Thanks to ssundar and Jason martin. Please mail it to
    eclipse_black1998@yahoo.com
    Share on Google+

  8. #8
    Join Date
    Jun 2001
    Posts
    28
    send me a copy in
    samahit2000@yahoo.co.in
    Thanks
    Share on Google+

  9. #9
    Join Date
    Nov 2001
    Location
    Bangalore
    Posts
    41
    Instead of asking every one's mail id, why don't you put your mail id on the screen, because most of the people will be interested and who ever they want they will initiate and send a mail to you to which you can reply easily.

    Thanks and don't mind.

    Sanjay
    san
    Share on Google+

  10. #10
    Join Date
    May 2001
    Location
    Dallas, US
    Posts
    78

    copy of the Xls sizing doc

    Hai Sam,
    Can u please send a copy of your sizing doc.
    Thanks in advance.
    palanikumar_r@sakinfotech.co.in

    Regards,
    Palani Kumar. R
    RP Kumar
    You Can Win, if u believe Yourself
    Share on Google+

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