why JVM is using high CPU utilization on Oracle Server 10.2.0.4
We are getting high CPU utilization with 1 of the JVMs, the highest Top 5 timed waite events
Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
---|---|---|---|---|---|
latch free | 773,818 | 6,944,503 | 8,974 | 58.2 | Other |
i was reviewing the latch free waits possible causes and it could be a cuased by not using bind variables
also any of the high cPU querys is
01mzg0fm7brwx | SELECT /*+ first_rows */ COUNT (1) FROM CMN_SEC_CHK_USER_INST_V0 WHERE USER_ID = :B4 AND OBJECT_ID = :B3 AND PERMISSION_CODE = :B2 AND OBJECT_INSTANCE_ID = :B1 AND ROWNUM = 1 |
Any idea that it could help me to figure out the main issue
0