Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

LinuxÏÂoracle 10g ÖйرÕÊý¾Ý¿â´íÎó

 Ò»´ÎÆæ¹ÖµÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ¾­Àú¡£
SQL> conn / as sysdba
Connected to an idle instance.
SQL> shutdown immediate
ORA-24324: service handle not initialized
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> conn / as sysdba
Co ......

±È½ÏSQL ServerÓëOracle DB2

 ¿ª·¢Êý¾Ý¿âÓ¦Óã¬Ñ¡ÔñÒ»¸öºÃµÄÊý¾Ý¿âÊǷdz£ÖØÒªµÄ¡£±¾ÎÄ´ÓһЩ·½Ãæ±È½ÏÁËSQL ServerÓëOracle¡¢DB2ÈýÖÖÊý¾Ý¿â£¬ÎªÄãÑ¡ÔñÊý¾Ý¿âÌṩһЩ²Î¿¼¡£
¡¡¡¡
¡¡¡¡¿ª·ÅÐÔ
¡¡¡¡SQL Server
¡¡¡¡Ö»ÄÜÔÚWindows ÉÏÔËÐУ¬Ã»ÓÐË¿ºÁµÄ¿ª·ÅÐÔ£¬²Ù×÷ϵͳµÄϵͳµÄÎȶ¨¶ÔÊý¾Ý¿âÊÇÊ®·ÖÖØÒªµÄ¡£Windows9XϵÁвúÆ·ÊÇÆ«ÖØÓÚ×ÀÃæÓ¦Óã¬NT se ......

oracleµÄrank,over partitionº­ÊýʹÓÃ

 ¹Ø¼ü×Ö: º­Êýrank, over partitionʹÓÃ
ÅÅÁУ¨rank()£©º¯Êý¡£ÕâЩÅÅÁк¯ÊýÌṩÁ˶¨ÒåÒ»¸ö¼¯ºÏ£¨Ê¹Óà PARTITION ×Ӿ䣩£¬È»ºó¸ù¾ÝijÖÖÅÅÐò·½Ê½¶ÔÕâ¸ö¼¯ºÏÄÚµÄÔªËؽøÐÐÅÅÁеÄÄÜÁ¦£¬ÏÂÃæÒÔscottÓû§µÄemp±íΪÀýÀ´ËµÃ÷rank over partitionÈçºÎʹÓÃ
1£©²éѯԱ¹¤Ð½Ë®²¢Á¬ÐøÇóºÍ
select deptno,ename,sal,
sum(sal)over ......

Oracle´´½¨±í¿Õ¼ä¡¢´´½¨Óû§ÒÔ¼°ÊÚȨ¡¢²é¿´È¨ÏÞ

  
 ´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'C:\oracle\product\10.1.0\oradata\orcl\test_temp01.dbf'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
´´½¨Óû§±í¿Õ¼ä
´´½¨Óû§±í¿Õ¼ä
CREATE TABLESPACE test_data
LOGGING ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ