Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Math Question - with Respect to filesystem Allocatations
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-lReceived on Tue Oct 23 2007 - 15:54:45 CDT