ORACLE REDO ¡¶ÉîÈëdz³öORACLEµÚÁùÕ¡·
RedoµÄÄÚÈÝ
Oracleͨ¹ýRedoÀ´ÊµÏÖ¿ìËÙÌá½»£¬Ò»·½ÃæÊÇÒòΪRedo Log File¿ÉÒÔÁ¬Ðø¡¢Ë³ÐòµØ¿ìËÙд³ö£¬ÁíÒ»¸ö·½ÃæÒ²ºÍRedo¼Ç¼µÄ¾«¼òÄÚÈÝÓйء£
Á½¸ö¸ÅÄ
¸Ä±äÏòÁ¿£¨Change Vector£©
¸Ä±äÏòÁ¿±íʾ¶ÔÊý¾Ý¿âÄÚijһ¸öÊý¾Ý¿éËù×öµÄÒ»´Î±ä¸ü¡£¸Ä±äÏòÁ¿Öаüº¬Á˱ä¸üµÄÊý¾Ý¿éµÄ°æ±¾ºÅ¡¢ÊÂÎñ²Ù×÷´úÂë¡¢±ä¸ü´ÓÊôÊý¾Ý¿éµÄµØÖ·£¨DBA£©ÒÔ¼°¸üкóµÄÊý¾Ý¡£ÀýÈ磺һ¸öupdateÊÂÎñ°üº¬Ò»ÏµÁеĸıäÏòÁ¿£¬¶ÔÓÚÊý¾Ý¿éµÄÐÞ¸ÄÊÇÒ»¸öÏòÁ¿£¬¶ÔÓڻعö¶ÎµÄÐÞ¸ÄÓÖÊÇÒ»¸öÏòÁ¿¡£
ÖØ×ö¼Ç¼£¨Redo Record£©
ÖØ×ö¼Ç¼ͨ³£ÓÉÒ»×é¸Ä±äÏòÁ¿×é³É£¬ÊÇÒ»¸ö¸Ä±äÏòÁ¿µÄ¼¯ºÏ£¬´ú±íÒ»¸öÊý¾Ý¿âµÄ±ä¸ü£¨INSERT¡¢UPDATE¡¢DELETEµÈ²Ù×÷£©£¬¹¹³ÉÊý¾Ý¿â±ä¸üµÄ×îС»Ö¸´µ¥Î»¡£ÀýÈ磺һ¸öUpdateµÄÖØ×ö¼Ç¼°üÀ¨ÏàÓ¦µÄ»Ø¹ö¶ÎµÄ¸Ä±äÏòÁ¿ºÍÏàÓ¦µÄÊý¾Ý¿éµÄ¸Ä±äÏòÁ¿µÈ¡£
¼Ù¶¨·¢³öÒ»¸ö¸üÐÂÓï¾ä£º
Update emp set sal=4000 where empno=7788;
Õâ¸öÓï¾äµÄÖ´ÐÐÈçÏÂËùʾ£º
¼ì²éempno=7788¼Ç¼ÔÚBuffer CacheÖÐÊÇ·ñ´æÔÚ£¬Èç¹û²»´æÔÚÔò¶ÁÈ¡µÀBuffer CacheÖУ»
Ôڻعö¶Î±í¿Õ¼äµÄÏàÓ¦»Ø¹ö¶ÎÊÂÎñ±íÉÏ·ÖÅäÊÂÎñ²Û£¬Õâ¸ö²Ù×÷ÐèÒª¼Ç¼RedoÐÅÏ¢£»
´Ó»Ø¹ö¶Î¶ÁÈë»òÕßÔÚBuffer CacheÖд´½¨sal=3000µÄÇ°¾µÏñ£¬ÕâÐèÒª²úÉúRedoÐÅÏ¢²¢¼ÇÈëRedo Log Buffer£»
ÐÞ¸Äsal=4000£¬ÕâÊÇupdateµÄÊý¾Ý±ä¸ü£¬ÐèÒª¼ÇÈëRedo Log Buffer;
µ±Óû§Ìύʱ£¬»áÔÚRedo Log Buffer¼Ç¼Ìá½»ÐÅÏ¢£¬²¢Ôڻعö¶Î±ê¼Ç¸ÃÊÂÎñΪ·Ç¼¤»î¡£
¶ÔÓÚÊý¾Ý¿éµÄÐ޸ģ¬Èç¹ûÖ´ÐÐд³ö£¬ÄÇôͨ³£ÐèҪд³ö8KBµÄBlock£¬¶ø¶ÔÓÚRedoÈÕÖ¾À´Ëµ£¬ÖØ×öÐÅϢȴÏ൱¾«¼ò£¬OracleÖ»ÐèÒª¼Ç¼ÄÇЩÖع¹ÊÂÎñ±ØÐëµÄÐÅÏ¢£¨ÈçÊÂÎñºÅ¡¢ÎļþºÅ¡¢¿éºÅ¡¢Ðкš¢×ֶεȣ©¼´¿É£¬Õâ¸öÊý¾ÝÁ¿´ó´ó¼õÉÙ¡£
²úÉú¶àÉÙRedo
ÔÚSQL*PlusÖÐʹÓÃautotrace¹¦ÄÜ
µ±ÔÚSQL*PlusÖÐÆôÓÃautotrace¸ú×Ùºó£¬ÔÚÖ´ÐÐÁËÌض¨µÄDMLÓï¾äʱ£¬Oracle»áÏÔʾ¸ÃÓï¾äµÄͳ¼ÆÐÅÏ¢£¬ÆäÖУ¬Redo sizeÒ»À¸±íʾµÄ¾ÍÊǸòÙ×÷²úÉúµÄRedoµÄÊýÁ¿£º
SQL> set autotrace trace stat
SQL> insert into test
2 select empno,ename from scott.emp;
ÒÑ´´½¨12ÐС£
Statistics
----------------------------------------------------------
189 recursive calls
2 db block gets
37 consistent gets
4 physical
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ò»¡¢×¼±¸ÌØÊâÊý¾Ý
create table t_escape(s varchar2(50));
--show define -- define "&" (hex 26)
--show escape -- escape off
set define off
set escape on
insert into t_escape values('string&text');
insert into t_escape values('string\&text');
insert into t_escape values('st ......
¶ÔÓÚrownumÀ´ËµËüÊÇoracleϵͳ˳Ðò·ÖÅäΪ´Ó²éѯ·µ»ØµÄÐеıàºÅ£¬·µ»ØµÄµÚÒ»ÐзÖÅäµÄÊÇ1£¬µÚ¶þÐÐÊÇ2£¬ÒÀ´ËÀàÍÆ£¬Õâ¸öα×ֶοÉÒÔÓÃÓÚÏÞÖƲéѯ·µ»ØµÄ×ÜÐÐÊý£¬¶øÇÒrownum²»ÄÜÒÔÈκαíµÄÃû³Æ×÷Ϊǰ׺¡£
¾ÙÀý˵Ã÷£º
ÀýÈç±í£ºstudent(ѧÉú)±í£¬±í½á¹¹Îª£º
ID¡¡¡¡¡¡ char(6)¡¡¡¡¡¡¡¡¡¡ --ѧºÅ
name¡¡¡¡ ......
oracle ÖÐ TO_DATE º¯ÊýµÄʱ¼ä¸ñʽ£¬ÒÔ 2008-09-10 23:45:56 ΪÀý
¸ñʽ
˵Ã÷
ÏÔʾֵ
±¸×¢
Year(Äê):
yy
two digits(Á½Î»Äê)
08
yyy
three digits(ÈýλÄê)
008
yyyy
four digits(ËÄλÄê)
2008
Month(ÔÂ):
mm
number(Á½Î»ÔÂ)
09
mon
abbre ......