| resouce_limit issue [message #336162] |
Fri, 25 July 2008 01:27  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
