Home » RDBMS Server » Server Administration » resouce_limit issue (Oracle 9.2.0.8)
resouce_limit issue [message #336162] Fri, 25 July 2008 01:27 Go to next message
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 #336185 is a reply to message #336162] Fri, 25 July 2008 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you do work that needs it.

Regards
Michel
Re: resouce_limit issue [message #336679 is a reply to message #336185] Mon, 28 July 2008 12:09 Go to previous message
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.
Previous Topic: SCN:system change number and alertlogfile
Next Topic: space issue
Goto Forum:
  


Current Time: Tue Dec 06 12:30:45 CST 2016

Total time taken to generate the page: 0.14929 seconds