5 Replies Latest reply: Jan 30, 2013 1:02 PM by sb92075 RSS

    Oracle idle sessions & SQL responsible

      Hi Gurus,

      I am using the following SQL to identify the idle sessions:
      select status "st", sid "sid", username "user", program "prg"
      from v$session
      where username is not null
      and audsid <> userenv('SESSIONID')
      order by status;

      I need to identify the SQLs responsible or might be responsible to generate idle sessions. Is there any SQL to do that.