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/
Ïà¹ØÎĵµ£º
oracleÊÇÒ»ÖÖ´óÐ͵ġ¢¿ÉÒÆÖ²µÄ¶ÔÏó¹ØϵÐÍÊý¾Ý¿â¡£ËüÔÚÏà¹ØµÄÿһ¸öƽ̨É϶¼¿ÉÒÔÔËÐУ¬Òò´ËoracleµÄÌåϵ½á¹¹ÔÚ²»Í¬µÄ²Ù×÷ϵͳÉÏÊÇÓÐËù²»Í¬µÄ¡£±ÈÈçÔÚUNIXϵͳÉÏ£¬ÒòΪUNIXϵͳÊǹ¤×÷ÔÚ¶à½ø³ÌµÄ»ù´¡ÉÏ£¬ËùÒÔoracleÔËÐÐʱÌåÏÖΪ¶à¸ö½ø³ÌÔÚÔËÐС£È»¶øÔÚwindowsϵͳÉÏ£¬windowsÏµÍ³Ê ......
Oracle
Ò»¡¢Êý¾Ý¿âÓïÑÔ£º
DCL:Êý¾Ý¿â¿ØÖÆÓïÑÔ(ÈçÊÂÎñ...)
DQL:Êý¾Ý¿â²éѯÓïÑÔ(select...)
DDL:Êý¾Ý¿â¶¨ÒåÓïÑÔ(create)
DML:Êý¾Ý¿â²Ù×÷ÓïÑÔ(¸üÐÂ....)
¶þ¡¢Oracle°æ±¾£º
Oracle8I i£º»¥ÁªÍø
Oracle10g g£ºÍø¸ñ£º°Ñ¸´ÔÓµÄÎÊÌâ·Ö²¼´¦Àí£¬×îºó°Ñ½á¹û×ۺϳÉ×î×ܽá¹û
°Ñ¸´ÔÓµÄÎÊÌâ·Ö²¼´¦Àí£¬×îºó°Ñ½á¹û×Ûº ......
SDO_FILTER
¸ñʽ£º
SDO_FILTER(geometry1, geometry2, params);
ÃèÊö£º
ͨ¹ý¿Õ¼äË÷Òý£¬¸ù¾Ý¸ø¶¨µÄ¼¸ºÎÒªËؼìË÷³ö¾ßÓпռäÏ໥¹ØϵµÄ¿Õ¼ä¶ÔÏó¡£ÕâÀïµÄ¿Õ¼ä¹ØϵÊÇÖ¸Á½¸ö¼¸ºÎ²»·ÖÀ룬¼´Non-disjoint¡£¡¾disjoint£º±íʾÁ½¸ö¼¸ºÎµÄ±ßºÍÄÚ²¿¶¼²»Ïཻ¡¿
Õâ¸öSdo_Fi ......
ÔÚArcGISÖÐͨ¹ýSDE´æ´¢¿Õ¼äÊý¾Ýµ½OracleÖÐÓжàÖÖ´æ´¢·½Ê½£¬·Ö±ðÓУº¶þ½øÖÆLong Raw ¡¢ESRIµÄST_GeometryÒÔ¼°»ùÓÚOracle SpatialµÄSDO_GeometryµÈµÈ¡£
¹ØÓÚÕ⼸ÖÖ·½Ê½µÄ¸÷×ÔµÄÓÅȱµã²»ÊÇÖ÷ÒªµÄ̽Ìֵķ½Ïò£¬ÕâЩÎÒÃÇ¿ÉÒÔͨ¹ýArcGISÖеÄArcGIS Server HelpµÃµ½Ïà¹ØµÄ°ïÖú¡£ÕâÀïÖ÷Ò ......