DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Capacity planning - Responses Highly Appreciated.

  1. #1
    Join Date
    Mar 2003
    Posts
    8

    Capacity planning - Responses Highly Appreciated.

    Hello,

    We are trying to do Capacity planning for our oracle 9i database,
    But we have no budget to buy tools like Enterprise Manager's Capacity
    Planning pack etc.
    Please does anyone have something like a home grown tool that
    could be used for this purpose. Ideally I will appreciate a tool that
    can capture
    1. Growth in tablespaces
    2. Growth in key tables
    and be able to display that over time, at least historically and (ideally) as a forward projection.
    Best option will be a tool that can captured data regularly and somehow be able to graph it.

    If the above tool is not available.

    A SQL code, procedure etc that can capture the above information (capacity planning info)
    and store it in a table in the database will be equally appreciated.

    Thanks
    Phraim

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    No estimation would give you a correct picture.
    Today the disk price is cheap.
    Do not waste your time on doing capacity planning.

    Tamil

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I too think you are better off buying disk rather than some software for this. However, you do need to get some kind of handle on growth - the scripts section of this site might help (e.g. I saw this http://www.dbasupport.com/oracle/scr...iled/130.shtml which might give you a kick-start - I've never used it though).
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  4. #4
    Join Date
    Mar 2003
    Posts
    8
    Thanks Tamil and Dapi for your response to my question.
    Your responses were very helpful.

    Thanks again,
    IPhraim

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