Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

It is better to use a profile and cpu_per_session and cpu_per_call or to use oracle resource manager

3310272Feb 4 2019 — edited Feb 13 2019

We want to restrict one user to a limited amount of CPU usage.  I'm researching to see how best to accomplish this.  I've read that oracle resource manager can be used to restrict CPU usage.  We have only one user that needs to be restricted.  The original request is to restrict this one user to not more than 25% of CPU.  Can someone point me in the direction to find information that would help me determine if this can be accomplished via a profile using CPU_PER_SESSION and CPU_PER_CALL or if Oracle Resource Manager is a better choice.  Also, is Oracle Resource Manager included with Oracle Enterprise Database 12C?  Or, is an additional license required?

Comments
Post Details
Added on Feb 4 2019
5 comments
2,381 views