Message-ID: <F001.0051BE6B.20021217131237@fatcity.com>
Date: Tue, 17 Dec 2002 13:12:37 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: =?iso-8859-1?q?Stephane=20Paquette?= <stephane_paquette@yahoo.com>
Subject: RE: Capacity Planning -- Expecting the DB growth !!!
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

There is not really capacity planning here.  I'm
starting a new job as a permanent employee and since
my first project is quite small, I've started writing
a capacity planning guide hoping the other groups will
collaborate.

One thing we do is to run statspack each hour on all
production databases and we generate "nice" graphics
from statspack data so we can explain pas behavior and
extrapolate for the futur.

When planning size, try to accomodate for 1 year.


 --- "Reddy, Madhusudana"
<Madhusudana.Reddy@bestbuy.com> a écrit : > Hello All,
> 
> It should include all as you said , but since I do
> not belong to a capacity
> planning group in my shop , I mostly concentrate on
> the DB growth . I have
> taken Sales as business object to correlate with the
> DB size . I think in
> our case both of them are directly proportional. (
> Business objects may vary
> from shop to shop )
> 
> first step I have done is calculating the : Growth
> factor = avg. History Db
> growth / avg Hist Sales growth
> 
> Second Step : identifying the Sales projection for
> the next fiscal year (
> Ie. I have to get sales growth percentage from the
> business team , for
> example 15% and multiply with sales history, for
> each week I guess.)
> 
> 3rd step: Now I have sales projection and growth
> Factor , and can the
> projected DB growth .
> 
> 
> Well The above is the thing I am working on by
> having some queries to get
> the data from the DB. Also I have to automate the
> whole process .
> 
> I would like to know how this Capacity planning
> followed in your shop.
> What's your answer when your group manager asks how
> much disk we need for
> holiday prep ?? Like this we can have many
> questions. I know somebody is
> having a better approach getting followed . Would
> appreciate if you share
> with us.
> 
> or somebody can better help me in """identifying """
> the Q? from managers
> !!!!
> 
> Thank YOU all for your replies
> Madhu
> 
> 
> -----Original Message-----
> Sent: Tuesday, December 17, 2002 12:19 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Check the link Kirti has posted (orapub).
> 
> Is capacity planning only on the database size ?
> In my mind it also includes :
>    Transaction description (online and batch)
>    Transaction frequency (online and batch)
>    Transaction window 
>    Networking requirements
>    Number of users (all and concurrent)
>    Overall disk space (inside and outside the
> database)
>    Availability
> 
> 
> 
> 
> 
>  --- "Reddy, Madhusudana"
> <Madhusudana.Reddy@bestbuy.com> a écrit : > Hello
> All,
> > 
> > I am currently working on capacity planning of the
> > database , expecting the
> > database size based on the business object ,sales
> (
> > Historical data). I am
> > not sure about the approach I am following . I
> > believe there might be some
> > better approach followed in some shop to estimate
> > the DB size , even by
> > considering events like "thanks giving" , "holiday
> > season" and all. 
> > 
> > Also I have to automate this process. Would like
> to
> > know some best
> > suggestions you always have  in this forum. Would
> > you help me in identifying
> > some formulae. Any kind of documentation will be a
> > great help !!!
> > 
> > Thanks in advance,
> > 
> > Madhu
> > 
> >  
> > 
> > 
> 
> > ATTACHMENT part 2 image/gif name=Blank Bkgrd.gif
>  
> 
> =====
> Stéphane Paquette
> DBA Oracle et DB2, consultant entrepôt de données
> Oracle and DB2 DBA, datawarehouse consultant
> stephane_paquette@yahoo.com
> 
>
__________________________________________________________
> Lèche-vitrine ou lèche-écran ?
> magasinage.yahoo.ca
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Stephane=20Paquette?=
>   INET: stephane_paquette@yahoo.com
> 
> Fat City Network Services    -- 858-538-5051
> http://www.fatcity.com
> San Diego, California        -- Mailing list and web
> hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: Reddy, Madhusudana
>   INET: Madhusudana.Reddy@bestbuy.com
> 
> Fat City Network Services    -- 858-538-5051
> http://www.fatcity.com
> San Diego, California        -- Mailing list and web
> hosting services
>
---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru@fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from).  You may
> also send the HELP command for other information
> (like subscribing).
>  

=====
Stéphane Paquette
DBA Oracle et DB2, consultant entrepôt de données
Oracle and DB2 DBA, datawarehouse consultant
stephane_paquette@yahoo.com

__________________________________________________________
Lèche-vitrine ou lèche-écran ?
magasinage.yahoo.ca
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Stephane=20Paquette?=
  INET: stephane_paquette@yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).