Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to increase MAX number of connections for Oracle DB server?
On 2 Feb, 15:01, "jshen...._at_gmail.com" <jshen...._at_gmail.com> wrote:
> Hi,
>
> I'm new to system tuning of Oracle DB. Our Oracle DB seems to only
> allow 128 connections,
> while the DB connection requirement has exceed 250. How could I
> increase the max number of connection allowed for this server? should
> I tune any other parameter ?
>
> Joe
>
> ps. there are 16 CPUs with 8GB DRAM and Disk arrays installed . The OS
> is HP-UX 11i.
Lots of information regarding the server configuration but, sadly, no Oracle version ;-)
Anyway, check out the SESSIONS initialisation parameter:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams190.htm#sthref785
HTH -g Received on Fri Feb 02 2007 - 09:09:08 CST