Home » RDBMS Server » Server Administration » Process & Session (Oracle 10g)
Process & Session [message #422159] Mon, 14 September 2009 19:46 Go to next message
gmkhaw@yahoo.com
Messages: 14
Registered: September 2006
Location: Malaysia
Junior Member
Hi guys,
Do you know how to increase the processes and sessions at the server setting? My current is 150 & 170 respectively.

Report message to a moderator

Re: Process & Session [message #422160 is a reply to message #422159] Mon, 14 September 2009 20:10 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> ALTER SYSTEM SET PROCESSES=500 SCOPE=SPFILE;

then restart DB

Report message to a moderator

Previous Topic: How to generate SQL Server database scripts automatically
Next Topic: Oracle Jobs are Not Running
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 01 17:05:16 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.