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

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


Current Time: Fri Dec 02 18:21:01 CST 2016

Total time taken to generate the page: 0.19401 seconds