many inserts in FND_CRM_HISTORY
On our 12.1.3 environment we found that there was a very active database process, which is inserting many, many, many records into APPS.FND_CRM_HISTORY
Upon checking that table, it seems like he is calculating a status, and then inseting that result into a table. Seems OK, but the probleem seems to be : he's doing that every 2 seconds.
This is the actual statement that is run by the super active database client process:
Insert into FND_CRM_HISTORY (requests_examined, requests_standby, requests_released, requests_returned, work_start, work_end)
(Select :exmd, :stby, :rels, :retd, Decode(Work_Start,NULL, Sysdate, Work_Start), Decode(Work_End,NULL, Sysdate, Work_End)