Home » RDBMS Server » Server Administration » CPU allocation per user
CPU allocation per user [message #115452] Mon, 11 April 2005 13:37 Go to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
Hi,
Is there a way I can allocate CPU resources per user? I know about cpu_per_session & cpu_per_call, but these both deal with time constraints. Is there anything else?

One of our clients recently ran into an issue with a rogue query that consumed all 4 of the machine's cpu's. To prevent this in the future, we'd like to limit the user's cpu resources. There are 2 instances running on this machine.
If I update the instance with the rogue query to: cpu_count=2, will this cause an issue if the other instance has the value: cpu_count=4?

Thanks!
Re: CPU allocation per user [message #115453 is a reply to message #115452] Mon, 11 April 2005 13:56 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you look into resource manager?
The docs should help
Previous Topic: disconnect users
Next Topic: Droping redolog file?
Goto Forum:
  


Current Time: Fri Sep 27 02:35:06 CDT 2024