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±¨¸æÃè
Ïà¹ØÎĵµ£º
¹ØÓÚOracleÊÂÎñµÄ×ܽá
1.ʲôÊÇÊÂÎñ£¬ÊÂÎñµÄÌØÐÔÊÇʲô£¿
ÊÂÎñµÄÈÎÎñ±ãÊÇʹÊý¾Ý¿â´ÓÒ»ÖÖ״̬±ä»»³ÉΪÁíÒ»ÖÖ״̬£¬ÕⲻͬÓÚÎļþϵͳ£¬ËüÊÇÊý¾Ý¿âËùÌØÓõġ£ËüµÄÌØÐÔÓÐËĸö£ºTOM×ܽáΪACID¼´
Ô×ÓÐÔatomicity:Óï¾ä¼¶Ô×ÓÐÔ£¬¹ý³Ì¼¶Ô×ÓÐÔ£¬ÊÂÎñ¼¶Ô×ÓÐÔ
Ò»ÖÂÐÔconsistency:״̬һÖ£¬Í¬Ò»ÊÂÎñÖв»»áÓÐÁ½ÖÖ״̬
¸ôÀëÐÔiso ......
oracle ÔõôÀ´±éÀúÒ»¸öÊ÷£¬Ïà±È½ÏÆäËû·½·¨£¬oracleµÄconnectÓï·¨¸üÄܱܺãÀûµÄ½â¾öÎÊÌâ¡£
Óï·¨¸ñʽ£º
select ...
from ...
start with...
connect by prior expr=expr
order siblings by ..
start with µÄ¹¦ÄÜÀàËÆÓÚwhere£¬Ö¸Ã÷´ÓÄĸö·ÖÖ§¿ªÊ¼±ãÀû£»
connect by Ö¸Ã÷¸¸½ÚµãºÍ×Ó½ÚµãµØÁ¬½Ó·½Ê½£¬¹Ø¼ü×Öprior·ÅÔÚ¸¸½Ú ......
¡¶oracle´óÐÍÊý¾Ý¿âϵͳÔÚAIX/unixÉϵÄʵսÏê½â¡·ÌÖÂÛ38 ¹ØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄÄÚÈݰ²ÅÅ Õâ¶Îʱ¼äÓÉÓÚһֱæÓÚÏîÄ¿£¬Ò²¾ÍÊèÓÚÔÚÈÕÖ¾ÉϺͶÁÕߵĻ¥¶¯£¬Òò´ËÓÖ»ýÔÜÏÂÈô¸É¶ÁÕßÀ´ÐÅδ»Ø£¬ÊµÔÚ±§Ç¸¡£ÆäÖÐÓм¸·âÊǹØÓÚOracleÔÚAIXÉÏʵʩÅàѵµÄ£¬ÒªÇóÎÒ¶ÔÅàѵÄÚÈݸøÓë½âÊͺÍ˵Ã÷¡£ÕâÀïÎÒ×öͳһ˵ ......
red hat linux ϰ²×° oracle 10g
racle¿¼×ÊÁÏ:
Oracle¹Ù·½ÍøÕ¾: http://download.oracle.com/docs/html/B10813_01/toc.htm
Ò»¡¢ÒÔrootÓû§µÇ¼, ½øÐÐÈçϲÙ×÷£º
1 ¼ì²éÓ²¼þÒªÇó
* Ö÷Òª°üÀ¨£º
********************************************************************
* ÄÚ´æ: & ......