CPU Wait troubleshoot

From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Tue, 12 Apr 2016 10:16:26 -0700
Message-ID: <CAKsxbLqw6AY+mOnDkP1X6GALHk+bpgtfgJed61=TShEniH0JHQ_at_mail.gmail.com>



Looking for some help on how to troubleshoot this spike in CPU Wait. Every so often it will see this large spike and I am not sure how to find out what it is related to or why it is happening. It spike up to 400 active 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 active sessions. What else do I need to look out to figure this out. Thanks in advanced.

[image: Inline image 1]

Jeff



--
http://www.freelists.org/webpage/oracle-l


image.png
Received on Tue Apr 12 2016 - 19:16:26 CEST

Original text of this message