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

oracle µÄredoºÍundo

À´×Ôhttp://www.inthirties.com/thread-239-1-1.html
 ÔÚÕâÀï»á½éÉÜUNDO£¬REDOÊÇÈçºÎ²úÉúµÄ£¬¶ÔTRANSACTIONSµÄÓ°Ï죬ÒÔ¼°ËûÃÇÖ®¼äÈçºÎЭͬ¹¤×÷µÄ¡£ 
ʲôÊÇREDO 
REDO¼Ç¼transaction logs£¬·ÖΪonlineºÍarchived¡£ÒÔ»Ö¸´ÎªÄ¿µÄ¡£ 
±ÈÈ磬»úÆ÷Í£µç£¬ÄÇôÔÚÖØÆðÖ®ºóÐèÒªonline redo logsÈ¥»Ö¸´ÏµÍ³µ½Ê§°Üµã¡£ 
±ÈÈ磬´ÅÅÌ»µÁË£¬ÐèÒªÓÃarchived redo logsºÍonline redo logsÇø»Ö¸´Êý¾Ý¡£ 
±ÈÈ磬truncateÒ»¸ö±í»òÆäËûµÄ²Ù×÷£¬Ïë»Ö¸´µ½Ö®Ç°µÄ״̬£¬Í¬ÑùÒ²ÐèÒª¡£ 
ʲôÊÇUNDO 
REDOÊÇΪÁËÖØÐÂʵÏÖÄãµÄ²Ù×÷£¬¶øUNDOÏà·´£¬ÊÇΪÁ˳·ÏúÄã×öµÄ²Ù×÷£¬±ÈÈçÄãµÃÒ»¸öTRANSACTIONÖ´ÐÐʧ°ÜÁË»òÄã×Ô¼ººó»ÚÁË£¬ÔòÐèÒªÓÃROLLBACKÃüÁî»ØÍ˵½²Ù×÷֮ǰ¡£»Ø¹öÊÇÔÚÂß¼­²ãÃæÊµÏÖ¶ø²»ÊÇÎïÀí²ãÃæ£¬ÒòΪÔÚÒ»¸ö¶àÓû§ÏµÍ³ÖУ¬Êý¾Ý½á¹¹£¬blocksµÈ¶¼ÔÚʱʱ±ä»¯£¬±ÈÈçÎÒÃÇINSERTÒ»¸öÊý¾Ý£¬±íµÄ¿Õ¼ä²»¹»£¬À©Õ¹ÁËÒ»¸öеÄEXTENT£¬ÎÒÃǵÄÊý¾Ý±£´æÔÚÕâеÄEXTENTÀÆäËüÓû§ËæºóÒ²ÔÚÕâEXTENTÀï²åÈëÁËÊý¾Ý£¬¶ø´ËʱÎÒÏëROLLBACK£¬ÄÇôÏÔÈ»ÎïÀíÉϽ²ÕâEXTENT³·ÏúÊDz»¿ÉÄܵģ¬ÒòΪÕâô×ö»áÓ°ÏìÆäËûÓû§µÄ²Ù×÷¡£ËùÒÔ£¬ROLLBACKÊÇÂß¼­Éϻعö£¬±ÈÈç¶ÔINSERTÀ´Ëµ£¬ÄÇôROLLBACK¾ÍÊÇDELETEÁË¡£ 
COMMIT ÒÔǰ£¬³£Ï뵱ȻµØÈÏΪ£¬Ò»¸ö´óµÄTRANSACTION£¨±ÈÈç´óÅúÁ¿µØINSERTÊý¾Ý£©µÄCOMMIT»á»¨·Ñʱ¼ä±È¶ÌµÄTRANSACTION³¤¡£¶øÊÂʵÉÏÊÇûÓÐÊ²Ã´Çø±ðµÄ£¬ 
ÒòΪORACLEÔÚCOMMIT֮ǰÒѾ­°Ñ¸ÃдµÄ¶«Î÷дµ½DISKÖÐÁË£¬ 
ÎÒÃÇCOMMITÖ»ÊÇ 
1£¬²úÉúÒ»¸öSCN¸øÎÒÃÇTRANSACTION£¬SCN¼òµ¥Àí½â¾ÍÊǸøTRANSACTIONÅŶӣ¬ÒÔ±ã»Ö¸´ºÍ±£³ÖÒ»ÖÂÐÔ¡£ 
2£¬REDOдREDOµ½DISKÖУ¨LGWR£¬Õâ¾ÍÊÇlog file sync£©£¬¼Ç¼SCNÔÚONLINE REDO LOG£¬µ±ÕâÒ»²½·¢Éúʱ£¬ÎÒÃÇ¿ÉÒÔ˵ÊÂʵÉÏÒѾ­Ìá½»ÁË£¬Õâ¸öTRANSACTIONÒѾ­½áÊø£¨ÔÚV$TRANSACTIONÀïÏûʧÁË£© 
3£¬SESSIONËùÓµÓеÄLOCK£¨V$LOCK£©±»ÊÍ·Å¡£ 
4£¬Block Cleanout£¨Õâ¸öÎÊÌâÊDzúÉúORA-01555: snapshot too oldµÄ¸ù±¾Ô­Òò£© ROLLBACK ROLLBACKºÍCOMMITÕýºÃÏà·´£¬ROLLBACKµÄʱ¼äºÍTRANSACTIONµÄ´óСÓÐÖ±½Ó¹ØÏµ¡£ÒòΪROLLBACK±ØÐëÎïÀíÉϻָ´Êý¾Ý¡£COMMITÖ®ËùÒԿ죬ÊÇÒòΪORACLEÔÚCOMMIT֮ǰÒѾ­×÷Á˺ܶ๤×÷£¨²úÉúUNDO£¬ÐÞ¸ÄBLOCK£¬REDO£¬LATCH·ÖÅ䣩£¬ 
ROLLBACKÂýÒ²ÊÇ»ùÓÚÏàͬµÄÔ­Òò¡£ 
ROLLBACK»á 
1£¬»Ö¸´Êý¾Ý£¬DELETEµÄ¾ÍÖØÐÂINSERT£¬INSERTµÄ¾ÍÖØÐÂDELETE£¬UPDATEµÄ¾ÍÔÙUP


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracleÊý¾Ý¿âÀïÃæcommit¹Ø¼ü×ÖµÄʹÓÃ

    ÔÚoracleÊý¾Ý¿âÖвåÈëÊý¾Ýʱ£¬ÔËÐвåÈëÓï¾ä£¬ÏÈÊǰÑÊý¾Ý·ÅÈëµ½»º´æÖУ¬ÕâʱÊý¾Ý²¢Ã»ÓÐÕæÕýµÄ½øÈëÊý¾Ý¿â£¬ÕâÊÇoracleÊý¾Ý¿â¸úÆäËüÊý¾Ý¿âÖеIJ»Í¬µã£¬ÕâÊÇÒªÔËÐÐcommitÕâ¸öÊÂÎñÌá½»£¬²ÅÄÜÕæÕýµÄ°ÑÊý¾Ý·Åµ½Êý¾Ý¿âÖС£ ......

WINFORM+Oracle¿Í»§¶Ë²¼Êð

×¢£ºÏÂÃæÖ»ÊÇÎÒ´ÖÁӵļǼһÏ£¬×Ô¼ºÔÚ¿ª·¢ÖÐËùѧµÄÒ»²¿·Ö×ÊÁÏ£¡
1£®  µÚÒ»¡¢ÊÇÏÂÔØÒ»¸ö“Oracle9i¿Í»§¶Ë¾«¼ò°æ.exe”¿Í»§¶Ë£¬È»ºó°ÑËü°²×°µ½CÅÌÏÂÃæ¡£
È»ºó°ÑÎÒÃÇ×Ô¼ºÅäÖúõĔ tnsnames.ora”Îļþ£¬¸´¸ÇC:\oracle\ora90\network\adminÏÂÃæµÄtnsnames.oraÎļþ¡£
2£®  ÔÚVS2005¿ª·¢¹¤¾ßÖ ......

Oracle¹ÜÀíÓëά»¤.ÊÖ¹¤´´½¨Êý¾Ý¿âÒÔ¼°½Å±¾

 Oracle¹ÜÀíÓëά»¤.ÊÖ¹¤´´½¨Êý¾Ý¿âÒÔ¼°½Å±¾
ת×Ô ²Ýľ¹Ï
Ò»¡¢Ç°ÑÔ
 ËµÊµ»°£¬ÔçÒÑÑá¾ëÁËʹÓÃdbcaµÄ´´½¨Êý¾Ý¿â£¬´ó¸Å±È½ÏÓеã×÷ÓõÄÊÇ¿ÉÒÔÉú³É´´½¨½Å±¾°Õ¡£
¡¶Oracle¹ÜÀíÓëά»¤.°²×°´´½¨Æô¶¯¹Ø±ÕÊý¾Ý¿âµÄ³£¼ûÎÊÌâ(Ò»)¡·(Èý¡¢´´½¨Êý¾Ý¿â)Ò»ÎÄÖÐÓÐËùÌá¼°¡£±¾ÎÄÖ÷Òª¾ÍÊÇÏêÊöÊÖ
¹¤Ê¹Óýű¾´´½¨Oracle 10gÊý¾Ý¿â¡£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ