1 得到sid, serial select sid, serial#, username, machine, osuser, program, status, 'alter system kill session ''' || sid || ',' || serial# || ''';' sql from v$session where username is not null;2 kill你要kill的session ALTER system kill session 'sid, serial#';
select object_id,session_id,serial#,oracle_username,os_user_name from v$locked_object,v$session where v$locked_object.session_id=v$session.sid; 查出LOCK的进程 然后 alter system kill session 'sessionid,serial#';
print jobno;
查看当前创建的job号
或者通过all_jobs来查看job的情况。
或者
select job,what from all_jobs;
看一下是那个job号sql>exec dbms_job.broken(查询到的号码,true);
select sid, serial#, username, machine, osuser, program, status,
'alter system kill session ''' || sid || ',' || serial# || ''';' sql
from v$session
where username is not null;2 kill你要kill的session
ALTER system kill session 'sid, serial#';