Path: news.f.de.plusline.net!news-fra1.dfn.de!news-stu1.dfn.de!news.germany.com!postnews.google.com!j27g2000cwj.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 08:04:59 -0800
Organization: http://groups.google.com
Lines: 28
Message-ID: <1170432299.100352.70660@j27g2000cwj.googlegroups.com>
References: <1170428506.545818.24500@v33g2000cwv.googlegroups.com>
   <1170428948.496209.81020@h3g2000cwc.googlegroups.com>
   <1170430046.234622.183380@l53g2000cwa.googlegroups.com>
NNTP-Posting-Host: 193.130.12.157
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1170432305 15448 127.0.0.1 (2 Feb 2007 16:05:05 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 16:05:05 +0000 (UTC)
In-Reply-To: <1170430046.234622.183380@l53g2000cwa.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: j27g2000cwj.googlegroups.com; posting-host=193.130.12.157;
   posting-account=zujbXgsAAAA8hne0tKRbNp7NAGtNgEwN
Xref: news.f.de.plusline.net comp.databases.oracle.server:193507

On 2 Feb, 15:27, "jshen....@gmail.com" <jshen....@gmail.com> wrote:
> thanks for quick help.
>
> the DB version is 8.1.7.
>
> Joe
>
>
>
> > 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/ini...- Hide quoted text -
>
> - Show quoted text -

What do the following SQL*Plus commands return?

SQL> show parameter processes

SQL> show parameter sessions

HTH

-g