Database Tuning (MOSC)

MOSC Banner

why JVM is using high CPU utilization on Oracle Server 10.2.0.4

edited Feb 7, 2011 3:27AM in Database Tuning (MOSC) 2 commentsAnswered
  We are getting high CPU utilization with 1 of the JVMs, the highest Top 5 timed waite events

EventWaitsTime(s)Avg Wait(ms)% Total Call TimeWait Class
latch free773,8186,944,5038,97458.2Other

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

01mzg0fm7brwxSELECT /*+ 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

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center