Long running of the FS_JGEN process for the AR & BI subsystem
We are experiencing an issue of long running of the FS_JGEN process for the AR & BI subsystem. We check the trace file, we found that there are couple of statement update and select statement were taking long time. Each of this sql involved the view table PS_ITEM_DST_CC_VW. We check the explain plan for the sql, it seem fine.
Any suggestion??
Any suggestion??
1