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

ʹÓÃOracle¶ÁÁËÔàÊý¾Ý... - Oracle / »ù´¡ºÍ¹ÜÀí

°¸Àý˵Ã÷:»ð³µÆ±ÊÛÆ±ÏµÍ³
ͬʱÆô¶¯¶à¸öÏß³ÌÄ£ÄâÂòƱ
´°¿ÚÊ×ÏȲéѯ³ö»¹Ê£Óà¶àÉÙÕÅÆ±,ÅжÏÊÇ·ñ×ã¹»,ÔÙ½øÐиüвÙ×÷
ËùÒÔÊÇÒ»ÌõselectÓï¾ä,Ò»ÌõupdateÓï¾ä

ÏÖÔÚ³öÏÖµÄÎÊÌâ:
µÚÒ»¸öÈËÂòÊ×ÏȲéѯʣÓà20ÕÅ,ÂòÁË2ÕÅ,updateΪ18ÕÅ
µÚ¶þ¸öÈËÔÚupdate֮ǰ¾Í¶Á³öÁË,ËùÒÔËû¶Á³öµÄÊ£ÓàÆ±ÊýÒ²ÊÇ20ÕÅ,ÂòÁË2ÕÅ,updateΪ18ÕÅ

½á¹ûÂòÁË4ÕÅ,È·Ö»¼õÉÙÁË2ÕÅ

ÇëÎÊÈçºÎ½â¾öÕâ¸öÎÊÌâÄØ?
Õâ¸öÎҼǵÃÊÇÓóÌÐò¶ÎµÄÏß³Ìͬ²½À´½øÐпØÖƵÄ,Êý¾Ý¿â½øÐпØÖÆ,Àí½â¹ý¿ÉÒÔÓÃSELECT FOR UPDATEÀ´½øÐпØÖÆ,ʵ¼ÊûÓÐÓ¦Óùý,

ÄãµÄÒâ˼ÊÇÓÃsynchronizedÀ´¼ÓËøÊǰÉ?


ÒýÓÃ

ÊǵÄ,¼ÇµÃ»¹ÓÐÊÓÆµ×¨Ã޲Õâ¸öÀý×ÓµÄ,ORACLEÊý¾Ý¿â¶Ë¿ØÖƵϰ,
¿ÉÓÃSELECT ƱÊý FOR update½øÐмÓËø....



ÕâÑùÊÇÒ»ÖÖ½â¾öµÄ°ì·¨!ºÇºÇ

ÄÇÓÖÓиöÎÊÌâ,ÂôƱµÄʱºò¶Á²»³öÁË

SQL code:
--ʹÓÃfor updateÊÖ¹¤¼ÓËø£¬¼ÓËø³É¹¦Ôò¼ÌÐø£¬·ñÔòÖ»Äܵȴý
select name,amount from tickets where name='aaa' for update;
--ÊÛÆ±¸üÐÂ
update tickets set amount=amount-2 where name='aaa'
--Ìá½»ÊÍ·ÅËø
commit;


ÒýÓÃ

ÄÇÓÖÓиöÎÊÌâ,ÂôƱµÄʱºò¶Á²»³öÁË


²»ÓÃfor update£¬°ÑÊÂÎñ¸ôÀë¼¶Éè³É¿É´®Ðл¯¡£
È»ºó
select ***
update ***
Á½ÕߺÏÒ»Æð¹¹³ÉÒ»ÊÂÎñ£¬
ÕâÑùÓ¦¸Ã²»»á³öÏÖÔà¶Á¡£


Õâ¸öÊÂÎñÓ¦¸Ã×㹻С£¨Ïà¹ØÓï¾äÒªÓÅ»¯£©£¬Ê±¼äºÜ¶Ì£¬²»´æÔÚ¶Á²»³öÊý¾ÝµÈ´ýºÜ³¤Ê


Ïà¹ØÎÊ´ð£º

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

OracleµÄblob×Ö¶ÎÎÊÌâ - Oracle / ¿ª·¢

²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......

oracle ¿ÉÊÓ»¯¿´±íÄÚÈÝ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ°²×°ÁËoracle 10g¾­¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......

oracle adoÁ¬½ÓÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚÁ¬½ÓÊý¾ÝԴʱ£¬Êý¾ÝÁ¬½ÓÊôÐÔÖÐÑ¡Ôñoracle provider for ole db
µ¥»÷ÏÂÒ»²½Ê±±¨´í ¡°Ìṩ³ÌÐò²»ÔÙ¿ÉÓã¬ÇëÈ·¶¨Ìṩ³ÌÐò±»ÕýÈ·°²×°¡£¡±
ÎÒÓõÄÊÇoracle 8£¬ÏÈǰÓõÄ10gÒ²Óöµ½ÀàËÆµÄÎÊÌâ
ʹÓÃmicrosoft ole db pro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ