Oracle Resource Manager
I am looking to use Oracle resource manager on a Database instance I have setup and have been reading the various bits of documentation I have found but have not been able to answer a scenario I have thought of. I have been wondering how the ORM would deal with O/S processes taking up significant CPU outside of Oracle. For example if the CPU usage hits 100% with Oracle using 70% of the CPU and a couple of processes outside of oracle taking up 30% of CPU. How would ORM then split up the 70% available to Oracle?
Would the CPU be split up against all the resource plans via percentages of the total available cpu to oracle or will it just allow cpu usage up to the resources allocation based on a first come first served basis? Meaning some resource groups not have the full allocation for there group available to them.