oracle lockmode
ORACLEÀïËøÓÐÒÔϼ¸ÖÖģʽ:
0£ºnone
1£ºnull ¿Õ
e.g. 1¼¶ËøÓУºSelect£¬ÓÐʱ»áÔÚv$locked_object³öÏÖ¡£
2£ºRow-S Ðй²Ïí(RS)£º¹²Ïí±íËø£¬sub share
e.g. 2¼¶ËøÓУºSelect for update,Lock For Update,Lock Row Share
select for updateµ±¶Ô»°Ê¹ÓÃfor update×Ó´®´ò¿ªÒ»¸öÓαêʱ£¬ËùÓзµ
»Ø¼¯ÖеÄÊý¾ÝÐж¼½«´¦ÓÚÐм¶(Row-X)¶ÀÕ¼Ê½Ëø¶¨£¬ÆäËû¶ÔÏóÖ»Äܲé
ѯÕâЩÊý¾ÝÐУ¬²»ÄܽøÐÐupdate¡¢delete»òselect for update²Ù×÷¡£
3£ºRow-X ÐжÀÕ¼(RX)£ºÓÃÓÚÐеÄÐ޸ģ¬sub exclusive
e.g.3¼¶ËøÓУºInsert, Update, Delete, Lock Row Exclusive
ûÓÐcommit֮ǰ²åÈëͬÑùµÄÒ»Ìõ¼Ç¼»áûÓз´Ó¦, ÒòΪºóÒ»¸ö3µÄËø»áÒ»Ö±µÈ´ýÉÏÒ»¸ö3µÄËø, ÎÒÃDZØ
ÐëÊͷŵôÉÏÒ»¸ö²ÅÄܼÌÐø¹¤×÷¡£
4£ºShare ¹²ÏíËø(S)£º×èÖ¹ÆäËûDML²Ù×÷£¬share
e.g. 4¼¶ËøÓУºCreate Index, Lock Share
locked_modeΪ2,3,4²»Ó°ÏìDML(insert,delete,update,select)²Ù×÷, µ«DDL(alter,dropµÈ)²Ù×÷»áÌáʾ
ora-00054´íÎó¡£
00054, 00000, "resource busy and acquire with NOWAIT specified"
// *Cause: Resource interested is busy.
// *Action: Retry if necessary.
5£ºS/Row-X ¹²ÏíÐжÀÕ¼(SRX)£º×èÖ¹ÆäËûÊÂÎñ²Ù×÷£¬share/
Ïà¹ØÎĵµ£º
µ±Ö´ÐвåÈëµÈ²Ù×÷ʱ³öÏÖ´íÎóÌáʾ“unable to extand table ……” £¬Ôò˵Ã÷¸Ã±íËùÔÚ±í¿Õ¼ä¿Õ¼ä²»×ãÁË¡£
Èç¹ûÊÇÔÚwinserverÏÂÔòΪ±í¿Õ¼äÔö¼ÓÎļþ¼´¿É£¨±¾ÎIJ»×ö½éÉÜ£©¡£
±¾ÎÄÖ÷Òª½éÉÜÊý¾Ý¿â·þÎñÆ÷»·¾³ÎªAIXʱ£¬ÈçºÎΪ±í¿Õ¼äÔö¼ÓÂãÉ豸¡£
͉˕
°üº¬AIXϵͳ´æ´¢¹ÜÀíµÄ»ù±¾½éÉÜ£»
AIXͨ¹ýÈý¸ö²ã´Î¶Ô ......
ÎÞÒÉ×¢ÊÍÏÖÔÚ¶¼±»´ó¼Ò½ÓÊܺÍÈϿɣ¬ÔÚ´ó¼Ò±à³ÌÓõÄIDEÖж¼Ìṩ»òÓеÚÈý·½²å¼þÀ´Ö§³ÖÌáȡעÊÍÄÚÈÝʵÏÖ
¿ìËÙÁ˽â½á¹¹µÄ¹¦ÄÜ¡£µ«ÔÚÊý¾Ý¿âµÄ½Å±¾±àд·½ÃæÎÒÒ²ÊǾÀúÁ˰ٰãÕÛÄ¥ºó×ܽáÁËһЩ¶«Î÷·¢À´Óë´ó¼ÒÇд衣
ÏÂÃæÀ´¿´Ò»¸öOracle½¨±íµÄ·½Ê½¡£
create table ctable_name
(
......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ ......
ÔÚArcGISÖÐͨ¹ýSDE´æ´¢¿Õ¼äÊý¾Ýµ½OracleÖÐÓжàÖÖ´æ´¢·½Ê½£¬·Ö±ðÓУº¶þ½øÖÆLong Raw ¡¢ESRIµÄST_GeometryÒÔ¼°»ùÓÚOracle SpatialµÄSDO_GeometryµÈµÈ¡£
¹ØÓÚÕ⼸ÖÖ·½Ê½µÄ¸÷×ÔµÄÓÅȱµã²»ÊÇÖ÷ÒªµÄ̽Ìֵķ½Ïò£¬ÕâЩÎÒÃÇ¿ÉÒÔͨ¹ýArcGISÖеÄArcGIS Server HelpµÃµ½Ïà¹ØµÄ°ïÖú¡£ÕâÀïÖ÷Ò ......
oracleÊý¾Ý¿âÖÐÐÞ¸ÄÊý¾ÝʱÌáʾ“¼Ç¼±»ÁíÒ»¸öÓû§Ëø×¡” ½â¾ö·½·¨£º
1>²é¿´Êý¾Ý¿âËø,Õï¶ÏËøµÄÀ´Ô´¼°ÀàÐÍ£º
¡¡¡¡select object_id,session_id,locked_mode from v$locked_object;
»òÕßÓÃÒÔÏÂÃüÁ
select b.owner,b.object_name,l.ses ......