How to size database ( Excel File Included)
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 33

Thread: How to size database ( Excel File Included)

  1. #1
    Join Date
    Jun 2001
    Posts
    3

    Angry

    How to find out the size of the datafile for a database consist of three tables with following specs:
    1 year growth 5 Year growth
    Table 1 400,000 record/year, 1 million record/5 year
    Table 2 100, 000 record/year, 250, 000 records/5 year
    Table 3 45/year, 60/5 year

    Table1: Average Record length: 80
    Table 2: Average Record length 100
    Table3: Average Record length 35

    I really need to understand this concept. Also I would like to understand the magic about min. extent, maxextents....

    in short storage clause for the tables.

    Thanks!!!

    I really need help.

    Thanks again!!!!
    Share on Google+

  2. #2
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131

    Thumbs up

    hi pandyar

    It is difficult to measure the exact size of the datafile for the period of time.

    We can calculate approx. datafile size by taking average record length multiply by average no.of records plus add 30% additional size for the particular table. Like wise we can proceed for other tables in the tablespace for the datafile.

    regards

    Anandharaj
    Share on Google+

  3. #3
    Join Date
    Apr 2001
    Posts
    107
    Hi,

    I've got a "magic" excell sheet that could help you in calculating the approximative size of tables (and indexes).
    I could send it tou you if you indicate me your e-mail.

    Bye

    Fabien
    Share on Google+

  4. #4
    Join Date
    Apr 2001
    Posts
    107
    Hi, friends

    I'll send the excell sheet and an explanation on how to use it by tomorrow, as I waited for a max. number of people to answer, but I am now in a hurry, (sorry for this!)
    Padman, thanks for your useful help in any time, and keep going!


    Fabien
    Share on Google+

  5. #5
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    Could I also get a copy of Execl Sheet? my email is youngz99@hotmail.com
    Thanks.

    Dragon
    Share on Google+

  6. #6
    Join Date
    Nov 2000
    Posts
    416
    Also please add my email adress to your sending list : mostadam_oracle@yahoo.ca
    An ounce of prevention is worth a pound of cure
    Share on Google+

  7. #7
    Join Date
    Nov 2000
    Posts
    245

    please & thanks


    Can you pls send me the excell sheet on my email id rainingday32@hotmail.com

    thanks again

    jm

    Share on Google+

  8. #8
    Join Date
    Nov 2000
    Posts
    162
    Fabien, I am interested in your magic excell spreadsheet too.
    Can you please forward me a copy to wujee@yaoo.com.

    Thanks,
    Unna
    Share on Google+

  9. #9
    Join Date
    Feb 2001
    Location
    Atlanta, USA
    Posts
    131
    Hello Fabien,

    I am interested in your magic Excell sheet also. Could you send a copy to

    ashwin32@123india.com

    Thanks in advance.

    anand
    Share on Google+

  10. #10
    Join Date
    Jun 2001
    Location
    London
    Posts
    4
    hi fabien

    i am interested in ur magic sheet do please send it to my mail id:sravu_m@hotmail.com

    Thanks in advance

    skmadhava
    sravu
    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