amitavachatterjee1975 wrote:if/when session is actually IDLE, then it is NOT executing any SQL!
I am using the following SQL to identify the idle sessions:
select status "st", sid "sid", username "user", program "prg"
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.