Home » RDBMS Server » Server Administration » Increasing the value of sessions and processess. (IBM PPC in Linux x86 64 bit)
Increasing the value of sessions and processess. [message #290975] Wed, 02 January 2008 07:39 Go to next message
ara.oracle
Messages: 142
Registered: August 2007
Senior Member
We are having production site of Oracle database RAC
and application servers.
The value of processess in spfile of database is 150.
There is no session parameter in our spfile.

The users who are accessing the database,if they go beyond the session values, we are getting errors.
So we need to change the value of sessions and processess.
But when i refered the oracle document they have given not to modify these parameters.
since these parameters are dependent on other parameters.
so guide us how to change these parameters.And am remembering you once again tat this is critical production site.
Re: Increasing the value of sessions and processess. [message #290983 is a reply to message #290975] Wed, 02 January 2008 08:25 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
check V$SESSION or v$processes to see the current connection statistics
Re: Increasing the value of sessions and processess. [message #290989 is a reply to message #290975] Wed, 02 January 2008 08:52 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Give the values you want even if by default they are calculated from others.

Regards
Michel
Previous Topic: upgrade
Next Topic: Oracle 9.3 Itanium
Goto Forum:
  


Current Time: Sat Nov 30 01:29:33 CST 2024