Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Math Question - with Respect to filesystem Allocatations

Re: Math Question - with Respect to filesystem Allocatations

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Tue, 23 Oct 2007 16:54:45 -0400
Message-ID: <74f79c6b0710231354w755f136ew596cbe3e6f789339@mail.gmail.com>


BN,

f=free space
a=allocated space
x=how much space you need to add

You want (x+f)/(x+a)=0.4

=> x+f=0.4(x+a)
=> x+f=0.4x+0.4a
=> 0.6x=0.4a-f
=> x=(0.4a-f)/0.6

E.g. If your fs is 200mb and you have 50mb free x=((0.4*200)-50)/0.6=50MB

Finn

On 10/22/07, BN <bnsarma_at_gmail.com> wrote:
>
> Greetings
>
> Sorry if this is way off this List:
>
> Working on Storage for Databases,
>
> The Goal is : how much space should we have to add to make %free 40% for
> a given Filesystem
>
> This detail comes from df -k output and or from tablespace free output
>
> I know the following values for a given FS either from df -k or from
> tablespace calcualtion:
>
> Allocated GB
> Used GB
> Free GB
> %USed
> %Free
>
> (even though %used and %free values never add for a df -k output)
>
> I need a formula to come up with a new Allocation size if %free is at
> 40% (which means %used will be at 60%)
>
> Brain is not thinking stright, appreciate your feedback (My math is not
> adding up to the xl I have been sent for the new storage required to set all
> FS at 40% Free)
>
> --
> Regards & Thanks
> BN
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 23 2007 - 15:54:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US