OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Max process (Oracle 11gr2,Linux 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Max process [message #581425]

Sat, 06 April 2013 05:47

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

Report message to a moderator

Re: Max process [message #581426 is a reply to message #581425]

Sat, 06 April 2013 05:53

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Re: Max process [message #581428 is a reply to message #581427]

Sat, 06 April 2013 07:29

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Max process [message #581518 is a reply to message #581428]

Mon, 08 April 2013 09:01

suhasdba
Messages: 141
Registered: April 2013
Location: INDIA

Senior Member

Thank you Michel

Report message to a moderator

Re: Max process [message #583786 is a reply to message #581518]

Sat, 04 May 2013 00:45

mmi78
Messages: 31
Registered: April 2013
Location: dhaka

Member

very useful link for newbie

Report message to a moderator

Re: Max process [message #585206 is a reply to message #581425]

Thu, 23 May 2013 00:15

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

Report message to a moderator

Re: Max process [message #585218 is a reply to message #585206]

Thu, 23 May 2013 01:21

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jun 08 02:45:49 CDT 2026