Re: Capacity Planning

No, nothing wrong with OEM.

I was really asking how can a DBA predict the hardware requirement such as CPU, Memory for a new application.

Cheers

LSC On 2/23/06, Herring Dave - dherri <Dave.Herring_at_acxiom.com> wrote:
>
> What's wrong with good ol' OEM's Capacity Planner? I found it works
> great for tracking I/O, CPU, storage (at any level), and memory usage for
> any system. You can even create your own queries in case you want info
> broken up in a different way, such as storage being allocated into logical
> areas. CP roles up the information by hour, day, week, month, and year,
> easily lets you graph data you have (and change criteria and regraph
> quickly), plus estimate for x amount of time in the future based on current
> trends.
>
>
>
> This does nothing for a system yet to be developed, but sure is helpful
> for an existing system, especially since the graphs are the eye candy that
> management responds to, when requesting more hardware.
>
>
>
> Dave
>
> -------------------------------------
>
> Dave Herring, DBA
>
> Acxiom Corporation
>
> 3333 Finley
>
> Downers Grove, IL 60515
>
> wk: 630.944.4762
>
> <mailto:dherri_at_acxiom.com <dherri_at_acxiom.com>>
>
> -------------------------------------
> ------------------------------
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *LiShan Cheng
> *Sent:* Thursday, February 23, 2006 8:02 AM
> *To:* Mladen Gogala
> *Cc:* Ranko Mosic; oracle-l
> *Subject:* Re: Capacity Planning
>
>
>
>
> Thatīs right, it is a Crystall Ball! That is probably why many Capacity
> Plans fails! I guess there is no scientific way to perform capacity
> plannnings, at least not for new applications and without some metrics.
>
> Thanks
>
> LSC
>
> On 2/23/06, *Mladen Gogala* <gogala_at_sbcglobal.net> wrote:
>
>
> On 02/23/2006 08:14:28 AM, LiShan Cheng wrote:
> > Hi Ranko
> >
> > What if the application is new? For example you have to migrate a
> Peoplesoft
> > CRM to Siebel can you take Peoplesoft metrics and use that in Siebel?
> >
> > Or you are putting a new fresh application.
>
> LiShan, capacity plan is a crystal ball usually required by damagement.
> If it is pretty enough and is web based, it doesn't necessarily have to
> have anything in common with reality and accuracy. Capacity plan is like
> light saber model: your can be prettier then mine, but neither will work.
> The answer to the question "how much disk will we be using in 6 months"
> is still: "I have no clue", especially if the application is new to your
> system. Fortunately, there is a great tool called "Oracle Application
> Express"
> which, in combination with good, old DBMS_JOB can do the trick. You can
> schedule monthly space allocation collection and then present a bar graph
> on the intranet. You can even allow the damagement to select a month in
> the future for which it wants to see allocation. It's called "Futurama".
> May the farce be with you.
>
>
> --
> Mladen Gogala
> http://www.mgogala.com
>
>
>
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
> ****************************************************************************
>
>

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