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
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ò»´ÎÆæ¹ÖµÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ¾Àú¡£
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 ......
¿ª·¢Êý¾Ý¿âÓ¦Óã¬Ñ¡ÔñÒ»¸öºÃµÄÊý¾Ý¿âÊǷdz£ÖØÒªµÄ¡£±¾ÎÄ´ÓһЩ·½Ãæ±È½ÏÁËSQL ServerÓëOracle¡¢DB2ÈýÖÖÊý¾Ý¿â£¬ÎªÄãÑ¡ÔñÊý¾Ý¿âÌṩһЩ²Î¿¼¡£
¡¡¡¡
¡¡¡¡¿ª·ÅÐÔ
¡¡¡¡SQL Server
¡¡¡¡Ö»ÄÜÔÚWindows ÉÏÔËÐУ¬Ã»ÓÐË¿ºÁµÄ¿ª·ÅÐÔ£¬²Ù×÷ϵͳµÄϵͳµÄÎȶ¨¶ÔÊý¾Ý¿âÊÇÊ®·ÖÖØÒªµÄ¡£Windows9XϵÁвúÆ·ÊÇÆ«ÖØÓÚ×ÀÃæÓ¦Óã¬NT se ......
¹Ø¼ü×Ö: ºÊýrank, over partitionʹÓÃ
ÅÅÁУ¨rank()£©º¯Êý¡£ÕâЩÅÅÁк¯ÊýÌṩÁ˶¨ÒåÒ»¸ö¼¯ºÏ£¨Ê¹Óà PARTITION ×Ӿ䣩£¬È»ºó¸ù¾ÝijÖÖÅÅÐò·½Ê½¶ÔÕâ¸ö¼¯ºÏÄÚµÄÔªËؽøÐÐÅÅÁеÄÄÜÁ¦£¬ÏÂÃæÒÔscottÓû§µÄemp±íΪÀýÀ´ËµÃ÷rank over partitionÈçºÎʹÓÃ
1£©²éѯԱ¹¤Ð½Ë®²¢Á¬ÐøÇóºÍ
select deptno,ename,sal,
sum(sal)over ......
´´½¨ÁÙʱ±í¿Õ¼ä
´´½¨ÁÙʱ±í¿Õ¼ä
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 ......