Re: 16 session max

From: Joel Garry <joelga_at_pebble.org>
Date: Thu, 16 Jul 1998 00:34:18 GMT
Message-Id: <slrn6qqild.aoi.joelga@pebble.org>

On Wed, 15 Jul 1998 16:53:55 +0100, Pete B <Blakemore_p_at_email.msn.com> wrote:
>Hi
>
>Using Oracle 7.3 on a IBM box using AIX with 4 databases on one instance,
>when we get to sixteen concurrent connections no one else can connect,
>nothing in any of the logfiles indicating errors, any ideas please!
>
>Thanks in advance
>
>
>
>

Sounds like you are running out of processes. Look at your install manual and remember that the kernel requirements are additive - you need to add them all up. Be sure you haven't limited oracle processes in your init.ora, too.

Also, if you have any licensing enabled for 16 users. This should err, though.

Also, be sure your SGA's aren't sized for just one instance (although that would most likely be giving errors). Be sure you aren't running out of swap space.

Getting more obscure, there is a queuesize parameter in the listener that defaults to 17, which might have an effect if something is seriously slowing things down.

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Wed Jul 15 1998 - 19:34:18 CDT