select SID,SERIAL#,USER#,USERNAME,OWNERID,SERVER,MACHINE,OSUSER from v$session; alter system kill session 'sid,serial#';