Re: Math Question - with Respect to filesystem Allocatations

Uhmmmmmm.....

No wonder you're confused? A filesystem is a disk space allocation in which (we're talking cooked not raw) datafiles reside. Datafiles belong to tablespaces. A tablespace can have multiple datafiles, not all of which may reside in the same filesystem. Tablespaces don't use disk, datafiles do.

Actually, it's just math (depending on whether you're looking at the current state or need to plan for autoextensible datafiles):

Total Filesystem Size = Current Usage / .6

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