ÍêÈ«¸Éµô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,
Ïà¹ØÎĵµ£º
oracleµ¼³öµ¼ÈëÊý¾Ý²Ù×÷
OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî
Oracle Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°Ñ dmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓà ......
Ëæ×Åʱ¼äºÍÁ¬½Ó£¬OracleµÄlistener.log»á²»¶ÏÔö³¤,Õâʱ¾ÍÐèÒªÎÒÃǶÔÆä½øÐд¦Àí¡£ÈôÊÔͼֱ½ÓÔÚlistenerÆô¶¯Ê±Ö±½Óɾ³ý£¬¿ÉÄÜ»áÊÕµ½±¨´íÐÅÏ¢ÀàËÆ£ºThe process cannot access the file because it is being used by another process¡£ÈôÖ±½ÓÍ£µô¼àÌýÔÙɾ³ý£¬¶ÔÓÚÉú²ú¿â,Õâ»ù±¾ÊDz»±»ÔÊÐíµÄ²Ù×÷,ÔÚUnixÏÂÃ浱Ȼ¿ÉÒÔrm,µ«Õâ¸öÎÄ ......
¹ý³Ì¡¢º¯Êý¡¢³ÌÐò°ü¡¢´¥·¢Æ÷
1 ¹ý³Ì
£¨1£©¶¨ÒåÓï·¨
create [or replace ] procedure ¹ý³ÌÃû
[(²ÎÊý1 [in | out | in out] ²ÎÊýÀàÐÍ£¬
²ÎÊý2 [in | out | in out] ²ÎÊýÀàÐÍ£¬
……)]
is | as
begin
Ö´Ðв¿·Ö
exception
Òì³£´¦Àí²¿·Ö
end [¹ý³ÌÃû];
¹ý³ÌÖÐûÓÐdeclare²¿·Ö£¬ÉùÃ÷²¿ ......
Oracle 1z0-033 ÈÈÃÅÈÏÖ¤
1z0-033 Exam
Oracle9i Database:Performance Tuning
¿ÆÄ¿±àºÅ£º1z0-033
¿ÆÄ¿Ãû³Æ£ºOracle 9i Database:Performance Tuning
¿¼ÊÔ¼Û¸ñ£ºCNY898
¿¼ÊÔʱ¼ä£º120·ÖÖÓ
¿¼ÌâÊýÁ¿£º65
¼°¸ñ·ÖÊý£º72£¥
¸üÐÂÈÕÆÚ£º2010-01-23
Oracle 1z0-033 ÊÇÒ»¸öÅÓ´óµÄÆ·ÅÆϵͳ¡£ÈçÇ°ËùÊö£¬Oracle²»½öÔÚÈ«Çò× ......
Ò»¡¢PL/SQL±à³Ì¹æ·¶Ö®´óСд
¾ÍÏñÔÚSQLÖÐÒ»Ñù£¬PL / SQLÖÐÊDz»Çø·Ö´óСдµÄ¡£ÆäÒ»°ã×¼ÔòÈçÏ£º
¹Ø¼ü×Ö(BEGIN, EXCEPTION, END, IF THEN ELSE,LOOP, END LOOP)¡¢Êý¾ÝÀàÐÍ(VARCHAR2, NUMBER)¡¢ÄÚ²¿º¯Êý(LEAST, SUBSTR)ºÍÓû§¶¨ÒåµÄ×Ó³ÌÐò(procedures, functions,packages)£¬Ê¹Óôóд¡£
±äÁ¿ÃûÒÔ¼°SQLÖеÄÁÐÃûºÍ±íÃû£¬Ê¹ÓÃÐ ......