I have a very bad performance on session tisfc1101m000 "Maintain Production Planning".

I use BaanIVc4 Supply Chain and the tisfc010 is a Oracle 7.3 table

Regards
Paiva Barbosa

Hi,

You need to close the SFC orders regularly which deletes data from main table tisfc010.

Further if u can upgrade the oracle to 8.0 and porting set 6.1c.05.02 (we are working on this) , the problem may not come.

Is this specific to tisfc1101m000 only . Then installing latest patch/SP for this solution may be a good idea.

BTW How many records are there in tisfc010.

Originally posted by Hitesh Shah
Hi,

You need to close the SFC orders regularly which deletes data from main table tisfc010.

Further if u can upgrade the oracle to 8.0 and porting set 6.1c.05.02 (we are working on this) , the problem may not come.

Is this specific to tisfc1101m000 only . Then installing latest patch/SP for this solution may be a good idea.

BTW How many records are there in tisfc010.

They have 7878 records.... is a small table.....

Try a trace with TT_SQL_TRACE=0200 to check if the session uses bad sql statements. This trace will give you the answer for that.

After this you probably have a hint where to look for.

Han

What is your patch level? Install latest solution 126049 first, so you can have a defect created if the problem still exists.