| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Capacity Planning
Got it! I'm a little OEM CP-focused right now due to management of an
existing system.
As for initial CP, our company has done its best to use past experiences across many, many installs to help predict new installs needs. Our CP has to make many assumptions, as almost all installs for us are DWs. Normally we have a few 3rd party tools such as Cognos, Affinium, SAS, a known list of "power" users and "light" users, estimated logical row counts from the data (x number of customers, x number of accounts), refresh frequency, etc. As others have mentioned, you end up with a guess that's +- 50%. It actually might work better if initial plans matched in any way what gets delivered!
Wish I could offer more help!
Dave
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com <mailto:dherri_at_acxiom.com> >
From: LiShan Cheng [mailto:exriscer_at_gmail.com]
Sent: Thursday, February 23, 2006 9:06 AM
To: Herring Dave - dherri
Cc: Mladen Gogala; Ranko Mosic; oracle-l
Subject: 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 <mailto:dherri_at_acxiom.com> >
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-lReceived on Thu Feb 23 2006 - 09:15:29 CST
 |
 |