Re: Performance tuning for ORACLE applications

In article <C66snA.KMM_at_newsserver.technet.sg> kewta_at_technet.sg writes:

>
>We are using Oracle 7 and had experienced some problems in tuning the
>performance. The analyser is supposed to optimise the performance of the
>applications. However, it only does so for the first few runs; after that the
>performance degrades substantially. It improves again if we run the
>optimiser periodically. I don't think it is supposed to be like that. Did we
>do something wrong? Anyone have any experience with this?
>
>

Don't forget that one of the main things that the analyse statement does is it calculates statistics about your data, for the optimiser to use later.

If your data changes over time, such that the statistics change, then the selected access path may not be optimal.

-- 
tina london