Hello, May any of you advice, in oracle DB/Linux, what is the easy way to identify if oracle DB is a victim of CPU degradation of host or the query is the cause of CPU degradation.
we observed that the same query connects and runs all the time, but intermittently from the top activity, active sessions rise up 300 times with CPU wait.
hope you can advice