oracle ¼ì²é±»ËøµÄ±í¼°½âËø

Ô­ÎĵØÖ·£ºhttp://tech.e800.com.cn/articles/2009/710/1247207067745_1.html
´¦Àí·½·¨Ò» £º

¼ì²éÄĸö±í±»Ëø
select sess.sid,sess.serial#,
lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from
v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id =
lo.object_id
and lo.session_id = sess.sid;

½âËø
alter
system kill session 'xxx,yyy';
×¢£º'xxx,yyy'ÊÇÉÏÃæ¼ìË÷µÃµ½µÄsess.sid,sess.serial#
´¦Àí·½·¨¶þ £º
ÕÒµ½ÄãҪɱµôµÄÄǸöSESSION,
²¢¼ÇÏÂpaddr
SELECT sid, username, paddr, status from v$session WHERE
username = 'JCUSER' and sid=ÉÏÃæ²é³öÀ´µÄsid;

ÕÒµ½Õâ¸öSESSIONËù¶ÔÓ¦µÄspid
SELECT
ADDR,PID,SPID,USERNAME,SERIAL#,TERMINAL from v$process WHERE addr¡¡=
'ÉÏÃæµÄPADDR';

ɱµôspidËù±êʶµÄÄǸö½ø³Ì
orakill sid spid