Home » RDBMS Server » Server Administration » resource_limit problem (oracle 10g,windows 2003)
resource_limit problem [message #408026] Sat, 13 June 2009 01:14 Go to next message
shajat
Messages: 25
Registered: October 2008
Location: INDIA
Junior Member
pl find my attached text file.

When CURRENT_UTILIZATION of PROCESSES is reached to 148 or more, I am getting the error.

Users which have connected already are running with no problem, but when users try to connect, getting error.

Pl help me,how to solve this problem.

Thanks in advance.
  • Attachment: resource.txt
    (Size: 0.31KB, Downloaded 159 times)
Re: resource_limit problem [message #408027 is a reply to message #408026] Sat, 13 June 2009 01:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
When CURRENT_UTILIZATION of PROCESSES is reached to 148 or more, I am getting the error.

Do we have to guess which one?

Your limit is 150, you have to count with Oracle system processes. Increase the value.

Regards
Michel
Re: resource_limit problem [message #408048 is a reply to message #408026] Sat, 13 June 2009 05:56 Go to previous messageGo to next message
shajat
Messages: 25
Registered: October 2008
Location: INDIA
Junior Member
Thanks for your reply.....

When Current_utilization is reached to 148, error is coming.

Then, how to increase the processes limit.

Re: resource_limit problem [message #408088 is a reply to message #408048] Sat, 13 June 2009 13:35 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
When Current_utilization is reached to 148, error is coming.

Once again which one?

Quote:
Then, how to increase the processes limit.

Increase PROCESSES parameter value.

Regards
Michel
Previous Topic: Oracle Patchset 10gR2 10.2.0.3
Next Topic: Rc-50004 error when executing adcfgclone.pl
Goto Forum:
  


Current Time: Fri Dec 09 21:04:53 CST 2016

Total time taken to generate the page: 0.04869 seconds