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

ORACLE UNDO ¡¶ÉîÈëdz³öORACLEµÚÆßÕ¡·

Èç¹û˵RedoÊÇÓÃÀ´±£Ö¤ÔÚ¹ÊÕÏʱÊÂÎñ¿ÉÒÔ±»»Ö¸´£¬ÄÇôUndoÔòÊÇÓÃÀ´±£Ö¤ÊÂÎñ¿ÉÒÔ±»»ØÍË»òÕß³·Ïú¡£
ÔÚÐ޸IJÙ×÷ÖУ¬¶ÔÓÚ»ØÍ˶εIJÙ×÷´æÔÚ¶à´¦£¬ÔÚÊÂÎñ¿ªÊ¼Ê±£¬Ê×ÏÈÐèÒªÔڻعö¶Î±í¿Õ¼ä»ñµÃÒ»¸öÊÂÎñ²Û£¬·ÖÅä¿Õ¼ä£¬È»ºó´´½¨Ç°¾µÏñ£¬´ËºóÊÂÎñµÄÐ޸IJÅÄܽøÐУ¬Oracle±ØÐëÒÔ´ËÀ´±£Ö¤ÊÂÎñÊÇ¿ÉÒÔ»ØÍ˵ġ£
Èç¹ûÓû§Ìá½»ÁËÊÂÎñ£¬Oracle»áÔÚÈÕÖ¾Îļþ¼Ç¼Ìá½»£¬²¢ÇÒд³öÈÕÖ¾£¬Í¬Ê±»áÔڻعö¶ÎÖаѸÃÊÂÎñ±ê¼ÇΪÒÑÌá½»£»Èç¹ûÓû§»Ø¹öÊÂÎñ£¬ÔòOracleÐèÒª´Ó»Ø¹ö¶Î°Ñǰ¾µÏñÊý¾Ý¶ÁÈ¡³öÀ´£¬ÐÞ¸ÄÊý¾Ý»º³åÇø£¬Íê³É»Ø¹ö£¬Õâ¸ö¹ý³Ì±¾ÉíÒ²Òª²úÉúRedo£¬ËùÒÔ»ØÍËÕâ¸ö²Ù×÷ÊǺܰº¹óµÄ¡£
ÔÚOracleÐÔÄÜÓÅ»¯ÖУ¬ÓÐÒ»¸öÐÔÄÜÖ¸±ê³ÆÎªÆ½¾ùÊÂÎñ»Ø¹öÂÊ£¨Rollback per transaction£©£¬ÓÃÀ´ºâÁ¿Êý¾Ý¿âµÄÌá½»Óë»Ø¹öЧÂÊ¡£¿ÉÒÔÔÚStatspackÖÐÕÒµ½Õâ¸öÖ¸±ê¡£
¸Ã²ÎÊý¼ÆË㹫ʽΪ£º
Round(User rollbacks/(user commits+user rollbacks),4)*100%
ÆäÖÐuser commitsºÍuser rollbacksÊý¾ÝÀ´×ÔϵͳµÄͳ¼ÆÐÅÏ¢£¬¿ÉÒÔ´Óv$sysstatÊÓͼÖеõ½£¬
SQL> select name,value from v$sysstat
 2 where name in ('user commits','user rollbacks');
 
NAME                                                                 VALUE
---------------------------------------------------------------- ----------
user commits                                                             5
user rollbacks                                  


Ïà¹ØÎĵµ£º

OracleºÍMSSQLÖÐÑ­»·µÄʹÓÃ


 ORACLE
CREATE OR REPLACE FUNCTION SETSTATE(OLDVALUE VARCHAR2, POS NUMBER, SVALUE VARCHAR2)
RETURN VARCHAR2
IS
RETURN_VALUE VARCHAR2 (20);
LEN NUMBER(8);
I NUMBER(8);
TEMP_VALUE VARCHAR2(1);
BEGIN
     LEN := LENGTH(OLDVALUE);
     IF POS > ......

OracleÖÐͳ¼ÆÆõºÏijÁÐÌõ¼þµÄÁÐ×ܺÍ

 ×î½üÔÚÏîÄ¿±¨±íÖÐÐèÒªÒ»¸ö²éѯÓï¾ä£¬ÓÃÀ´Í³¼Æ·ûºÏijһÁÐÌõ¼þµÄÆäËü¼¸ÁеĸöÊý
    ±ÈÈçÓÐÏÂÃæÒ»¸ö±í½á¹¹£º
   
    ÐèÒªÔÚÁÐDºóÃæÔö¼ÓÒ»ÁУ¬Í³¼ÆÔÚÁÐA²»Îª¿Õ£¬²¢ÇÒÁÐB¡¢C¡¢D²»Îª¿ÕµÄ¸öÊý
    ¾­¹ý×Ô¼ºÊÔÑ飬²éÕÒ°ïÖú£¬×ÜËãʵÏÖÁËÉÏÃæµÄ²éѯ¡£
&nb ......

Oracle Latch¼°latchì¶Ü

 Ð¡Òý
Oracle RdbmsÊ©ÓÃÁ˸÷ÖÖ²»Í¬ÀàÐ͵ÄËø¶¨»úÖÆ£¬latchµÈÓÚ´ËÖеÄÒ»ÖÖ£¬ÕýÎĽ«¼¯ÖÐÒý¼ûlatch(ãÅ)µÄ¸ÅÄ¶®µÃlatchµÄ¶ÒÏÖ²½Ö貢˵Ã÷»½ÆðlatchĦ²ÁµÄÔµ¹Ê¡£
ʲôÊÇlatch
LatchÊÇÓÃÀ´±£»¤SGAÇøÖй²ÏíÊý¾Ý½á¹¹µÄÒ»ÖÖ´®Ðл¯Ëø¶¨»úÖÆ¡£LatchµÄ¶ÒÏÖÊÇÓë²Ù×÷ϵͳÏà¸ÉµÄ£¬ÓÈÉõºÍÒ»¸ö¹ý³ÌÊDz»ÊÇØ½ÐèµÈºòÒ»¸ölatch¡¢¼±ÐèµÈº ......

ORACLE REDO ¡¶ÉîÈëdz³öORACLEµÚÁùÕ¡·

RedoµÄÄÚÈÝ
Oracleͨ¹ýRedoÀ´ÊµÏÖ¿ìËÙÌá½»£¬Ò»·½ÃæÊÇÒòΪRedo Log File¿ÉÒÔÁ¬Ðø¡¢Ë³ÐòµØ¿ìËÙд³ö£¬ÁíÒ»¸ö·½ÃæÒ²ºÍRedo¼Ç¼µÄ¾«¼òÄÚÈÝÓйء£
Á½¸ö¸ÅÄ
¸Ä±äÏòÁ¿£¨Change Vector£©
¸Ä±äÏòÁ¿±íʾ¶ÔÊý¾Ý¿âÄÚijһ¸öÊý¾Ý¿éËù×öµÄÒ»´Î±ä¸ü¡£¸Ä±äÏòÁ¿Öаüº¬Á˱ä¸üµÄÊý¾Ý¿éµÄ°æ±¾ºÅ¡¢ÊÂÎñ²Ù×÷´úÂë¡¢±ä¸ü´ÓÊôÊý¾Ý¿éµÄµØÖ·£¨DBA£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ