Oracle Latch ½éÉÜ
LatchÊÇOracleÌṩµÄÇáÁ¿¼¶Ëø×ÊÔ´£¬ËûÓÃÓÚ¿ìËÙ£¬¶Ìʱ¼äµÄËø¶¨×ÊÔ´£¬·ÀÖ¹¶à¸ö²¢·¢½ø³ÌͬʱÐ޸ķÃÎÊij¸ö¹²Ïí×ÊÔ´£¬ËûÖ»¹¤×÷ÔÚÄÚ´æÖУ¬ÎÒÃÇ¿ÉÒÔ²»´ó׼ȷµÄ˵£¬ÄÚ´æÖÐ×ÊÔ´µÄËø½Ðlatch£¬Êý¾Ý¿â¶ÔÏó(±í£¬Ë÷ÒýµÈ)µÄËø½ÐLock¡£±ÈÈçÊý¾Ý»º´æÖеÄij¸ö¿éÒª±»¶ÁÈ¡£¬ÎÒÃÇ»á»ñµÃÕâ¸ö¿éµÄ latch£¬Õâ¸ö¹ý³Ì½Ð×öpin£¬ÁíÍâÒ»¸ö½ø³ÌÇ¡ºÃÒªÐÞ¸ÄÕâ¸ö¿é£¬ËûÒ²ÒªpinÕâ¸ö¿é£¬´ËʱËû±ØÐëµÈ´ý£¬µ±Ç°Ò»¸ö½ø³ÌÊÍ·Ålatchºó²ÅÄÜpinס£¬È»ºóÐ޸ģ¬Èç¹û¶à¸ö½ø³ÌͬʱÇëÇóµÄ»°£¬ËûÃÇÖ®¼ä½«³öÏÖ¾ºÕù£¬Ã»ÓÐÒ»¸öÈë¶Ó»úÖÆ£¬Ò»µ©Ç°Ãæ½ø³ÌÊÍ·ÅËù¶¨£¬ºóÃæµÄ½ø³Ì¾Í·äÓµ¶øÉÏ£¬Ã»ÓÐÏÈÀ´ºóµ½µÄ¸ÅÄÕâ¸öºÍ LockÊÇÓб¾ÖÊÇø±ðµÄ£¬ÕâÒ»Çж¼·¢ÉúµÄ·Ç³£¿ì£¬ÒòΪLatchµÄÌصãÊÇ¿ì¶ø¶ÌÔÝ£¬µ±È»Õâ¸öÖ»ÊÇ´óÖ¹ý³Ì£¬Ï¸½Ú²¿·ÖÔÚºóÃæÌÖÂÛ.
LatchºÍLockµÄÇø±ð:
¡¡¡¡1. LatchÊǶÔÄÚ´æÊý¾Ý½á¹¹Ìṩ»¥³â·ÃÎʵÄÒ»ÖÖ»úÖÆ£¬¶øLockÊÇÒÔ²»Í¬µÄģʽÀ´Ì×È¡¹²Ïí×ÊÔ´¶ÔÏ󣬸÷¸öģʽ¼ä´æÔÚ׿æÈÝ»òÅų⣬´ÓÕâµã¿´³ö£¬Latch µÄ·ÃÎÊ£¬°üÀ¨²éѯҲÊÇ»¥³âµÄ£¬ÈκÎʱºò£¬Ö»ÄÜÓÐÒ»¸ö½ø³ÌÄÜpinסÄÚ´æµÄijһ¿é£¬ÐÒºÃÕâ¸ö¹ý³ÌÊÇÏ൱µÄ¶ÌÔÝ£¬·ñÔòϵͳÐÔÄܽ«Ã»µÄ±£ÕÏ£¬ÏÖÔÚ´Ó9I¿ªÊ¼£¬ÔÊÐí¶à¸ö½ø³Ìͬʱ²éѯÏàͬµÄÄÚ´æ¿é£¬µ«ÐÔÄܲ¢Ã»ÓÐÏëÏóÖеĺá£
¡¡¡¡2. LatchÖ»×÷ÓÃÓÚÄÚ´æÖУ¬ËûÖ»Äܱ»µ±Ç°ÊµÀý·ÃÎÊ£¬¶øL ock×÷ÓÃÓÚÊý¾Ý¿â¶ÔÏó£¬ÔÚRACÌåϵÖÐʵÀý¼äÔÊÐíLock¼ì²âÓë·ÃÎÊ
¡¡¡¡3. LatchÊÇ˲¼äµÄÕ¼Óã¬ÊÍ·Å£¬LockµÄÊÍ·ÅÐèÒªµÈµ½ÊÂÎñÕýÈ·µÄ½áÊø£¬ËûÕ¼ÓõÄʱ¼ä³¤¶ÌÓÉÊÂÎñ´óС¾ö¶¨
¡¡¡¡4. LatchÊÇ·ÇÈë¶ÓµÄ£¬¶øLockÊÇÈë¶ÓµÄ
5. Latch²»´æÔÚËÀËø£¬¶øLockÖдæÔÚ(ËÀËøÔÚOracleÖÐÊǷdz£ÉÙ¼ûµÄ)
¹ØÓÚlock Ëø¿ÉÒԲο¼ÎÒµÄblog£º
ORACLE Ëø»úÖÆ
http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4696896.aspx
oracle ËøÎÊÌâµÄ½â¾ö
http://blog.csdn.net/tianlesoftware/archive/2009/10/28/4733630.aspx
½ø³Ì»ñÈ¡LatchµÄÏêϸ¹ý³Ì:
ÈκÎʱºò£¬Ö»ÓÐÒ»¸ö½ø³Ì¿ÉÒÔ·ÃÎÊÄÚ´æÖеÄijһ¸ö¿é(9IÌá³öµÄLatch¹²ÏíÎÒ²»Ï뿼ÂÇ)£¬Èç¹û½ø³ÌÒòΪ±ðµÄ½ø³ÌÕýÕ¼Óÿé¶øÎÞ·¨»ñµÃLatchʱ£¬Ëû»á¶ÔCPU½øÐÐÒ»´Îspin(Ðýת)£¬Ê±¼ä·Ç³£µÄ¶ÌÔÝ£¬spin¹ýºó¼ÌÐø»ñÈ¡£¬²»³É¹¦ÈÔÈ»spin£¬Ö±µ½ spin´ÎÊýµ½´ï·§ÖµÏÞÖÆ(Õâ¸öÓÉÒþº¬²ÎÊý_spin_countÖ¸¶¨)£¬´Ëʱ½ø³Ì»áÍ£Ö¹spin,½øÐжÌÆÚµÄÐÝÃߣ¬ÐÝÃß¹ýºó»á¼ÌÐø¸Õ²ÅµÄ¶¯×÷£¬Ö±µ½»ñÈ¡¿éÉϵÄLatchΪֹ¡£½ø³ÌÐÝÃßµÄʱ¼äÒ²ÊÇ´æÔÚËã·¨µÄ£¬Ëû»áËæ×Åspi
Ïà¹ØÎĵµ£º
OracleÊý¾Ý¿âSCNºÅÏê½â:
¡¡¡¡ÏµÍ³¼ì²éµãscn(v$database(checkpoint_change#))
¡¡¡¡Êý¾ÝÎļþ¼ì²éµã(v$datafile(checkpoint_change#))
¡¡¡¡Êý¾ÝÎļþÖÕÖ¹scn(v$datafile(last_change#))
¡¡¡¡Êý¾ÝÎļþÖдæ·ÅµÄ¼ì²éµã
¡¡¡¡Æô¶¯scn (v$datafile_header(checkpoint_change#)
¡¡¡¡1¡¢ÏµÍ³¼ì²éµãscn
¡¡¡¡µ±Ò»¸ö¼ì²éµã¶¯×÷Íê³ ......
ADO ʹÓà ORACLE provider FOR OLE DB Çý¶¯Ê±
µ÷Óô洢¹ý³ÌÐèÒª·µ»ØÓαêʱ£¬ÔÚÁ¬½Ó×Ö·û´®ÖÐÔö¼Ó
PLSQLRSet=1 ²ÎÊý¡£
´æ´¢¹ý³ÌÖеÄÓα겻ÐèÒª¸¶³õʼֵ
Èç:
sp1: TADOStoredProc;
sp1.Close;
sp1.ProcedureName := 'pkg_ScanList_By_JobNo.sp_GetScanList';& ......
ת×Ô£ºhttp://blog.csdn.net/scorpio3k/archive/2009/05/09/4162079.aspx
ÔںܶàÇé¿öÏ£¬ÎÒÃÇʹÓÃHibernateÔÚÒѾ½¨Á¢ºÃÊý¾Ý¿âµÄ»ù´¡ÉÏ¡£ÔÚoracleÖУ¬Èç¹ûÒѾ½¨Á¢ºÃµÄÊý¾Ý¿âÖÐʹÓÃÁËsequence
,Ôò¿ÉÒÔ°´ÕÕÏÂÃæµÄ²½Öè°ÑËüÒýÈëµ½HibernateÖУº
1¡¢ÔÚoracle Ê×ÏÈ´´½¨sequence
......
####################################
# TNSNAMES.ORA Configuration File:D:\Oracle_now\NETWORK\ADMIN\tnsnames.ora ÎļþλÖÃ
# Generated by Oracle Enterprise Manager V2
# Date..........: Tue Jan 26 20:05:00 CST 2010
####################################
TEST1.TCSGEGDC.COM =
(DESCRIPTION =
& ......