OraFAQ Forum: Server Administration » Number of connections

Home » RDBMS Server » Server Administration » Number of connections

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

Number of connections [message #262859]

Tue, 28 August 2007 06:53

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!

Report message to a moderator

Re: Number of connections [message #262867 is a reply to message #262859]

Tue, 28 August 2007 07:05

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Increase session parameter.

Report message to a moderator

Re: Number of connections [message #262875 is a reply to message #262859]

Tue, 28 August 2007 07:18

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Number of connections [message #262973 is a reply to message #262859]

Tue, 28 August 2007 12:32

alexia_net
Messages: 25
Registered: August 2007

Junior Member

Ok. Thank you very much!

Report message to a moderator

Re: Number of connections [message #263051 is a reply to message #262875]

Tue, 28 August 2007 23:07

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 06:51:46 CST 2024