Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to increase MAX number of connections for Oracle DB server?

Re: How to increase MAX number of connections for Oracle DB server?

From: gazzag <gareth_at_jamms.org>
Date: 2 Feb 2007 07:09:08 -0800
Message-ID: <1170428948.496209.81020@h3g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US