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  
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ëæ׿ÆËã»úµÄÆÕ¼°ÒÔ¼°ÍøÂçµÄ·¢Õ¹£¬Êý¾Ý¿âÒѾ²»ÔÙ½ö½öÊÇÄÇЩ³ÌÐòÔ±ËùרÓеĻ°Ìâ¡£¶øOracleÊý¾Ý¿â¸üÊÇƾ½èÆäÐÔÄÜ׿Խ£¬²Ù×÷·½±ãÁé»îµÄÌص㣬ÔÚÊý¾Ý¿âµÄÊг¡ÖÐÒѾռ¾ÝÁËһϯ֮µØ¡£µ«ÊÇͬÑùËæ×ÅÍøÂç¼¼ÊõµÄ²»¶Ï½ø²½£¬Êý¾ÝÐÅÏ¢µÄ²»¶ÏÔö¼Ó£¬Êý¾Ý°²È«ÒѾ²»ÔÙÊÇÒÔÇ°µÄ“ÀÏÉú³¤Ì¸”£¬Ò²¸ü²»ÊÇÒÔÇ°Êé±¾ÉÏÄÇЩ“¿ÉÍû² ......
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖƲéѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
¾ÙÀý˵Ã÷£º
ÀýÈç±í£ºstudent(ѧÉú)±í£¬±í½á¹¹Îª£º
ID¡¡¡¡¡¡ char(6)¡¡¡¡¡¡¡¡¡¡ --ѧºÅ
name¡¡¡¡ ......
RedoµÄÄÚÈÝ
Oracleͨ¹ýRedoÀ´ÊµÏÖ¿ìËÙÌá½»£¬Ò»·½ÃæÊÇÒòΪRedo Log File¿ÉÒÔÁ¬Ðø¡¢Ë³ÐòµØ¿ìËÙд³ö£¬ÁíÒ»¸ö·½ÃæÒ²ºÍRedo¼Ç¼µÄ¾«¼òÄÚÈÝÓйء£
Á½¸ö¸ÅÄ
¸Ä±äÏòÁ¿£¨Change Vector£©
¸Ä±äÏòÁ¿±íʾ¶ÔÊý¾Ý¿âÄÚijһ¸öÊý¾Ý¿éËù×öµÄÒ»´Î±ä¸ü¡£¸Ä±äÏòÁ¿Öаüº¬Á˱ä¸üµÄÊý¾Ý¿éµÄ°æ±¾ºÅ¡¢ÊÂÎñ²Ù×÷´úÂë¡¢±ä¸ü´ÓÊôÊý¾Ý¿éµÄµØÖ·£¨DBA£ ......
ÔÚ¿ªÊ¼Ö®Ç°£¬ÎÒÃÇÏÈÀ´Ë¼¿¼¼¸¸öÎÊÌ⣿
1. ora-01555´íÎóµÄÊÇÔõô²úÉúµÄ£¿ÓÐʲô°ì·¨½â¾ö£¿
¸ÃÎÊÌ⣬²Î¿¼ÎÒµÄBlog£º Oracle ORA-01555¿ìÕÕ¹ý¾É
http://blog.csdn.net/tianlesoftware/archive/2009/10/31/4745898.aspx
2. »Ø¹ö¶Î(»Ø¹ö ......