This content has been marked as final. Show 5 replies
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.
A STATUS of INACTIVE in V$SESSION simply means that a session isn't executing a SQL statement at the instant you query the data dictionary. That's perfectly normal and expected. The vast majority of sessions spend the vast majority of their time in an INACTIVE status.
Do you have a specific problem that you believe inactive sessions are causing?