OracleɱµôËÀËø½ø³Ì
ÓÃOracle Sql Developer²Ù×÷±íµÄʱºò£¬²»ÖªÕ¦µÄ°Ñ±íËøסÁË¡£
½á¹ûÄÇÕűíÒ»²åÊý¾Ý¾ÍËÀ£¬Á¬truncate¶¼²»ÐС£
´ÓÍøÉÏÆßÆ´°Ë´ÕÁ˸ö·½·¨£¬ÖÕÓڰѽø³ÌɱÁË£¬±íÒ²¾Í½âËøÁË¡£
Ê×ÏÈÒªÓÃdba¼¶±ðµÄÓû§²Ù×÷£¬ÒòΪҪ²ì¿´ºÜ¶àϵͳ±í¡£ÓÃÆÕͨÓû§²Ù×÷µÄ»°£¬»áÌáʾ±í»òÕßView²»´æÔÚ¡££¨ÎªÊ²Ã´²»ÌáʾȨÏÞ²»¹»£¿º¦ÎÒ×ÜÒÔΪÊÇ°æ±¾ÎÊÌ⣩
È»ºóÕÒËø±íµÄsid(session id)£¬SERIAL#£¬PADDR
SELECT * from V$SESSION where osuser='XXXXXX'; --osuserÊǵǽwindowsÃû
ÕÒspid
SELECT SPID from V$PROCESS WHERE ADDR='¸Õ²Å²éµ½µÄPADDR';
×îºó. ɱ½ø³Ì
(1).ÏÈɱORACLE½ø³Ì:
ALTER SYSTEM KILL SESSION '²é³öµÄSID,²é³öµÄSERIAL#';
(2).ÔÙɱ²Ù×÷ϵͳ½ø³Ì:KILL -9 ¸Õ²Å²é³öµÄSPID»ò
ORAKILL ¸Õ²Å²é³öµÄSID ¸Õ²Å²é³öµÄSPID
ÌáʾÕÒ²»µ½spid¡£¡£¡£²»¹ÜÁË£¬È¥¿´¿´ËøסµÄ±í¡£ÄܲåÊý¾ÝÁË£¬½â¾ö¡£
Ïà¹ØÎĵµ£º
ÎÒÁгöÎÒÈ«²¿µÄ×ö·¨£º
table a ÓÐid1, str1, str2, str3
¿ªÊ¼µÄpkÊÇid1, str1, str2
Ï£Íû¸Ä³Éid1, str1, str3
--ÎÊÌâ
СµÜÏÈÓÐÈçÏÂÎÊÌ⣺
Ò»¸ö±íÔÀ´µÄPKÊÇ id1+str1+str2 ÁÐ
ÏÈÐ޸ijÉid1+str1+str3ÁÐ
¶øÕâÈýÁÐÏÖÔÚµ±Ç°Êý¾Ý¿âµÄÊý¾ÝÓÐÖظ´µÄÇé¿ö£¬ СµÜÏÖÔÚÓÃsql:
ALTER table a a ......
alter system kill session'50,492';
--ÒÔϼ¸¸öΪÏà¹Ø±í
SELECT * from v$lock;
SELECT * from v$sqlarea;
SELECT * from v$session;
SELECT * from v$process ;
SELECT * from v$locked_object;
SELECT * from all_objects;
SELECT * from v$session_wait; ......
·½·¨Ò»£º
1) ²é¿´·þÎñÆ÷¶Ë×Ö·û¼¯£º &nbs ......
ÔÎĵØÖ·£ºhttp://www.dbabeta.com/2008/oracle_os_pwfile_authentication.html
±¾ÎĸÅÊöÓëʵÑé»·¾³
¸ÅÊö£º
±¾ÎÄÖ»ÌÖÂÛOSÈÏÖ¤ºÍ¿ÚÁîÎļþÈÏÖ¤·½Ê½µÄÅäÖ÷½·¨£¬ÈçºÎÅäÖÃÒÔ¼°Ê¹ÓÃOSÈÏÖ¤ºÍ¿ÚÁîÎļþÈÏÖ¤·½Ê½ÑéÖ¤SYSDBA/SYSOPERȨÏÞ¡£
ʵÑé»·¾³£º
Oracle 10.1 + Windows 2003 ºÍ Oracle 10.2 + RHEL 4
ÌØÊâȨÏÞÓëOracleµÇ½ ......
1. Oracle°²×°Íê³ÉºóµÄÔʼ¿ÚÁ
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄÔʼĬÈÏÓû§ºÍÃÜÂ룿
administrator/administrator
3. oracle 8.0.5ÈçºÎ½¨Á¢Êý¾Ý¿â£¿
ÓÃorainst¡£¼ÙÈçÓÐmotif½çÃ棬Äܹ»ÓÃorainst /m¡ ......