Concurrent Manager slowness and causing heavy load on the CPU
I am seeing the following error message almost for all nodes in Internal Manager logfile but managers are up and running.
Internal Concurrent Manager found node ???? to be down. Adding it to the list of unavailable nodes.
I also noticed the below 3 queries (seems to be Standard Oracle code) were identified as part of the slowness
causing heavy load on the CPU.
They have millions of executions in 2 hours.
Elapsed Elapsed Time
Time (s) Executions per Exec (s) %Total %CPU %IO SQL Id
---------------- -------------- ------------- ------ ------ ------ -------------
27,567.2 19,227,143 0.00 9.1 21.4 .1 d80rxgb8pyuc6
SELECT R.Conc_Login_Id, R.Request_Id, R.Phase_Code, R.Status_Code, P.Application