ÇëÎÊÈçºÎ½â¾öÕâ¸öÎÊÌâÄØ?Õâ¸öÎҼǵÃÊÇÓóÌÐò¶ÎµÄÏß³Ìͬ²½À´½øÐпØÖƵÄ,Êý¾Ý¿â½øÐпØÖÆ,Àí½â¹ý¿ÉÒÔÓÃSELECT FOR UPDATEÀ´½øÐпØÖÆ,ʵ¼ÊûÓÐÓ¦Óùý, ÄãµÄÒâ˼ÊÇÓÃsynchronizedÀ´¼ÓËøÊǰÉ?
ÕâÑùÊÇÒ»ÖÖ½â¾öµÄ°ì·¨!ºÇºÇ ÄÇÓÖÓиöÎÊÌâ,ÂôƱµÄʱºò¶Á²»³öÁË SQL code: --ʹÓÃfor updateÊÖ¹¤¼ÓËø£¬¼ÓËø³É¹¦Ôò¼ÌÐø£¬·ñÔòÖ»Äܵȴý select name,amount from tickets where name='aaa' for update; --ÊÛÆ±¸üРupdate tickets set amount=amount-2 where name='aaa' --Ìá½»ÊÍ·ÅËø commit;
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......