I would suggest to do execute top command to check the top CPU intensive processes. Then check if it's oracle process. If oracle drill down what query is that, then you may use the Parallel hint. If it's not Oracle process not much you can do, may raise SR.




Reply With Quote