RE: Help with Storage Capacity

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 19 Apr 2012 13:13:49 -0400
Message-ID: <099601cd1e4f$ca6e2c40$5f4a84c0$_at_rsiz.com>



This response and Hans' response earlier are both good. Also remember to ensure there is enough I/O capacity in the growth plan. In particular, when left in the hands of storage administrators unfamiliar with your needs, they *may* address your storage growth by moving you onto a smaller number of much larger disks. Your storage below could easily fit on a single disk at today's sizes.

It is also worthwhile considering the growth quanta that is easiest to incorporate in a running system. Often that is a full new tray in a SAN, for example.

Regards,

mwf

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Iotzov, Iordan
Sent: Thursday, April 19, 2012 12:02 PM
To: mdinh_at_XIFIN.Com; oracle-l_at_freelists.org Subject: RE: Help with Storage Capacity

Michael,

        Someone would need to do disk usage forecasting based on historical data. The request for adding/dropping disk space should be based on the results of the above mentioned forecast in conjunction with the estimate of how much disk space would be needed to accommodate "non-typical" future usage. The person in charge should be actively involved with the business to figure out those "non-typical" changes (things like rapid product/geographic expansion, exit from markets, etc) - no formula or process would be able to get that information for him/her.

        I personally use simple linear regression for forecasting, but I am sure there are many other good methods. If you use Oracle Enterprise Manager (OEM), you can check my presentation
-http://iiotzov.files.wordpress.com/2011/08/iotzov_oem_repository.pdf to see
how I do it. Please note that you can use those techniques to forecast file system sizes as well.

Iordan Iotzov
http://iiotzov.wordpress.com/

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Dinh
Sent: Thursday, April 19, 2012 11:18 AM
To: oracle-l_at_freelists.org
Subject: Help with Storage Capacity

We have a database server with one of the largest and fastest growing customer.
Here is the current size of the database server.

What process do you have to decide when to add more storage? Do you have to request for more storage or does the sysadmin monitors the server and add accordingly?

I am trying to understand what processes are out there. Thanks.

Wed Apr 18 16:15:01 PDT 2012

Filesystem             size   used  avail capacity  Mounted on
/                      998G   818G   178G    83%    /

Michael Dinh

--

http://www.freelists.org/webpage/oracle-l

This message and its attachments may contain legally privileged or confidential information. It is intended solely for the named addressee. If you are not the addressee indicated in this message (or responsible for delivery of the message to the addressee), you may not copy or deliver this message or its attachments to anyone. Rather, you should permanently delete this message and its attachments and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of News America Incorporated or its subsidiaries must be taken not to have been sent or endorsed by any of them. No warranty is made that the e-mail or attachment(s) are free from computer virus or other defect.
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 19 2012 - 12:13:49 CDT

Original text of this message