This discussion is archived
3 Replies Latest reply: Sep 5, 2013 3:43 PM by HDeiby RSS

Too Many sessions

Redbox009 Newbie
Currently Being Moderated

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?

 

Thanks

  • 1. Re: Too Many sessions
    HDeiby Oracle ACE
    Currently Being Moderated

    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
    Rajiv. Explorer
    Currently Being Moderated

    Hi,

     

    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 ?

     

    Thanks,

    Rajiv.

  • 3. Re: Too Many sessions
    HDeiby Oracle ACE
    Currently Being Moderated

    you can execute:

    DESC V$SESSION

     

    you can use many columns:

     

    V$SESSION

     

    Pay atention at:

    OSUSERVARCHAR2(30)

    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>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points