How to find and kill user session in Oracle database

Command which will allow us to find active sessions :

SYS SolA >select sid,serial#,username,osuser from v$session where username is not null;

SID       SERIAL#            USERNAME  OSUSER
———- ———- —————————— ——————————
50         3                                         SYS oracle

,to end session listed above we use:

SYS SolA >alter system kill session ‘50,3’;

System altered.

Leave a Response