resouce_limit issue [message #336162] |
Fri, 25 July 2008 01:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
udara
Messages: 9 Registered: July 2008 Location: COLOMBO
|
Junior Member |
|
|
now there is error comming "ORA-02392: exceeded session limit on CPU usage"
but i have check in the system.
CPU_PER_SESSION =1000
I know that I have to increase the value of this profile parameter.
But i have not clear why even though high amount like 1000 still asking to increase???
|
|
|
|
Re: resouce_limit issue [message #336679 is a reply to message #336185] |
Mon, 28 July 2008 12:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
sunil_v_mishra
Messages: 506 Registered: March 2005
|
Senior Member |
|
|
ORA-02392: exceeded session limit on CPU usage, you are being logged off
Cause: An attempt was made to exceed the maximum CPU usage allowed by the CPU_PER_SESSION clause of the user profile.
Action: If this happens often, ask the database administrator to increase the CPU_PER_SESSION limit of the user profile.
Fixed CPU utilization can be done by user session & if user session need more CPU utilization than we have to increase the CPU_PER_SESSION limit of the user in profile.
|
|
|