There are inactive user session from WCCDBADMIN and AUTOSYS. How should these be removed.
There are below inactive sessions observed:
USERNAME STATUS COUNT(*)
---------------------------------------- -------- ----------
AUTOSYS INACTIVE 120
WCCDBADMIN INACTIVE 80
Release : 11.3.6
Component : WORKLOAD CONTROL CENTER
Please stop the AutoSys and WCC products, then if there are still leftover sessions consult the DBA to assist in removing them.
Something like...
1. login to database as SA.
2. Check all the sessions that are inactive that owned by a db userid.
SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>';
3. To kill the sessio via alter command. Make sure you are entering the sid ahd serial# of the inactive session.
ALTER SYSTEM KILL SESSION '<sid, serial#>'
4.Recheck if there are any further inactive sessions.
SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>'