This discussion is archived
5 Replies Latest reply: Jan 30, 2013 11:02 AM by sb92075 RSS

Oracle idle sessions & SQL responsible

amitavachatterjee1975 Newbie
Currently Being Moderated
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.

Thanks
Amitava.

Legend

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