Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Êý¾Ý×Öµä

²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
 SQL>select username,default_tablespace from user_users;
        ²é¿´µ±Ç°Óû§µÄ½ÇÉ«
        SQL>select * from user_role_privs;
        ²é¿´µ±Ç°Óû§µÄÏµÍ³È ......

·ÃÎÊoracleÊý¾Ý¿â

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 ......

OracleÏÞÖÆIP·ÃÎÊÉèÖÃ

Ò»¡¢$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 ¿ØÖÆÎļþ


Ò». 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 ......

OracleÁÙʱ±í

Temporary TablesÁÙʱ±í
1¼ò½é
   ORACLEÊý¾Ý¿â³ýÁË¿ÉÒÔ±£´æÓÀ¾Ã±íÍ⣬»¹¿ÉÒÔ½¨Á¢ÁÙʱ±ítemporary tables¡£ÕâЩÁÙʱ±íÓÃÀ´±£´æÒ»¸ö»á»°SESSIONµÄÊý¾Ý£¬
   »òÕß±£´æÔÚÒ»¸öÊÂÎñÖÐÐèÒªµÄÊý¾Ý¡£µ±»á»°Í˳ö»òÕßÓû§Ìá½»commitºÍ»Ø¹örollbackÊÂÎñµÄʱºò£¬ÁÙʱ±íµÄÊý¾Ý×Ô¶¯Çå¿Õ£¬
   µ«ÊÇÁÙʱ± ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ