Hi All,
Can anyone please explain me about the inactive sessions in oracle? I used the following query to get the list of inactive queries:
SELECT sid, osuser, schemaname, ROUND ( (last_call_et) / (60 * 60), 2) inactive_from_hours, program
FROM v$session
WHERE status = 'INACTIVE';
Based on the result of this query, I have asked the resposible users to kill their sessions. But many of them complained that, their query is completed long ago. I'm in a bind in this situation.
When does a session gets inactive?
If a query execution is completed, why it being shown as inactive?
Closing the window through which the query ran, will solve this problem? Does this method has something to do with this wrong output?