I have an Oracle instance to which several applications from different machines connect (http servers). Normally Oracle CPU usage is ~5-10% even on high server loads. But from time to time, one of http servers impose high (100%) CPU load on Oracle, which causes other oracle clients (in the case other http servers) timeout and do not work properly.

Is it possible to limit CPU usage on a per process or per session basis? Or is it possible to limit CPU usage for clients connected to oracle from a special Machine/IP?

  • 1
    Oracle Resource Manager – Mindaugas Riauba Aug 17 '13 at 6:58
  • 1
    Theoretically you can you resource manager for CPU but it does not have good reputation. The other solution is to reduce the size of the connection pool for application which do not behave good. – ibre5041 Aug 19 '13 at 10:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.