How to size database ( Excel File Included) - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 4 FirstFirst 1234 LastLast
Results 11 to 20 of 33

Thread: How to size database ( Excel File Included)

  1. #11
    Join Date
    Apr 2001
    Posts
    45
    Seems like you have been sitting on a gold mine.


    Could the moderator please put this in the dbasupport.com's technical docs/tools utilities part of the site. That way we all can download it when we want and we could be sparred from being spammed with all the exposed e-mail addresses.
    Share on Google+

  2. #12
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Fabin,

    If you are very much intersted in helping the folks, could you please send the script to uday the super moderator.

    Thank you for your entusiastic participation. Keep going.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Share on Google+

  3. #13
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    There was no magic sheet on capacity planning as you believed. It is an estimation.
    Capacity planning will only work for approximately 60%. Each table in the database requires different type of storage clause. Last week I was testing a table's storage space by changing different value for INITRAN parameter. I was surprised by the outcome. The rest of storage clause parameters are not changed. Number of rows inserted is 10000. Data block size 8K.
    Case 1.
    INITRAN 1
    Number of blocks used for 10000 rows - 155
    Case 2
    INITRAN 5
    Number of blocks used for 10000 rows - 165
    Case 3
    INITRAN 10
    Number of blocks used for 10000 rows - 175
    In every case the same data was inserted in the table. But I got different results just by changing only one parameter.
    Then you can imagine by changing PCTFREE, PCTUSED etc values, how the storage space is going to be.

    Today, hardware price is cheap. I can buy 60 GB disk for the price of 6 GB Disk what I paid 3 years ago.
    DO NOT WASTE MUCH TIME ON CAPACITY PLANNING.
    Share on Google+

  4. #14
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Good Explanation Tamilselvan

    Dear Tamilselvan, 8th June 2001 22:01 hrs chennai

    Good explanation.If you would have told this before like sambavan said

    ---------
    Waaw,

    The wand is buring hot

    would not have happened(sambavan you are really a jovial person making us to refresh at times we all are deep into logical world. )
    ---------

    But more than that i am hapy to see the active participation of many competeting to share and Gain Knowledge thats invaluable.

    Cheers

    Padmam


    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
    Share on Google+

  5. #15
    Join Date
    Apr 2001
    Posts
    45
    Tamilselvan,

    Shouldn't your findings be of concern to those who deal in 10**6 records ?
    I think this directly affects segment growth rates which in turn determines the backup and recovery and segment management (like index rebuilds etc...) techniques implemented by the DBA.
    So any space management techniques that can be exploited in the physical d/b design should be thoroughly researched, and your findings are a perfect example of that.

    It would be interesting for someone with the tools and detemination (may be it already exists) to generate excel graphs that would display the relation ship of the # of rows,block size, pctfree, pctused, initran, etc.. (other segment size parameters) on segment growth.

    Am I thinking correct here ? I am new to d/b management so this kind of information goes a long way.
    Share on Google+

  6. #16
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Always use Average Row Size obtained from DBA_TABLES or used blocks to figure out the table size.
    In a transaction environment, each row size in a transaction table differs from other. As I said earlier there is no way you can calculate the exact space requirement for a table. It is only approximation.

    My point is simple. Hard disk's price is cheaper. Only you need to ensure that your box has more room for adding more disks.
    Share on Google+

  7. #17
    Join Date
    Jun 2001
    Posts
    33

    magic excel sheet

    Hi Fabien,

    I am also interested in your magic excell spreadsheet.
    Can you please forward me a copy to :
    basam_oracle@yahoo.com

    Thanks
    nath

    Share on Google+

  8. #18
    Join Date
    May 2001
    Posts
    49
    Hi,
    Could you please send me a "magic" excell sheet that could help me in calculating the approximative size of tables (and indexes).
    My e-mail address: rekha20@usa.net

    Thanks
    Rekha
    Share on Google+

  9. #19
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    Hi!all
    Do we have the "magic Sheet" here in the dba forum. Instead of poor fabien mailing it to everybody it would be better to have it somewhere in oracle Scripts.
    Hope Fabien wont mind to share.
    There Nothing You cannot Do, The problem is HOW.
    Share on Google+

  10. #20
    Join Date
    Apr 2001
    Posts
    2

    Smile database size

    Hi Fabien,
    Could u plz send me that excel sheet . My email address is maheshkumarv@yahoo.com.
    Thanks
    Mahesh
    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