查用户
select Lo.session_id, Lo.oracle_username, Lo.os_user_name
from v$locked_object Lo, dba_objects ob
where Lo.object_id = ob.object_id
and ob.owner = 'YOUR_ORACLE_NAME'
and ob.object_name + 'YOUR_PROCEDURE'
;
解锁的话,首先查 sid,serial#
select s.sid, s.serial# -- 和其它确认字段...
from v$session s, v$locked_object Lo, dba_objects ob
where s.sid = Lo.session_id
and Lo.object_id = ob.object_id
and ob.owner = 'YOUR_ORACLE_NAME'
and ob.object_name + 'YOUR_PROCEDURE'
;
结果的例子
SIDSERIAL#
---------- ----------
3917220
以后,用 kill session
alter system kill session 39,17220;
|