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@gmail.com> wrote:

GreetingsSorry 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 FilesystemThis detail comes from df -k output and or from tablespace free outputI know the following values for a given FS either from df -k or from tablespace calcualtion:Allocated GBUsed GBFree 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

------=_Part_3602_4260564.1193172885568-- -- http://www.freelists.org/webpage/oracle-l