SELECT s.sid,
       s.serial#,
       s.osuser,
       s.program
FROM   v$session s
   WHERE TYPE = 'USER'
   AND AUDSID != USERENV('SESSIONID')
   and s.osuser='nmishin'
order by  s.osuser

--ALTER SYSTEM KILL SESSION 'sid,serial#';

        36,27722 nmishin
       128,63526 nmishin
ALTER SYSTEM KILL SESSION '128,63526';



select s.sid,       s.serial#,username, status from v$session s where
osuser='nmishin'


select t.USED_UBLK,t.addr,t.start_time,t.status,t.flag from  v$transaction t

select * from v$transaction


SELECT   S.USERNAME,   s.osuser,
         S.SID,
         S.SERIAL#,
         L.TYPE,
         L.ID1,
         L.ID2
FROM     V$LOCK L, V$SESSION S
WHERE    L.SID=S.SID
and
    AUDSID != USERENV('SESSIONID')
   and s.osuser='nmishin'


SELECT   P.PID,
         P.SPID,
         DECODE (P.USERNAME,
                 '?', DECODE(S.USERNAME,
                             NULL, P.USERNAME,
                             '(' || S.USERNAME || ')'),
                 P.USERNAME),
         NVL(S.TERMINAL, P.TERMINAL),
         P.LATCHWAIT,
         NVL(S.PROGRAM, P.PROGRAM)
FROM     V$PROCESS P, V$SESSION S
WHERE    P.ADDR = S.PADDR(+)
order by 4


select s.username, s.sid,p.spid from V$SESSION s, V$PROCESS p where
s.PADDR = p.ADDR and s.status='KILLED'