Hi All,
I have got an issue which says that session performance is very unpredictable like sometimes It works fine and sometimes It takes a huge time may be whole one day.
It says that updates are done to the early in the processing, but the Oracle cycles continue for a long time after the updates are complete.
So can you please suggest me how to go ahead for analyzing such issue and If you could share some document to analyze such performance related issue then that would be very much helpful to me.
[Session is customized one but uses only standard functions and dlls]....
Sytem details are as follows:
BaaN IV C4
Unix
Oracle

Thanks & Regards,
Anubhav Bansal

Here is a starting point - see this post (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=7665). You can probably find other threads by searching the board referencing "performance" or tuning.