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
Ïà¹ØÎĵµ£º
ADO ʹÓà ORACLE provider FOR OLE DB Çý¶¯Ê±
µ÷Óô洢¹ý³ÌÐèÒª·µ»ØÓαêʱ£¬ÔÚÁ¬½Ó×Ö·û´®ÖÐÔö¼Ó
PLSQLRSet=1 ²ÎÊý¡£
´æ´¢¹ý³ÌÖеÄÓα겻ÐèÒª¸¶³õʼֵ
Èç:
sp1: TADOStoredProc;
sp1.Close;
sp1.ProcedureName := 'pkg_ScanList_By_JobNo.sp_GetScanList';& ......
ɾ³ýÊý¾Ý¿â£º
1¡¢Í£Ö¹Êý¾Ý¿â·þÎñ
2¡¢É¾³ýʵÀý oradim –delete –sid liluf
3¡¢É¾³ýÊý¾Ý¿âÎļþ
ÐÂÔöÊý¾Ý¿â£º
1¡¢ ½¨Á¢Êý¾Ý¿â¡¢ÅäÖüàÌý¡¢½¨Á¢Óû§
2¡¢ ÓÃÃüÁîÆô¶¯Êý¾Ý¿â
×¢:×¢²á±íregedit HKEY_LOCAL_MACHINE&sh ......
####################################
# 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 =
& ......
Ïê½éoracleµÄRBO/CBOÓÅ»¯Æ÷
OracleµÄÓÅ»¯Æ÷ÓÐÁ½ÖÖÓÅ»¯·½Ê½,¼´»ùÓÚ¹æÔòµÄÓÅ»¯·½Ê½(Rule-Based Optimization£¬¼ò³ÆÎªRBO)ºÍ»ùÓÚ´ú¼ÛµÄÓÅ»¯·½Ê½(Cost-Based Optimization£¬¼ò³ÆÎªCBO)£¬ÔÚOracle8¼°ÒÔºóµÄ°æ±¾,OracleÇ¿ÁÐÍÆ¼öÓÃCBOµÄ·½Ê½
RBO·½Ê½£ºÓÅ»¯Æ÷ÔÚ·ÖÎöSQLÓï¾äʱ,Ëù×ñѵÄÊÇOracleÄÚ²¿Ô¤¶¨µÄһЩ¹ ......