Sessions automations
Conditions to check whether the session is inactive->
1. We kill only the inactive sessions of user process only, not the background process.
2. If session has hash value 0 and status is inactive, then only kill the sessions
3. If session has any hash value, then this is called active sessions
4. check sessions with v$session;
select sid, serial#, status from v$session where type='USER' and status='INACTIVE';
alter system kill session 'sid, serial#';
Correct me if I am wrong.
I have a requirement that all the inactive sessions should be automatically killed in the database only. There should not be any user interventions to check the sessions and kill the inactive sessions, how to achieve this ?