RE: Capacity Planning
- From: "John Kanagaraj" <john.kanagaraj@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Feb 2006 09:14:35 -0800
Why not have a browse at OraPub (http://www.orapub.com) ? Craig Shallahammer (a
contemporary of our very own Cary Millsap) is an expert in this area and even
conducts training in this area.
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Co-Author: Oracle Database 10g Insider Solutions
http://www.amazon.com/exec/obidos/tg/detail/-/0672327910/
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Herring Dave - dherri
Sent: Thursday, February 23, 2006 7:01 AM
To: exriscer@xxxxxxxxx; Mladen Gogala
Cc: Ranko Mosic; oracle-l
Subject: RE: Capacity Planning
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@xxxxxxxxxx <mailto:dherri@xxxxxxxxxx> >
-------------------------------------
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxx> 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.
****************************************************************************
Other related posts:
