Re: onmode -F

In article <33A665A1.2AB4@west.co.za>, "Mark D. Stock" <marks@west.co.za> writes >Con Woodall wrote: >> > >Yes, you should ONLY be freeing memory segments if you have a memory >problem. Normally you WANT OnLine to use all the memory it requires in >order to maximise performance. Remember that adding a segment is an >overhead in terms of performance, so if OnLine immediately adds the >segments freed by your cron process, you will be impacting on >performance. > Correct - >1 shared memory segment of the Virtual Class means a) SHMVIRTSIZE is too small b) A dynamic hash join is being done when it should not be e.g. OPTCOMPIND needs setting to 0 or an index is missing. >> On Mon, 16 Jun 1997, Zeljan Silje wrote: >> > >> > in "Performance Guide Version 7.2" I found recommandation to run onmode >> > -F using cron facility. >> > Does anyone has experience with this, and how often should I execute >> > onmode -F using cron?>> > I am using Informix OnLine7.22 on AIX4.2. > >Cheers, -- David Williams