Path: news.f.de.plusline.net!news-fra1.dfn.de!news.tele.dk!feed118.news.tele.dk!postnews.google.com!h3g2000cwc.googlegroups.com!not-for-mail
From: "gazzag" <gareth@jamms.org>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to increase MAX number of connections for Oracle DB server?
Date: 2 Feb 2007 07:09:08 -0800
Organization: http://groups.google.com
Lines: 25
Message-ID: <1170428948.496209.81020@h3g2000cwc.googlegroups.com>
References: <1170428506.545818.24500@v33g2000cwv.googlegroups.com>
NNTP-Posting-Host: 193.130.12.157
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1170428953 18473 127.0.0.1 (2 Feb 2007 15:09:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 15:09:13 +0000 (UTC)
In-Reply-To: <1170428506.545818.24500@v33g2000cwv.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: h3g2000cwc.googlegroups.com; posting-host=193.130.12.157;
   posting-account=zujbXgsAAAA8hne0tKRbNp7NAGtNgEwN
Xref: news.f.de.plusline.net comp.databases.oracle.server:193501

On 2 Feb, 15:01, "jshen....@gmail.com" <jshen....@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