Hi,
just a long shot in the dark: I would check if THP are correctly disabled.
Regards
Dimitre
On Apr 12, 2016, 19:41, at 19:41, Stefan Koehler <contact@xxxxxxxx> wrote:
Hi Jeff,
unfortunately the graphic is very small, so my reply is based on what i
can see and what you described.
At first CPU Wait is the OS CPU run queue time. For more details you
can check out Craig's blog post with an experiment about it:
http://blog.orapub.com/20150210/What-Is-Light-Green-Oracle-Database-CPU-Wait-Time.html
… so basically you have to look at the OS CPU run queue, if you want to
find out the root cause. Secondly it seems like you have overloaded
your CPUs.
400 (possible) active sessions (on CPU) would need round about 40 cores
based on the Oracle RWP guideline of max 10 sessions per core (for a
well
behaved applications). I can see that your CPU core is very low, but
can not figure out the exact value as graphic is so small.
Checking the OS CPU run queue details depends on your OS.
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Jeff Chirco <backseatdba@xxxxxxxxx> hat am 12. April 2016 um 19:16geschrieben:
Every so often it will see this large spike and I am not sure how to
Looking for some help on how to troubleshoot this spike in CPU Wait.
find out
what it is related to or why it is happening. It spike up to 400active sessions when normally we only around 2 - 5. When I click on the
graph to
drill in it only show the CPU usage and nothing near 400 activesessions. What else do I need to look out to figure this out. Thanks
in advanced.
--
[Inline image 1]
Jeff
//www.freelists.org/webpage/oracle-l