:confused: Hi everyone. After installing Service Pack 15-16-17-18 on BaaN IV c4, huge performance problem during approx 30' every day roughly at the same time. Probably someone running a session with a weird behavior since SPs. Any idea how to find out what's causing the problem ?

Thank you

If it's more or less at the same time, probably it is coming from a job?
So basically you need is to monitor Baan user sessions for a certain period of time.
1. Or you turn user history on and check the history log file - not a good choice.
2. Or (my prefered way at least) to build a UNIX shell script around bshcmd to check for each Baan user logged in what sessions he is running and log the output (and run in a loop or thru cron during the time you want to analyse). If this is your option then follow up on this thread (http://www.baanboard.com/baanboard/showthread.php?t=12125&highlight=bshcmd).

After some session(s) are identified as possible culprits, you can run them with tracing (search the threads for DBSLOG or read that thread mentioned asstarting point and search on the bschmd parameters) to see if they are causing the problem and why.

If you are using Oracle 9, try adding the following line to the $BSE/lib/defaults/db_resource file. Assuming you named it db_resource. It dramatically improved performance for us.

ansi_outer_join:1