select SID, SERIAL#, username, osuser, machine from v$session;username = database username
osuser = client operating system user that is connecting to the database
machine = client machine IP.
Remember the SID and SERIAL# of the user(s) that you with to kill/disconnect. Then issue a kill command.
Alter system kill session ‘SID,SERIAL#’;
