SQL Performance (MOSC)

MOSC Banner

How to reduce "CPU + Wait for CPU" or "CPU + CPU wait"

edited Aug 3, 2016 11:41AM in SQL Performance (MOSC) 6 commentsAnswered ✓

lately i have been seeing a lot of "CPU + Wait for CPU" as a wait in the sql performance issues i am handling....i see that even though CPU is only 50% utilized the wait event is still seen.

what is it exactly and is there a way to reduce this wait ...

Elapsed time of a sql= DB time of the sql(CPU + non-idle wait event) + CPU runqueue time

i see lot of time spending in "CPU runqueue time"....Please advice.

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