Add new comment

Who is connected to the DB, and what can you tell me about their sessions?
select 
  s.username||','||s.sid uname, 
  s.serial# serial, 
  s.process, 
  s.terminal, 
  to_char(s.logon_time, 'Dy HH24:MI') logon_time, 
  s.status, 
  s.module 
  from v$session s 
  where s.type = 'USER' 
  and s.username is not null 
  and s.username like :your_usr_name_here 
  order by username; 
  
You can then: 
  alter system kill session 'sid,serial#';