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?
Asked by Mohsen
(103 rep)
Aug 17, 2013, 06:50 AM
Last activity: Mar 29, 2024, 07:02 AM
Last activity: Mar 29, 2024, 07:02 AM