Home » RDBMS Server » Performance Tuning » creating user / roles with maximum CPU percentage
creating user / roles with maximum CPU percentage [message #65672] Mon, 29 November 2004 02:30
Uwe
Messages: 260
Registered: February 2003
Location: Z├╝rich, Switzerland
Senior Member
Hi all,

we do need to set up readable and writeable users in our Oracle 9.2.0.4 which only get a percentage on CPU combined. We do not know how many of them work at the same time, but the Performance this sessions / users should take together should not be above 10 % of the DB-Performance.

During Oracle Admin Course I got the nformation how to give a role milliseconds in SHM, but we do need to grant them a combined performance.

Oracle said that there is a way, but it's part of Performance-Tuning.

Do anyone has a user / role which wil have this feature activated ?

Thanks in advance

Uwe
Previous Topic: keep and recycle pools in oracle 9i
Next Topic: SQL Tuning
Goto Forum:
  


Current Time: Tue Sep 29 11:55:10 CDT 2020