SELECT s.username,
s.osuser,
s.sid,
s.serial#,
p.spid,
s.status,
s.machine,
s.program,
TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time,
s.inst_id
FROM gv$session s
inner join v$process p
on s.paddr = p.addr
WHERE s.status = 'ACTIVE'
and s.type <> 'BACKGROUND';
  
  ALTER SYSTEM KILL SESSION '12345,56789,@2' immediate;
  ALTER SYSTEM KILL SESSION '56789,12345,@2' immediate;
  
SELECT    LO.SESSION_ID, LO.PROCESS, LO.ORACLE_USERNAME, O.OWNER, O.OBJECT_NAME
FROM      V$LOCKED_OBJECT LO
JOIN      DBA_OBJECTS O
  ON      O.OBJECT_ID = LO.OBJECT_ID;

hostgator