Limiting CPU using Oracle resource manager
** Oracle is investigating this issue, but in parallel is opening the topic to the Community so that Community
members can add their perspective, experience or knowledge. This will further enhance all knowledge bases
including My Oracle Support and My Oracle Support Communities; assisting all Community members and enabling
richer solution searches. **
Hi all,
Extracted the following Example from Oracle9i Database Concepts Release 2 (9.2)
http://download.oracle.com/docs/cd/B10501_01/server.920/a96524/c10rsmgr.htm#CNCPT009
Consumer Group CPU_LEVEL1 CPU_LEVEL2 CPU_LEVEL2
--------------- --------------- -------------- ------------
ONLINE 75% 0% 0
SHIPPING 10% 0% 0%
BILLING 5% 0% 0%
ADMIN 0% 80% 0%
BATCH 0% 20% 0%
* CPU_LEVEL1 now allocates up to 75% of available CPU time to the ONLINE group, while SHIPPING gets 10% and
including My Oracle Support and My Oracle Support Communities; assisting all Community members and enabling
richer solution searches. **
Hi all,
Extracted the following Example from Oracle9i Database Concepts Release 2 (9.2)
http://download.oracle.com/docs/cd/B10501_01/server.920/a96524/c10rsmgr.htm#CNCPT009
Consumer Group CPU_LEVEL1 CPU_LEVEL2 CPU_LEVEL2
--------------- --------------- -------------- ------------
ONLINE 75% 0% 0
SHIPPING 10% 0% 0%
BILLING 5% 0% 0%
ADMIN 0% 80% 0%
BATCH 0% 20% 0%
* CPU_LEVEL1 now allocates up to 75% of available CPU time to the ONLINE group, while SHIPPING gets 10% and
0