Performance - EBS (MOSC)

MOSC Banner

many inserts in FND_CRM_HISTORY

in Performance - EBS (MOSC) 3 commentsAnswered ✓

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center