OraFAQ Forum: Server Administration » Increasing the value of sessions and processess.

Home » RDBMS Server » Server Administration » Increasing the value of sessions and processess. (IBM PPC in Linux x86 64 bit)

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

Increasing the value of sessions and processess. [message #290975]

Wed, 02 January 2008 07:39

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.

Report message to a moderator

Re: Increasing the value of sessions and processess. [message #290983 is a reply to message #290975]

Wed, 02 January 2008 08:25

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

Report message to a moderator

Re: Increasing the value of sessions and processess. [message #290989 is a reply to message #290975]

Wed, 02 January 2008 08:52

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Give the values you want even if by default they are calculated from others.

Regards
Michel

Report message to a moderator

Previous Topic:	upgrade
Next Topic:	Oracle 9.3 Itanium

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 13:46:47 CDT 2024