SELECT a_s.owner,
a_s.object_name,
a_s.object_type,
VN.SID,
VN.SERIAL#,
VS.SPID "OS_PID" ,
VN.PROCESS "CLIENT_PID" ,
VN.USERNAME,
VN.OSUSER,
VN.MACHINE "HOSTNAME" ,
VN.TERMINAL,
VN.PROGRAM,
TO_CHAR(VN.LOGON_TIME, 'YYYY-MM-DD HH24:MI:SS' ) "LOGIN_TIME" ,
'alter system kill session ' '' ||vn.sid|| ',' ||vn.serial#|| '' ';' "ORACKE_KILL" ,
'kill -9 ' || VS.SPID "OS_KILL"
FROM ALL_OBJECTS A_S,
V$LOCKED_OBJECT V_T,
V$SESSION VN,
V$PROCESS VS
WHERE A_S.OBJECT_ID=V_T.OBJECT_ID
AND V_T.SESSION_ID =VN.SID
AND VS.ADDR=VN.PADDR
AND VN.USERNAME NOT IN ( 'SYSMAN' , 'SYS' );
|