How to restrain Oracle Database to use 100% cpu
Hi
I have a server with several databases on it ..
At some point one of the databases is heavily loaded and utilizes 100% of the cpu .. thus preventing the others to work at all.. is there a way to restrain that particular database to use 75% of the CPUs .. I was thinking of the resource manager but if I understood incorrectly it only applies for if there is a shortage between the sessions within the database
Any idea?
Thanks in advance