3 Replies Latest reply: Sep 5, 2013 5:43 PM by HDeiby RSS

    Too Many sessions


      I'm seeing too many sessions opened per minute by the application on the weblogic 10.3.4 application server even though there no users using it. Does anyone come across this kind of issue? any light on solving this kind of issue?



        • 1. Re: Too Many sessions

          Your applications possibly is opening many sessions and don't close it.


          if your database its Oracle you can execute this:


          select username, count(1) from v$session group by username order by 2 desc;


          if the top username its your application then check your application for how to close connections.

          • 2. Re: Too Many sessions



            whats the username that these sessions are opened/created from?

            after opening do they persist for long time ? or they kind of runaway processes.

            from the operating system check with the ps -ef command for the user/application to take a note of currently running processes.


            were there any recent changes ?




            • 3. Re: Too Many sessions

              you can execute:

              DESC V$SESSION


              you can use many columns:




              Pay atention at:


              Operating system client user name

              MACHINEVARCHAR2(64)Operating system machine name
              PROGRAMVARCHAR2(48)Operating system program name



              If you have PID you can use the next query to looking for "SID"


              select sid, s.serial# from v$session s, v$process p where paddr=addr and SPID=<PIDNUMBER>