Re: Capacity Planning
- From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- To: "Mladen Gogala" <gogala@xxxxxxxxxxxxx>
- Date: Thu, 23 Feb 2006 09:13:00 -0500
While I agree that capacity planning is prediciting future and as such it
has has little value, still having some number is better than having no
number at all.
For new applications, disk usage, you can estimate/simulate/measure number
of rows inserted per table, then multiply by corresponding rows size + add
overhead. That's the old way.
Or do the simulation, then project.
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
>
>
--
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
Other related posts:
