Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h2418mK06799 for ; Mon, 3 Mar 2003 19:08:48 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h2418m306790 for ; Mon, 3 Mar 2003 19:08:48 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id NAA39333; Mon, 3 Mar 2003 13:47:22 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0055EEBD; Mon, 03 Mar 2003 13:24:17 -0800 Message-ID: Date: Mon, 03 Mar 2003 13:24:17 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Sam Bootsma" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Sam Bootsma" Subject: ORA-00018: maximum number of sessions exceeded Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2E1C7.5018FF06" ------_=_NextPart_001_01C2E1C7.5018FF06 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. =20 =20 This afternoon, our users started getting the error message "ORA-00018: maximum number of sessions exceeded." As time went on, the number of sessions was decreasing (as shown by the count of rows in v$session). However, Oracle still did not allow connections. This lasted for about 40 minutes. =20 =20 The sessions parameter in the initialization parameter file showed 300. =20 Querying v$session showed 246 rows. =20 Querying v$license reported: SQL> select * from v$license; =20 SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX ------------ ---------------- ---------------- ------------------ --------- 0 0 204 248 0 =20 There seems to be a contradiction here: 300 sessions in init.ora; sessions_highwater at 248, and Oracle not allowing connections because the maximum has been reached. =20 Has anybody encountered this problem before. Is there a "simple" reason for this erratic behavior? =20 =20 Management is looking for an answer as to why this has happened. Thanks for any input! =20 Sam Bootsma sbootsma@gbrownc.on.ca =20 ------_=_NextPart_001_01C2E1C7.5018FF06 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0.

This afternoon, our users started getting the error = message “ORA-00018: maximum number of sessions exceeded.” As time went on, the = number of sessions was decreasing (as shown by the count of rows in = v$session). However, Oracle still did not allow connections. This lasted for = about 40 minutes.

The sessions parameter in the initialization = parameter file showed 300.

Querying v$session showed 246 rows.

Querying v$license reported:

SQL> select * from v$license;

SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX

------------ ---------------- ---------------- ------------------ ---------

= 0 = 0 = 204 &nbs= p; 248 = 0

There seems to be a contradiction here: 300 = sessions in init.ora; sessions_highwater at 248, and Oracle not allowing = connections because the maximum has been reached.

Has anybody encountered this problem before. Is = there a “simple” reason for this erratic behavior? =

Management is looking for an answer as to why this = has happened. Thanks for any input!

Sam Bootsma

sbootsma@gbrownc.on.ca<= /font>

=00 ------_=_NextPart_001_01C2E1C7.5018FF06-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sam Bootsma INET: sbootsma@gbrownc.on.ca Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).