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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00018: maximum number of sessions exceeded

RE: ORA-00018: maximum number of sessions exceeded

From: Sam Bootsma <sbootsma_at_gbrownc.on.ca>
Date: Tue, 04 Mar 2003 06:58:59 -0800
Message-ID: <F001.0055F7E0.20030304065859@fatcity.com>


Tim and Dennis: Thanks for your responses:  

SVRMGR> show parameter session

NAME                                TYPE    VALUE

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

license_max_sessions                integer 0


license_sessions_warning            integer 0


session_cached_cursors              integer 10


sessions                            integer 300


SVRMGR>   The SESSION parameter is hard-coded in our init.ora file to the value 300. The value for PROCESSES is set to 512. We have hard-coded our SESSION parameter because our number of licenses is set to 300 - however, my intuition tells me that the SESSION parameter should not be set based on our number of licenses. Can anybody confirm this for me?  

I have also set up a TAR with Oracle Support, and they too say we need to increase the SESSION parameter (but we want to confirm it has no link to licenses).  

Thanks again!  

Sam Bootsma

416-415-5000 x4933    

-----Original Message-----
Sent: March 3, 2003 4:54 PM
To: Multiple recipients of list ORACLE-L  

I don't recall if the V$RESOURCE_LIMIT view existing in 7.3.4, but you might want to check. It is a better diagnostic point for that particular resource...  

The "init.ora" parameter SESSIONS is related to the ORA-00018 error message, not any of the licensing parameters. Please use SHOW PARAMETER SESSIONS in SVRMGR to display its value. Generally, people let the value of the SESSIONS parameter default to 1.1 * PROCESSES, but you can increase it if you like.  

Hope this helps...

        From: Sam Bootsma <mailto:sbootsma_at_gbrownc.on.ca>

        To: Multiple recipients of list ORACLE-L <mailto:ORACLE-L_at_fatcity.com>

        Sent: Monday, March 03, 2003 2:24 PM

        Subject: ORA-00018: maximum number of sessions exceeded          

        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
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_at_gbrownc.on.ca          

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sam Bootsma
  INET: sbootsma_at_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_at_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).
Received on Tue Mar 04 2003 - 08:58:59 CST

Original text of this message

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