parameters needed for sizing the database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: parameters needed for sizing the database

  1. #1
    Join Date
    Sep 2001
    Location
    chennai
    Posts
    69

    parameters needed for sizing the database

    Hello
    I want to know the various parameters that has to be considered and the ideal parameter values to arrive at a proper sizing estimation of a database.

    can you help me.

    thanks in advance

    rswamin

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    You'll never know for sure until you have built the database and loaded it.

    For an OLTP system, i would guesstimate somewhere between 2 and 4x the raw data volume

    For a DW/DSS system, probably 1.5x to 2x the raw data volume.

    I'm sure others have their own rules-of-thumb.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Dec 2000
    Location
    Mumbai
    Posts
    38
    Sizing of the Database:

    Consider this facts:

    1. Hardware Resources like RAID,Disk space,cpu's,RAM,Networking.
    2. Kind of setup opting for ( oltp or batch processing ).
    3. Estimate the growth of the database for a peroid of time by
    the inputs given by application users.
    4. Design the database as per the OFA model.

  4. #4
    Join Date
    Jun 2000
    Posts
    295
    Think it this way:
    If there is a set of ideal parameter value for
    all databases, Oracle will/should provide it.

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    we're not talking about init parameters i think. we're talking about db sizing.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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