Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Capacity Planning

RE: Capacity Planning

From: John Kanagaraj <>
Date: Thu, 23 Feb 2006 09:14:35 -0800
Message-ID: <>

Why not have a browse at OraPub ( ? 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  

From: [] On Behalf Of Herring Dave - dherri Sent: Thursday, February 23, 2006 7:01 AM To:; 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 Herring, DBA

Acxiom Corporation

3333 Finley

Downers Grove, IL 60515

wk: 630.944.4762

< <> >

From: [] 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.


LSC On 2/23/06, Mladen Gogala <> 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


The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally

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.

Received on Thu Feb 23 2006 - 11:14:35 CST

Original text of this message