Oracle LATCHѧϰ
latchÊÇÓÃÓÚ±£»¤Äڴ棨ϵͳȫ¾ÖÇø£¬SGA£©ÖеĹ²ÏíÄÚ´æ½á¹¹µÄ»¥³â»úÖÆ¡£Latch¾ÍÏñÊÇÄÚ´æÉϵÄËø£¬¿ÉÒÔÓÉÒ»¸ö½ø³Ì·Ç³£¿ìËٵؼ¤»îºÍÊÍ·Å£¬ÓÃÓÚ·ÀÖ¹¶ÔÒ»¸ö¹²ÏíÄÚ´æ½á¹¹½øÐв¢ÐзÃÎÊ¡£Èç¹ûlatch²»¿ÉÓã¬ÄÇô½«¼Ç¼latchÊÍ·Åʧ°Ü¡£¾ø´ó¶àÊýlatchÎÊÌⶼÓëûÓÐʹÓð󶨱äÁ¿£¨library-cache latch£¨¿â»º´ælatch£©£©¡¢ÖØ×öÈÕÖ¾Éú³ÉÎÊÌ⣨redo-allocation latch£¨ÖØ×öÈÕÖ¾µÄ·ÖÅälatch £©£©¡¢»º´æ¾ºÕùÎÊÌ⣨cache-buffers LRU-chain latch£¨»º´æµÄ×î½ü×îÉÙʹÓÃÁ´latch£©£©¼°»º´æÖеÄÈȿ飨cache-buffers chain latch£¨»º´æÁ´latch£©£©Óйء££¨ÓÐЩlatchµÈ´ýÊÇÓÉÓÚ²úÆ·bugÒýÆðµÄ£¬Èç¹ûÊÇÕâÖÖÇé¿ö£¬Çë²é¿´Oracle SupportµÄMetaLinkÕ¾µã¡££©µ±latchʧ°ÜÂÊ´óÓÚ0.5%ʱ£¬¾ÍÓ¦¸Ã¶ÔÕâÒ»ÎÊÌâ½øÐÐÑо¿¡££¨ÏÂÃæÄ㽫Á˽⵽ÈçºÎÈ·¶¨latchʧ°ÜÂÊ¡££©
latchÓÐÁ½ÖÖÀàÐÍ£º
Ô¸ÒâµÈ´ýµÄ£¨willing-to-wait£©latch
²»Ô¸ÒâµÈ´ýµÄ£¨not-willing-to-wait£©latch
µÚÒ»ÖÖÔ¸ÒâµÈ´ýÒ»¸ölatchÖ±µ½Ëü¿ÉÓ㬵ڶþÖÖ²»Ô¸ÒâµÈ´ý¡£
µ±Ò»¸öÔ¸ÒâµÈ´ýµÄlatch£¨ÀýÈ磬library cache latch£©ÊÔͼ»ñµÃÒ»¸ölatchµ«Ã»ÓÐlatch¿ÉÓÃʱ£¬Ëü½«½øÐÐ×ÔÐý£¨µÈ´ý£©£¬È»ºóÔÙ´ÎÇëÇólatch¡£¸Ãlatch½«¼ÌÐøÖظ´ÕâÒ»¹ý³Ì£¬Ö±µ½×ÔÐý£¨spin£©´ÎÊý´ïµ½Ã»ÓÐÕýʽÎĵµµÄ³õʼ»¯²ÎÊý_SPIN_COUNT¡£Èç¹ûËüÔÚ×ÔÐý´ÎÊý´ïµ½_SPIN_COUNTÖ®ºó£¬»¹Ã»Óеõ½latch£¬Ëü½«½øÈë˯Ãߣ¬È»ºóÔÚÒ»ÀåÃ루°Ù·ÖÖ®Ò»Ã룩֮ºóËÕÐÑ¡£ÔÚÔٴοªÊ¼Ö®Ç°£¬¸Ãlatch½«µÚ¶þ´Î½øÐÐÕâ¸ö¹ý³Ì£¬Ö»²»¹ý×ÔÐý´ÎÊý´ïµ½_SPIN_COUNTÖ®ºó˯ÃßÁ½±¶³¤µÄʱ¼ä£¨¼´¶þÀåÃ룩¡£Õâ¸ö¹ý³ÌÖ®ºó£¬Ëüÿ´ÎµÄ˯Ãßʱ¼ä½«³É±¶Ôö¼Ó£¬Ö±µ½»ñµÃlatchΪֹ¡£¸Ãlatchÿ´Î˯Ãßʱ£¬¶¼´´½¨Ò»¸ölatch˯Ãߵȴý¡£
¶øһЩlatchÈ´²»Ô¸ÒâµÈ´ý¡£ÕâÖÖÀàÐ͵Älatch£¨ÀýÈ磬redo-copy latch£¨ÖØ×öÈÕÖ¾µÄ¸´ÖÆlatch£©£©²»µÈ´ý£¬¶øÊÇÁ¢¼´Ôٴγ¢ÊÔ»ñÈ¡latch¡£
²é¿´Á½ÖÖlatchµÄÏà¹ØÐÅÏ¢
Äã¿ÉÒÔÔÚV$LATCHÊÓͼµÄimmediate_gets ºÍimmediate_missesÁÐÀï²é¿´Ô¸ÒâµÈ´ýµÄlatchºÍ²»Ô¸ÒâµÈ´ýµÄlatchµÄÏà¹ØÐÅÏ¢£¬ÄãÒ²¿ÉÒÔÔÚStatspack±¨¸æµÄlatch²¿·Ö²é¿´ÕâЩÐÅÏ¢¡£
ͨ¹ý²éѯV$LATCH ÊÔͼ»ò²é¿´Statspack±¨¸æµÄlatch»î¶¯²¿·Ö£¬ÄãÄܹ»¿´µ½ÓжàÉÙ½ø³Ì±ØÐëµÈ´ý£¨latchʧ°Ü£©»ò˯Ãߣ¨latch˯Ãߣ©¼°ËûÃDZØÐë˯ÃߵĴÎÊý¡£V$LATCHHOLDER¡¢V$LATCHNAMEºÍV$LATCH_CHILDREN¶ÔÑо¿latchÎÊÌâÒ²ÊÇÓаïÖúµÄ¡£
±í1ÏÔʾÁËStatspack±¨¸æÖÐlatch»î¶¯²¿·ÖµÄ²¿·ÖÇåµ¥£¬Statspack±¨¸æÃè
Ïà¹ØÎĵµ£º
Ò»¡¢$vi $ORACLE_HOME/network/admin/sqlnet.ora
Èç¹û¸Ãsqlnet.oraÎļþ²»´æÔÚ£¬¿ÉÒÔ²ÉÓÃÈçÏ·½Ê½Éú³É
1£©¿ÉÒÔ¿½±´$ORACLE_HOME/network/admin/samples/sqlnet.oraµ½$ORACLE_HOME/network/admin/Ŀ¼ÏÂʹÓÃ
2£©Ê¹ÓÃnetca¹¤¾ß½øÐÐÅäÖã¬NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
¶þ¡¢ÉèÖûòÐ޸IJÎÊý£¨Èç¹û²ÎÊ ......
author:skatetime:2010-05-04
ÔÚÎÒÃǵÄϵͳÀ´ó¼ÒÔÚдpl/sqlʱ£¬´¦Àí¶àÌõ¼Ç¼ʱ£¬¼¸ºõ¶¼ÊÇͨ¹ýÓαêÀ´Íê³ÉµÄ£¬ÕâÑùÊǷdz£Ó°ÏìÐÔÄܵġ£ÎÒÃÇ¿ÉÒÔÓÃÅúÁ¿°ó¶¨¿ÉÒÔ´ó´óµÄ¸ÄÉÆ¡£
ÅúÁ¿°ó¶¨ÊÇoracle9iÔö¼ÓµÄÌØÐÔ£¬ÊÇÖ¸Ö´Ðе¥´Îsql²Ù×÷ÄÜ´«µÝËùÓм¯ºÏÔªËصÄÊý¾Ý¡£Í¨¹ý°ó¶¨°ó¶¨±äÁ¿¿ÉÒÔ¼«´óµÄÌá¸ßÊý¾Ý´¦ÀíËٶȣ¬Ìá¸ßÓ¦ÓÃ³Ì ......
2010Äê05ÔÂ2ºÅ |
23:59·ÖÀࣺLinux&Unix
, ¹ÜÀíά»¤
| ±à¼
| ±êÇ©£º11g
¡¢grid
±¾Îijö×Ô “inthirties£¨ÄÐ
ÈËÈýÊ®£©
”²©¿Í£¬×ªÔØÇëÎñ±Ø×¢Ã÷×÷Õߺͱ£Áô³ö´¦¡£
11gÀï³öÏÖÁËÒ»¸öнÇÉ«¡£
Oracle Grid Infrastructure
http://downlo ......
ÏÖÔÚµÄÏîÄ¿±È½Ï½ô£¬¼ÓÉÏ×Ô¼ºÒ²±È½ÏÀÁ£¬ÊµÔÚÊǓûʱ¼ä”д°¡£¬ºÇºÇ£¬×òÌì¿´µ½Ò»ÆªÍ¦ºÃµÄOracle´æ´¢¹ý³ÌµÄÀý×Ó£¬ÕýºÃ×î½üÒªÓã¬×ª¹ýÀ´´ó¼ÒÒ»Æð·ÖÏíһϣ¬Ð»Ð»£¨³¿¹âӳϼ£©£¬Ô×÷µØÖ·£ºhttp://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx¡£
--------------------×Ô¶¨Ò庯Êý¿ªÊ¼--------------------
......