Disconnect User from Oracle Database

1. Select all user:

select username from v$session where username is not null;

2. Select specific user:

select sid,serial#,program from v$session where username = 'yourusername';

3. Disconnect user by SID and Serial#:

alter system disconnect session 'SID','Serial' immediate;