Re: Unix directory 100% full - performance??

Hi,

It ain't necessarily so. When you create a datafile is Unix Oracle writes to every block in the datafile in order to gain control of it. As far as the operating system is concerned the datafile is then 100% full even though it contains no useful data.

So, if your logical volumes are dedicated to Oracle data they should be near or at 100% full.

If a logical volume contains no Oracle data performance will be better if it is less than 100% full, but who much less is related to the volatility of the data files and their anticipated growth. If you are concerned about disk fragmentation of non-Oracle data space impacting performance back up the files, rm the files, and reload them.

Regards

Jerry

Ng TC wrote:
>
> Hi,
>
> I currently have an Oracle DB 7.1.6 on HP-UX B.10.20
>
> I have 2 directories that store my data files, and they are 95% and 100%
> full respectively:
>
> /dev/vg06/lvol1 2456393 2101224 109529 95% /finprod/fm2
> /dev/vg04/lvol1 2857137 2561537 9886 100% /finprod/fm1
>
> I have been told that increasing the disk space so that they are less than
> 85% full will improve the performance of the Application. (The current
> performance is rather slow).
>
> Can someone give me a hint?
>
> Thanks,
> Tse Chong

--

Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_p3.net 	Opinions are mine not those of ICT Group