FAQ
Does anyone have a spreadsheet/calculation for calculateing how much
space is required for database tables/indexes based up table size/no of
rows etc?



John

Search Discussions

  • Jared Still at Oct 18, 2007 at 6:51 pm
    The way disk is sold these days I would not worry about it too much.

    Buy the number of spindles you need to satisfy IO's per second requirements,
    and
    you are sure to have much more disk than needed.

    If you plan according to size, 2 1 Terabyte disks in a RAID 1 will probably
    do it.
    Performance will suffer accordingly.

    Jared
    On 10/16/07, John Dunn wrote:

    Does anyone have a spreadsheet/calculation for calculateing how much
    space is required for database tables/indexes based up table size/no of rows
    etc?


    John
    --
    Jared Still
    Certifiable Oracle DBA and Part Time Perl Evangelist

    --
    http://www.freelists.org/webpage/oracle-l
  • Dennis Williams at Oct 18, 2007 at 8:30 pm
    John,

    Agree with Jared. If you have a really large database, you need to get some
    sample rows populated before you can start getting reliable estimates.

    Dennis Williams
  • Andrew Kerber at Oct 18, 2007 at 8:44 pm
    Even then you have to remember requirements change. Its not at all unusual
    for the later data to be not very similar to the initial load....

    I have sometimes thought that reliable size estimates are as rare as
    unicorns...
    On 10/18/07, Dennis Williams wrote:

    John,

    Agree with Jared. If you have a really large database, you need to get
    some sample rows populated before you can start getting reliable estimates.

    Dennis Williams

    --
    Andrew W. Kerber

    'If at first you dont succeed, dont take up skydiving.'

    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 16, '07 at 3:27p
activeOct 18, '07 at 8:44p
posts4
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase