Home » RDBMS Server » Server Administration » Number of connections
Number of connections [message #262859] Tue, 28 August 2007 06:53 Go to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Hi. Could someone please tell me how could I increase the number of connections for a Oracle 9 database under windows 2003 server? Thank you!
Re: Number of connections [message #262867 is a reply to message #262859] Tue, 28 August 2007 07:05 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Increase session parameter.

Re: Number of connections [message #262875 is a reply to message #262859] Tue, 28 August 2007 07:18 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
You can increase the sessions parameter but this requires a server restart.

Another option is, if you are using Dedicated Connections, switch to shared server architecture.

[Updated on: Tue, 28 August 2007 07:19]

Report message to a moderator

Re: Number of connections [message #262899 is a reply to message #262875] Tue, 28 August 2007 08:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
You can increase the sessions parameter but this requires a server restart.

Only the Oracle instance.
Quote:
Another option is, if you are using Dedicated Connections, switch to shared server architecture

Never use that unless you cannot do anything else.

Regards
Michel
Re: Number of connections [message #262973 is a reply to message #262859] Tue, 28 August 2007 12:32 Go to previous messageGo to next message
alexia_net
Messages: 25
Registered: August 2007
Junior Member
Ok. Thank you very much!
Re: Number of connections [message #263051 is a reply to message #262875] Tue, 28 August 2007 23:07 Go to previous message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Michel,

Thanks for your corrections. Cool

[Updated on: Tue, 28 August 2007 23:07]

Report message to a moderator

Previous Topic: when table altered?
Next Topic: controlfile error
Goto Forum:
  


Current Time: Fri Dec 02 16:55:49 CST 2016

Total time taken to generate the page: 0.27411 seconds