Home » RDBMS Server » Server Administration » Max process (Oracle 11gr2,Linux 5)
Max process [message #581425] Sat, 06 April 2013 05:47 Go to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Hi,

Currently maximum process is set to 150 in one of the RAC database. What should we do if the current session
is about to reach maximum process or has exceeded the max process.

Thank you

Re: Max process [message #581426 is a reply to message #581425] Sat, 06 April 2013 05:53 Go to previous messageGo to next message
Michel Cadot
Messages: 59968
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Change the parameter value and restart?
Or maybe kill sessions.
What do you expect we tell you?

Regards
Michel

[Updated on: Sat, 06 April 2013 05:53]

Report message to a moderator

Re: Max process [message #581427 is a reply to message #581426] Sat, 06 April 2013 06:48 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Michel ,

Quote:
Change the parameter value and restart?
Or maybe kill sessions.

Thank you for the solution.

Quote:
What do you expect we tell you?

I am junior to Oracle.So request you to be kind to me.

Thank you
Re: Max process [message #581428 is a reply to message #581427] Sat, 06 April 2013 07:29 Go to previous messageGo to next message
Michel Cadot
Messages: 59968
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I advice you to read:
Database Concepts
Database 2 Day DBA
Administrator's Guide
Database SQL Reference
Database Reference

Regards
Michel
Re: Max process [message #581518 is a reply to message #581428] Mon, 08 April 2013 09:01 Go to previous messageGo to next message
suhasdba
Messages: 141
Registered: April 2013
Location: INDIA
Senior Member
Thank you Michel
Re: Max process [message #583786 is a reply to message #581518] Sat, 04 May 2013 00:45 Go to previous messageGo to next message
mmi78
Messages: 30
Registered: April 2013
Location: dhaka
Member
very useful link for newbie
Re: Max process [message #585206 is a reply to message #581425] Thu, 23 May 2013 00:15 Go to previous messageGo to next message
deeplydrink
Messages: 14
Registered: May 2013
Location: Beijing
Junior Member
use the alter command to change the process number in parameter file but indeed, you need to reboot the instance to take it effect
Re: Max process [message #585218 is a reply to message #585206] Thu, 23 May 2013 01:21 Go to previous message
Michel Cadot
Messages: 59968
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is what I said, thanks to confirm... 40 days later. Smile

Regards
Michel

[Updated on: Thu, 23 May 2013 01:21]

Report message to a moderator

Previous Topic: about sga
Next Topic: Database down
Goto Forum:
  


Current Time: Wed Dec 17 19:00:36 CST 2014

Total time taken to generate the page: 0.09524 seconds