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±¨¸æÃè
Ïà¹ØÎĵµ£º
²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
SQL>select username,default_tablespace from user_users;
²é¿´µ±Ç°Óû§µÄ½ÇÉ«
SQL>select * from user_role_privs;
²é¿´µ±Ç°Óû§µÄÏµÍ³È ......
1¡£web.config ----appSettings--<add key="LimsConnection" value="data source=yzlims;user id=lims;password = lims"/>
2. c#´úÂëÖÐ
using System.Data.OracleClient;
public DataTable GetLimsTimeInSpace(string S_SAMPLE_NAME, string S_SAMPLING_P_N,Date ......
Ò»¡¢$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ÎÊý£¨Èç¹û²ÎÊ ......
Ò». Oracle ¿ØÖÆÎļþÖ÷Òª°üº¬ÈçÏÂÌõÄ¿
DATABASE ENTRY
CHECKPOINT PROGRESS RECORDS
REDO THREAD RECORDS
LOG FILE RECORDS
DATA FILE RECORDS
TEMP FILE RECORDS
TABLESPACE RECORDS
LOG FILE HISTORY RECORDS
OFFLINE RANGE RECORDS
ARCHIVED LOG RECORDS
BACKUP SET RECORDS
BACKUP PIECE RECO ......
Temporary TablesÁÙʱ±í
1¼ò½é
ORACLEÊý¾Ý¿â³ýÁË¿ÉÒÔ±£´æÓÀ¾Ã±íÍ⣬»¹¿ÉÒÔ½¨Á¢ÁÙʱ±ítemporary tables¡£ÕâЩÁÙʱ±íÓÃÀ´±£´æÒ»¸ö»á»°SESSIONµÄÊý¾Ý£¬
»òÕß±£´æÔÚÒ»¸öÊÂÎñÖÐÐèÒªµÄÊý¾Ý¡£µ±»á»°Í˳ö»òÕßÓû§Ìá½»commitºÍ»Ø¹örollbackÊÂÎñµÄʱºò£¬ÁÙʱ±íµÄÊý¾Ý×Ô¶¯Çå¿Õ£¬
µ«ÊÇÁÙʱ± ......