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

OracleµÄËø»úÖƹéÄÉ×ܽá

OracleµÄËø»úÖƹéÄÉ×ܽá
    
ËøÊÇ·ÀÖ¹ÔÚÁ½¸öÊÂÎñ²Ù×÷ͬһ¸öÊý¾ÝÔ´£¨±í»òÐУ©Ê±½»»¥ÆÆ»µÊý¾ÝµÄÒ»ÖÖ»úÖÆ¡£Oracle²ÉÓ÷âËø¼¼Êõ±£Ö¤²¢·¢²Ù×÷µÄ¿É´®ÐÐÐÔ¡£OracleµÄËø·ÖΪÁ½´ó
ÀࣺÊý¾ÝËø£¨Ò²³ÆDMLËø£©ºÍ×ÖµäËø¡£×ÖµäËøÊÇOracle
DBMSÄÚ²¿ÓÃÓÚ¶Ô×Öµä±íµÄ·âËø¡£×ÖµäËø°üÀ¨Óï·¨·ÖÎöËøºÍDDLËø£¬ÓÉDBMSÔÚ±ØÒªµÄʱºò×Ô¶¯¼ÓËøºÍÊÍ·ÅËø£¬Óû§ÎÞ»ú¿ØÖÆ¡£
OracleÖ÷ÒªÌṩÁË5ÖÖÊý¾ÝËø£º¹²ÏíËø£¨Share Table Lock£¬¼ò³ÆSËø£©¡¢ÅÅËüËø£¨Exclusive Table
Lock£¬¼ò³ÆXËø£©¡¢Ðм¶Ëø£¨Row Share Table Lock£¬¼ò³ÆRSËø£©¡¢Ðм¶ÅÅËüËø£¨Row Exclusive Table
Lock£¬¼ò³ÆRXËø£©ºÍ¹²ÏíÐм¶ÅÅËüËø£¨Share Row Exclusive Table
Lock£¬¼ò³ÆSRXËø£©¡£Æä·âËøÁ£¶È°üÀ¨Ðм¶ºÍ±í¼¶¡£
1. ¹²ÏíËø£¨Share Table Lock£¬S£©£º
¼ÓËøÓï·¨£ºLock Table TableName In Share Mode;
ÔÊÐíµÄ²Ù×÷£ºÒ»¸ö¹²ÏíËøÓÉÒ»¸öÊÂÎñ¿ØÖÆ£¬½öÔÊÐíÆäËüÊÂÎñ²éѯ±»Ëø¶¨µÄ±í¡£Ò»¸öÓÐЧµÄ¹²ÏíËøÃ÷È·µØÓÃSelect … For
updateÐÎʽËø¶¨ÐУ¬»òÖ´ÐÐLock Table TableName In Share
ModeÓï·¨Ëø¶¨Õû¸ö±í£¬²»ÔÊÐí±»ÆäËüÊÂÎñ¸üС£ÔÊÐí¶à¸öÊÂÎñÔÚͬһ¸ö±íÉϼӹ²ÏíËø£¬ÕâÖÖÇé¿öϲ»ÔÊÐíÔڸñíÉϼÓËøµÄÊÂÎñ¸üÐÂ±í£¨¼´Ê¹ÓÐÒ»¸öÊÂÎñ¿ØÖƵÄÊÇ
ÐÎÈçSelect Row … for
updateÕâÑùÐÐËøÒ²ÊDz»±»ÔÊÐíµÄ£©¡£Òò´Ë£¬½öÓÐÒ»¸öÊÂÎñµÄÒ»¸ö¹²ÏíËø¿ÉÒÔ¸üиñíÈç¹ûÆäËüÊÂÎñÒ²ÓÐÏàͬµÄÊÂÎñÔڸñíÉϵĻ°¡£
½ûÖ¹µÄ²Ù×÷£ºÒ»¸ö¹²ÏíËøÓÉÒ»¸öÊÂÎñÀ´¿ØÖÆ£¬·ÀÖ¹ÆäËüÊÂÎñ¸üиñí»òÖ´ÐÐÏÂÃæµÄÓï¾ä£º
LOCK TABLE TableName IN SHARE ROW EXCLUSIVE MODE;
LOCK TABLE TableName IN ROW EXCLUSIVE MODE;
2. ÅÅËüËø£¨Exclusive Table Lock£¬X£©£º
ÅÅËüËøÊÇÔÚËø»úÖÆÖÐÏÞÖÆ×î¶àµÄÒ»ÖÖËøÀàÐÍ£¬ÔÊÐí¼ÓÅÅËüËøµÄÊÂÎñ¶À×Ô¿ØÖƶԱíµÄдȨÏÞ¡£
¼ÓËøÓï·¨£ºLock Table TableName In Exclusive Mode;
ÔÊÐíµÄ²Ù×÷£ºÔÚÒ»¸ö±íÖÐÖ»ÄÜÓÐÒ»¸öÊÂÎñ¶Ô¸Ã±íʵÐÐÅÅËüËø£¬ÅÅËüËø½öÔÊÐíÆäËüµÄÊÂÎñ²éѯ¸Ã±í¡£
½ûÖ¹µÄ²Ù×÷£ºÓµÓÐÅÅÍâËøµÄÊÂÎñ½ûÖ¹ÆäËüÊÂÎñÖ´ÐÐÆäËüÈκÎDMLÀàÐ͵ÄÓï¾ä»òÔڸñíÉϼÓÈκÎÆäËüÀàÐ͵ÄËø¡£
¶¨ÒåÅÅËüËøµÄÓï·¨£º
LOCK TABLE TableName IN EXCLUSIVE MODE;
3. Ðм¶Ëø£¨Row Share Table Lock£¬RS£©£º
Ò»¸öÐм¶Ëø£¨ÓÐʱ³ÆΪSubshare Table Lock£¬¼ò³ÆSS£¬×Ó¹²ÏíËø£©ÐèÒª¸ÃÊÂÎñÔÚ±»Ëø¶¨ÐеıíÉÏÓÃupdateµÄÐÎʽ¼ÓËø¡£µ±ÓÐÏÂÃæÓï¾ä±»Ö´ÐеÄʱºòÐм¶Ëø×Ô¶¯¼ÓÔÚ²Ù×÷µÄ±íÉÏ¡£
SELECT . . . from TableName. . . FOR U


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

½²½âOracleÊý¾Ý¿â×Ô¶¯Ôö³¤ÁеÄʵÏÖ¹ý³Ì

OracleÊý¾Ý¿â×Ô¶¯Ôö³¤ÁеÄʵÏÖ¹ý³Ì:
¡ô1.´´½¨ÐòÁÐ
 
-- Create sequence
create sequence INNERID
minvalue 1
maxvalue 99999999999999
start with 1
increment by 1
cache 20
order;
 
 
 
¡ô2.--INNERID.currval Ö¸µ±Ç°ÐòÁÐ
      --INNERID.nextval Ö¸Ï ......

OracleÌṩÁË·ÖÇø¼¼Êõ(»ã×ÜÌû)

OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£ 
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯ ......

Oracle³£¼û´íÎó——TNS 01150

# LISTENER.ORA Network Configuration File: /opt/oracle/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.
ORA92 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS ......

oracleÊý¾Ý¿âÖÐsql»ù´¡ ÉîδÀ´

oracleÊý¾Ý¿âÖÐsql»ù´¡
×÷ÕߣºØýÃû    ×ªÌù×Ô£º±¾Õ¾Ô­´´    ä¯ÀÀ´ÎÊý£º21    ÎÄÕ¼È룺admin
Ò»¡¢¹ØϵÊý¾Ý¿âµÄһЩ¸ÅÄî
¡¡¡¡
¡¡¡¡1¡¢Ö÷¼üµÄÖµÒ»°ã²»¿ÉÒԸıä
¡¡¡¡
¡¡¡¡2¡¢Íâ¼ü£ºÖ¸ÏòÁíÒ»¸ö±í»ò±¾±íµÄÖ÷¼ü»òΨһ¼üµÄ×ֶΡ£Íâ¼üµÄÖµÒ»¶¨ÒªºÍijһÖ÷¼üÏàͬ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ