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

ORACLEÖÐÒ»¸öUPDATEµÄ²Ù×÷Á÷³Ì

ǰÕó×Ó¿´µ½Ò»Æª¹ØÓÚDELETE²Ù×÷µÄ¾ßÌåµÄÁ÷³Ì£¬½ñÌìÎÞÒâ¼äÓÖ¿´µ½Ò»¸öUPDATEµÄ²Ù×÷Á÷³Ì£¬Í¦ÓÐȤµÄ£¬×ª¹ýÀ´Ñ§Ï°Ñ§Ï°£¡
================================================================================
1£¬Óû§Ìá½»Ò»¸öupdateÓï¾ä
2£¬server process¼ì²éÄڴ滺´æ
      i Èç¹ûûÓÐÓÐЧÄÚ´æ¿Õ¼ä£¬Æô¶¯DBWR£¬½«»º´æÖÐδдÈë´ÅÅ̵ÄÔàÊý¾Ý¿éдÈë
      ii Èç¹ûÓÐÓÐЧ¿Õ¼ä£¬´Ó´ÅÅ̶ÁÈëÊý¾Ý
3£¬ÔÚ»º´æÄÚ¸üÐÂÊý¾Ý
    i ÉêÇëÒ»¸ö»Ø¹ö¶ÎÈë¿Ú£¬½«¾ÉÊý¾ÝдÈë»Ø¹ö¶Î
    ii ¼ÓËø¸üÐÂÊý¾Ý
    iii ²¢Í¬Ê±½«Ð޸ļǼÔÚRedo log buffer ÖÐ
4£¬Óû§Ìá½»Ò»¸öCommit
   i SCNÔö¼Ó
   ii ½«Redo log buffer дÈëRedo log file
   iii ¸æËßÓû§ CommitÍê³É


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

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

ORACLE ÄÚ´æ¹ÜÀí


Oracle 9i¶¯Ì¬SGA¹ÜÀí
ÔÚOracle 9iÖУ¬¿ÉÒÔÉèÖÃSGA_MAX_SIZE£¬¸Ã²ÎÊýÓÃÒÔ¿ØÖƸ÷»º³å³ØÊ¹ÓõÄÄÚ´æ×ܺͣ¬±¾ÖÊÉÏÊÇÔÚ½ø³ÌÖÐÔ¤ÏÈ·ÖÅäÒ»¶ÎÐéÄâµØÖ·±¸Óöø²»·ÖÅäÎïÀíÄڴ棬ĿµÄÊÇ·ÀÖ¹ºÍ½ø³Ç˽ÓеØÖ·¶ÎµÄ³åÍ»¡£
Ö»Òª×ܵÄSGAÄÚ´æÉèÖò»³¬¹ýSGA_MAX_SIZEµÄÉèÖ㬸ü¸Ä¶¼¿ÉÒÔÁ¢¼´ÉúЧ¡£ÐèҪעÒâµÄÊÇ£¬ÔÚOracle 9iR1ÖУ¬¶¯Ì¬¼õСÄÚ´ ......

oracle»ù´¡ÈëÃŽ̲Ä

 
½¨±í
create table <table_name>(
column_name1 column_type [not null] [check (expression)]
    [default value] [primary key][references <table_name>(column_name)],
column_name2 column_type [not null] [check (expression)]
    [default value] [prima ......

sqlÓï¾ä¹éÄÉ£¨oracle£©

¶ÔÈÕ³£¹¤×÷ÖÐÓõ½µÄ¸Ð¾õÓÐÓõÄsqlÓï¾ä×ö¸ö¹éÄÉ£¬ÓÃÓÚ½ñºóιÊ֪С£
*¸´ÖÆ±í£º
create table tablename  as  select * from table_src;
create table tablename  as  select * from table_src where 1 <> 1; --Ö»¸´ÖƱí½á¹¹ ......

oracleÊý¾ÝÀàÐÍnumber

OracleʹÓñê×¼¡¢¿É±ä³¤¶ÈµÄÄÚ²¿¸ñʽÀ´´æ´¢Êý×Ö¡£Õâ¸öÄÚ²¿¸ñʽ¾«¶È¿ÉÒԸߴï38λ¡£
    NUMBERÊý¾ÝÀàÐÍ¿ÉÒÔÓÐÁ½¸öÏÞ¶¨·û£¬È磺
    column NUMBER £¨ precision£¬ scale£©
    precision±íʾÊý×ÖÖеÄÓÐЧλ¡£Èç¹ûûÓÐÖ¸¶¨precisionµÄ»°£¬Oracle½«Ê¹ÓÃ38×÷Ϊ¾«¶È¡£
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ