Ö´ÐÐcommitʱoracle×öÄÄЩ¹¤×÷
COMMITÊÇÒ»¸ö·Ç³£¿ìµÄ²Ù×÷£¬µ±ÎÒÃÇ·¢²¼commitÃüÁîʱ£¬ÕæÕýÀ§ÄѵĶ¯×÷ÒѾÍê³É£¬
ÔÚÊý¾Ý¿âÖÐÒѾִÐÐÁËÊý¾Ý¸ü¸Ä£¬ËùÒÔÒѾÍê³ÉÁË99%µÄÈÎÎñ£¬ÀýÈ磺ÏÂÁвÙ×÷ÒѾ²úÉú£º
1.ÔÚSGA(Buffer Cache)ÖÐÒѾÉú³ÉÁËundo¿é£»
2.ÔÚSGA(Buffer Cache)ÖÐÒѾÉú³ÉÁ˲úÉú¸Ä±äµÄÊý¾Ý¿éºÍË÷Òý¿é£»
3.ÔÚREDO LOG BUFFERÉú³ÉÁËÇ°ÃæÁ½ÏîµÄredoÐÅÏ¢;
4.ÒÀÀµÓÚÇ°ÈýÏî²úÉúµÄÊý¾ÝÁ¿´óСÒÔ¼°²Ù×÷ÐèÒªµÄʱ¼ä£¬bufferÖеÄÊý¾Ý¿ÉÄÜÒѾ
ÓÐÒ»²¿·ÖÊä³öµ½ÁË´ÅÅÌ£»
5.ËùÓÐÐèÒªµÄËøÒѾ»ñµÃ£»
µ±Ö´ÐÐCOMMITÃüÁîʱ£¬Ö»Ö´ÐÐÈçϲÙ×÷£º
1.ΪÊÂÎñÉú³ÉSCN£ºSCNÊÇORACLEÊý¾Ý¿âµÄÒ»ÖÖ¼ÆʱÐÅÏ¢£¬ÓÃÒÔ±£Ö¤ÊÂÎñµÄ˳ÐòÐÔ£¬
ͬʱ»¹ÓÃÓÚʧ°Ü»Ö¸´ºÍ±£Ö¤Êý¾Ý¿âµÄ¶ÁÒ»ÖÂÐԺͼì²éµã£¬ÎÞÂÛºÎʱºÎÈËÌá½»£¬SCN
×Ô¶¯¼Ó1£»
2.½«ÊÂÎñÏà¹ØµÄδдÈëredo log fileÖеÄredoÐÅÏ¢´Óredo log bufferдÈëµ½redo log
file,Õâ²ÅÊÇÕæʵµÄCOMMIT£¬Õâ²½²Ù×÷Íê³É£¬ËµÃ÷ÎÒÃÇÒѾÍê³ÉCOMMIT£¬ÊÂÎñ´Ó
V$TRANSACTIONÖÐÒƳý£»
3.V$LOCKÖмǼµÄSESSION¹ØÓÚ¸ÃÊÂÎñµÄËø»áÊÍ·Å£¬ÆäËûÐèÒªÕâЩËøµÄÊÂÎñ±»»½ÐÑ£»
4.Ö´ÐпéÇåÀí£¬ÇåÀí¿éÍ·±£´æµÄÊÂÎñÐÅÏ¢£»
Ïà¹ØÎĵµ£º
°²×°¸ÅÊö
±¾Æª½éÉÜÈçºÎ°²×°OracleÈí¼þ£¬Òª°²×°OracleÈí¼þÍƼöʹÓÃOracleͨÓð²×°¡£OracleͨÓð²×°³ÌÐòÊÇÒ»¸öͼÐÎÓû§½çÃ棨GUI£©¹¤¾ß£¬Ê¹Äú¿ÉÒԲ鿴OracleÈí¼þÒÑÔÚ¼ÆËã»úÉÏ°²×°»ò°²×°ÐµÄOracleÈí¼þ£¬²¢Ð¶ÔØOracleÈí¼þ£¬ÒÔϽ«ÐÖúÄúÍê³É°²×°¹ý³Ì¡£
¼ì²éÏȾöÌõ¼þ
°²×°³ÌÐò֮ǰ£¬Oracle¹«Ë¾Ö´ÐÐÒ»¸öÏȾöÌõ¼þ¼ì²éµÄ×Ô¶¯±àº ......
²»¿ÉÒÔÓñ£Áô×Ö×öΪ±íÃû£¬×Ö¶ÎÃûµÄ¡£
Èç¹ûÓõ¥¸öÓ¢Óïµ¥´Ê»ò´Ê×éÀ´±íʾ±íÃû»ò×Ö¶ÎÃû¡£Õâ±È½ÏÈÝÒ׺ͱ£Áô×Ö³åÍ»¡£ÈçºÎÖªµÀOracleÓÃÁËÄÄЩ±£Áô×ÖÄØ£¿
ϵͳ±ív$reserved_wordsÖдæ·ÅÁËËùÓеı£Áô×Ö¡£
select * from v$reserved_words;
OracleÓÐ500¸ö±£Áô×Ö£¬¼ÇסËùÓеı£Áô×ÖÓеãÀ§ÄÑ£¬Ã¿´Î¶¼²éÕÒ»áÓ°Ïìµ½¿ª·¢Ëٶȣ¬Èç ......
ÍøÉÏÓкܶà×ÊÁÏ£¬Ò²ÊDzο¼eygleµÄÎĵµ¡£
OS : Redhat AS 4 U5
DB : Oracle 10.2.0.3
1.ÐÞ¸Äjdk ÏÂÃæµÄ×ÖÌå¡£
[oracle@rac2 db_1]$ cd $ORACLE_HOME/jdk/jre/lib/
[oracle@rac2 lib]$ mv font.properties font.properties_bak
[oracle@rac2 lib]$
[oracle@rac2 lib]$ cp font.properties.zh_CN.Redhat font.propertie ......
»ù±¾´ÓÀ´²»ÓÃleft/right join
Ò»¸öÏîÄ¿±»ÆÈÒªÓñðÈËдµÄ sql
±¾´òËã¸ÄдһÏ£¬Ìá¸ßЧÂÊ
·¢ÏÖ£º
¡¾1¡¿
select * from a
left outer join b on a.id= b.id AND ...1...
where ...2...
Óë
¡¾2¡¿
select * from a , b
where a.id= b.id(+)
A ......
5.µ÷Óú¯ÊýFN_ADDONE
--------------------
SQL> SET SERVEROUTPUT ON
SQL> DECLARE CNUM NUMBER;
2 BEGIN
3 CNUM := USER1_ADB.FN_ADDONE(3);
4 DBMS_OUTPUT.PUT_LINE('CNUM = ' || CNUM);
5 END;
6&nbs ......