Return-Path: <root@fatcity.cts.com>
Received: from ensim.rackshack.net (root@localhost)
 by orafaq.net (8.11.6/8.11.6) with ESMTP id gBIIGtk26688
 for <oracle-l@orafaq.net>; Wed, 18 Dec 2002 12:16:55 -0600
X-ClientAddr: 209.68.248.164
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
 by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id gBIIGt326683
 for <oracle-l@orafaq.net>; Wed, 18 Dec 2002 12:16:55 -0600
Received: from fatcity.UUCP (uucp@localhost)
 by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA85644;
 Wed, 18 Dec 2002 06:59:43 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0051CAF2; Wed, 18 Dec 2002 06:44:02 -0800
Message-ID: <F001.0051CAF2.20021218064402@fatcity.com>
Date: Wed, 18 Dec 2002 06:44:02 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: "Hand, Michael T" <HANDM@polaroid.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Hand, Michael T" <HANDM@polaroid.com>
Subject: RE: Capacity Planning -- Expecting the DB growth !!!
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


One thing I don't think I've seen mentioned is the issue of storage
configuration and uptime requirements impact on capacity planning.  Is the
planned system 7x24 or will there be maintenance windows to add storage?
Can storage be added hot or is downtime required.  These issues will require
the fudge factor to be adjusted accordingly.

Mike Hand
Polaroid Corp.


-----Original Message-----
Sent: Tuesday, December 17, 2002 5:01 PM
To: Multiple recipients of list ORACLE-L


One problem I've run into when doing some rudimentary cap planning is that
much of it is directly related to how much business our Sales force predicts
we will generate next year.  I've looked at the growth of our general ledger
tables and our sales order tables and it's mostly driven by the amount of
business we do (we manufacture printing controls).  So, some insight into
the business by Sales or other company execs may help, too.

That, and a fudge factor.  One of our larger audit tables had 300% more rows
in 2000 than in 1999 because of planned inventory moves used in implementing
"lean manufacturing".  No way I could have predicted that one, but a fudge
factor softened the blow a bit.

Just my $.02 (before taxes),
Rich


Rich Jesse                           System/Database Administrator
Rich.Jesse@qtiworld.com              Quad/Tech International, Sussex, WI USA

This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  INET: HANDM@polaroid.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).

