ICM consume most of the CPU (FND_GLOBAL)
Hello All,
I found below query from ICM was TOP CPU query from the AWR Report. Is it normal or something that we can tune? thank you.
CPU CPU per Elapsed
Time (s) Executions Exec (s) %Total Time (s) %CPU %IO SQL Id
---------- ------------ ---------- ------ ---------- ------ ------ -------------
7,015.7 194,164 0.04 9.2 27,978.5 25.1 .0 3rwmntrn04p4f
Module: ICM@hostname(TNS V1-V3)
begin fnd_global.bless_next_init('FND_PERMIT_0000'); fnd_global.initialize(:sess
ion_id, :user_id, :resp_id, :resp_appl_id, :security_group_id, :site_id, :login_
id, :conc_login_id, :prog_appl_id, :conc_program_id, :conc_request_id, :conc_pri