list db sessions.sql
SELECT nvl(S.OSUSER,S.type) OS_Usercode,
      S.USERNAME          Oracle_Usercode,
      S.sid               Oracle_SID,
      S.serial#           serial_#,
      S.process           F_Ground,
      P.spid              B_Ground
FROMÂ Â V$SESSION S,
      V$PROCESS P
WHEREÂ nvl(upper(S.OSUSER),’KKK’)Â Â like nvl(upper(‘&OS_User’),’%’)
And   nvl(upper(S.Username),’KKK’) like nvl(upper(‘&Oracle_User’),’%’)
And   s.paddr = p.addr
order by s.sid
/
prompt kill with alter system kill session ‘sid,serial#’
Discussion ¬