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@xxxxxxxxxx <mailto:dherri@xxxxxxxxxx> > ------------------------------------- ________________________________ From: LiShan Cheng [mailto:exriscer@xxxxxxxxx] 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@xxxxxxxxxx> 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@xxxxxxxxxx <mailto:dherri@xxxxxxxxxx> > ------------------------------------- ________________________________ ************************************************************************* 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. *************************************************************************