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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
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ÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯ ......
# 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»ù´¡
×÷ÕߣºØýÃû תÌù×Ô£º±¾Õ¾Ô´´ ä¯ÀÀ´ÎÊý£º21 ÎÄÕ¼È룺admin
Ò»¡¢¹ØϵÊý¾Ý¿âµÄһЩ¸ÅÄî
¡¡¡¡
¡¡¡¡1¡¢Ö÷¼üµÄÖµÒ»°ã²»¿ÉÒԸıä
¡¡¡¡
¡¡¡¡2¡¢Íâ¼ü£ºÖ¸ÏòÁíÒ»¸ö±í»ò±¾±íµÄÖ÷¼ü»òΨһ¼üµÄ×ֶΡ£Íâ¼üµÄÖµÒ»¶¨ÒªºÍijһÖ÷¼üÏàͬ ......