ÍêÈ«¸ÉµôOracleËÀËø½ø³Ì

ÍêÈ«¸ÉµôOracleËÀËø½ø³Ì
1.²éÄĸö¹ý³Ì±»Ëø:
²éV$DB_OBJECT_CACHEÊÓͼ:SELECT * from V$DB_OBJECT_CACHE WHERE OWNER='¹ý³ÌµÄËùÊôÓû§' AND CLOCKS!='0';
2. ²éÊÇÄÄÒ»¸öSID,ͨ¹ýSID¿ÉÖªµÀÊÇÄĸöSESSION:
²éV$ACCESSÊÓͼ:SELECT * from V$ACCESS WHERE OWNER='¹ý³ÌµÄËùÊôÓû§' AND NAME='¸Õ²Å²éµ½µÄ¹ý³ÌÃû';
3. ²é³öSIDºÍSERIAL#£º
²éV$SESSIONÊÓͼ:SELECT SID,SERIAL#,PADDR from V$SESSION WHERE SID='¸Õ²Å²éµ½µÄSID';
²éV$PROCESSÊÓͼ:SELECT SPID from V$PROCESS WHERE ADDR='¸Õ²Å²éµ½µÄPADDR';
4. ɱ½ø³Ì£º
(1)ÏÈɱOracleËÀËø½ø³Ì:ALTER SYSTEM KILL SESSION '²é³öµÄSID,²é³öµÄSERIAL#';
(2)ÔÙɱ²Ù×÷ϵͳ½ø³Ì:KILL -9 ¸Õ²Å²é³öµÄSPID»òORAKILL ¸Õ²Å²é³öµÄSID ¸Õ²Å²é³öµÄSPID¡£
OracleËÀËø½ø³Ì
²éѯÊý¾Ý¿âËÀËø£º
select t2.username||' '||t2.sid||'  '||t2.serial#||' '||t2.logon_time||'  '||t3.sql_text  from v$locked_object t1,v$session t2,v$sqltext t3  where t1.session_id=t2.sid  and t2.sql_address=t3.address  order by t2.logon_time; 
²éѯ³öÀ´µÄ½á¹û¾ÍÊÇÓÐËÀËøµÄsessionÁË£¬ÏÂÃæ¾ÍÊÇɱµô£¬Äõ½ÉÏÃæ²éѯ³öÀ´µÄSIDºÍSERIAL#£¬ÌîÈëµ½ÏÂÃæµÄÓï¾äÖУº
alter system kill session 'sid,serial#';  
Ò»°ãÇé¿ö¿ÉÒÔ½â¾öÊý¾Ý¿â´æÔÚµÄËÀËøÁË£¬»òͨ¹ýsession id ²éµ½¶ÔÓ¦µÄ²Ù×÷ϵͳ½ø³Ì£¬ÔÚUnixÖÐɱµô²Ù×÷ϵͳµÄ½ø³Ì¡£
SELECT a.username,c.spid AS os_process_id,c.pid  AS oracle_process_id from v$session a,v$process c  WHERE c.addr=a.paddr and a.sid= and a.serial#= ; 
È»ºó²ÉÓÃkill £¨unix£© »ò orakill£¨windows £©¡£
ÔÚUnixÖУº
ps -ef|grep os_process_id  kill -9 os_process_id  ps -ef|grep os_process_id 
¾­³£ÔÚOracleµÄʹÓùý³ÌÖÐÅöµ½Õâ¸öÎÊÌ⣬ËùÒÔÒ²×ܽáÁËÒ»µã½â¾ö·½·¨¡£
1£©²éÕÒËÀËøµÄ½ø³Ì£º
sqlplus "/as sysdba" (sys/change_on_install)  SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,  l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS  from V$LOCKED_OBJECT l,