发表于 2009-1-5 19:48
| 
ORACLE鐢ㄦ埛杩炴帴鐨勭鐞
鍙戝竷: 2008-6-30 14:56 | 浣滆: admin | 鏌ョ湅: 9娆
ORACLE鐢ㄦ埛杩炴帴鐨勭鐞
鐑 鑽
銆愬瓧浣擄細灏 澶с
ORACLE鐢ㄦ埛杩炴帴鐨勭鐞
浣滆咃細浣氬悕 鏂囩珷鏉ユ簮锛氫笉璇 鐐瑰嚮鏁帮細901 鏇存柊鏃堕棿锛2006-4-17 
鐢ㄧ郴缁熺鐞嗗憳锛屾煡鐪嬪綋鍓嶆暟鎹簱鏈夊嚑涓敤鎴疯繛鎺ワ細
SQL> select username,sid,serial# from v$session;
濡傛灉瑕佸仠鏌愪釜杩炴帴鐢
SQL> alter system kill session 'sid,serial#';
濡傛灉杩欏懡浠や笉琛,鎵惧畠UNIX鐨勮繘绋嬫暟
SQL> select pro.spid from v$session ses,v$process pro where ses.sid=&sid and ses.paddr=pro.addr;
鐒跺悗鐢 kill 鍛戒护鏉姝よ繘绋嬪彿銆
銉
