OracleʹÓÃË÷ÒýµÄºÃ´¦
OracleÌṩÁË´óÁ¿Ë÷ÒýÑ¡Ïî¡£ÖªµÀÔÚ¸ø¶¨Ìõ¼þÏÂʹÓÃÄĸöÑ¡Ïî¶ÔÓÚÒ»¸öÓ¦ÓóÌÐòµÄÐÔÄÜÀ´Ëµ·Ç³£ÖØÒª¡£Ò»¸ö´íÎóµÄÑ¡Ôñ¿ÉÄÜ»áÒý·¢ËÀËø£¬²¢µ¼ÖÂÊý¾Ý¿âÐÔÄܼ±¾çϽµ»ò½ø³ÌÖÕÖ¹¡£¶øÈç¹û×ö³öÕýÈ·µÄÑ¡Ôñ£¬Ôò¿ÉÒÔºÏÀíʹÓÃ×ÊÔ´£¬Ê¹ÄÇЩÒѾÔËÐÐÁ˼¸¸öСʱÉõÖÁ¼¸ÌìµÄ½ø³ÌÔÚ¼¸·ÖÖÓµÃÒÔÍê³É£¬ÕâÑù»áʹÄúÁ¢¿Ì³ÉΪһλӢÐÛ¡£ÕâÆªÎÄÕ¾ͽ«¼òµ¥µÄÌÖÂÛÿ¸öË÷ÒýÑ¡Ïî¡£Ö÷ÒªÓÐÒÔÏÂÄÚÈÝ£º
[1] »ù±¾µÄË÷Òý¸ÅÄî
²éѯDBA_INDEXESÊÓͼ¿ÉµÃµ½±íÖÐËùÓÐË÷ÒýµÄÁÐ±í£¬×¢ÒâÖ»ÄÜͨ¹ýUSER_INDEXESµÄ·½·¨À´¼ìË÷ģʽ(schema)µÄË÷Òý¡£·ÃÎÊUSER_IND_COLUMNSÊÓͼ¿ÉµÃµ½Ò»¸ö¸ø¶¨±íÖб»Ë÷ÒýµÄÌØ¶¨ÁС£
[2] ×éºÏË÷Òý
µ±Ä³¸öË÷Òý°üº¬Óжà¸öÒÑË÷ÒýµÄÁÐʱ£¬³ÆÕâ¸öË÷ÒýΪ×éºÏ£¨concatented£©Ë÷Òý¡£ÔÚ Oracle9iÒýÈëÌøÔ¾Ê½É¨ÃèµÄË÷Òý·ÃÎÊ·½·¨Ö®Ç°£¬²éѯֻÄÜÔÚÓÐÏÞÌõ¼þÏÂʹÓøÃË÷Òý¡£±ÈÈ磺±íempÓÐÒ»¸ö×éºÏË÷Òý¼ü£¬¸ÃË÷Òý°üº¬ÁËempno¡¢ enameºÍdeptno¡£ÔÚOracle9i֮ǰ³ý·ÇÔÚwhereÖ®¾äÖжԵÚÒ»ÁУ¨empno£©Ö¸¶¨Ò»¸öÖµ£¬·ñÔò¾Í²»ÄÜʹÓÃÕâ¸öË÷Òý¼ü½øÐÐÒ»´Î·¶Î§É¨Ãè¡£
ÌØ±ð×¢Ò⣺ÔÚOracle9i֮ǰ£¬Ö»ÓÐÔÚʹÓõ½Ë÷ÒýµÄǰµ¼Ë÷Òýʱ²Å¿ÉÒÔʹÓÃ×éºÏË÷Òý£¡
[3] ORACLE ROWID
ͨ¹ýÿ¸öÐеÄROWID£¬Ë÷ÒýOracleÌṩÁË·ÃÎʵ¥ÐÐÊý¾ÝµÄÄÜÁ¦¡£ROWIDÆäʵ¾ÍÊÇÖ±½ÓÖ¸Ïòµ¥¶ÀÐеÄÏß·ͼ¡£Èç¹ûÏë¼ì²éÖØ¸´Öµ»òÊÇÆäËû¶ÔROWID±¾ÉíµÄÒýÓ㬿ÉÒÔÔÚÈκαíÖÐʹÓúÍÖ¸¶¨rowidÁС£
[4] ÏÞÖÆË÷Òý
ÏÞÖÆË÷ÒýÊÇһЩûÓоÑéµÄ¿ª·¢ÈËÔ±¾³£·¸µÄ´íÎóÖ®Ò»¡£ÔÚSQLÖÐÓкܶàÏÝÚå»áʹһЩË÷ÒýÎÞ·¨Ê¹Óá£ÏÂÃæÌÖÂÛһЩ³£¼ûµÄÎÊÌ⣺
4.1 ʹÓò»µÈÓÚ²Ù×÷·û£¨<>¡¢!=£©
ÏÂÃæµÄ²éѯ¼´Ê¹ÔÚcust_ratingÁÐÓÐÒ»¸öË÷Òý£¬²éѯÓï¾äÈÔȻִÐÐÒ»´ÎÈ«±íɨÃè¡£
select cust_Id,cust_name
from customers
where cust_rating <> 'aa';
°ÑÉÏÃæµÄÓï¾ä¸Ä³ÉÈçϵIJéѯÓï¾ä£¬ÕâÑù£¬ÔÚ²ÉÓûùÓÚ¹æÔòµÄ
ÓÅ»¯Æ÷¶ø²»ÊÇ»ùÓÚ´ú¼ÛµÄÓÅ»¯Æ÷£¨¸üÖÇÄÜ£©Ê±£¬½«»áʹÓÃË÷Òý¡£
select cust_Id,cust_name
from&n
Ïà¹ØÎĵµ£º
ʲôÊÇË®Ïß(High Water Mark)?
----------------------------
ËùÓеÄoracle¶Î(segments£¬ÔÚ´Ë£¬ÎªÁËÀí½â·½±ã£¬½¨Òé°Ñsegment×÷Ϊ±íµÄÒ»¸öͬÒå´Ê) ¶¼ÓÐÒ»¸öÔÚ¶ÎÄÚÈÝÄÉÊý¾ÝµÄÉÏÏÞ£¬ÎÒÃǰÑÕâ¸öÉÏÏÞ³ÆÎª"high water mark"»òHWM¡£Õâ¸öHWMÊÇÒ»¸ö±ê¼Ç£¬ÓÃÀ´ËµÃ÷ÒѾÓжàÉÙûÓÐʹÓõÄÊý¾Ý¿é·ÖÅ䏸Õâ¸ösegment¡£HWMͨ³£Ôö³¤µÄ·ù¶ ......
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M');
¡¡¡¡-- °´²¿Ê×ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROKE_M');
¡¡¡¡-- °´±Ê»ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_RADICAL_M');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚ ......
Ò»´Îoracle 10g rac¹ÊÕÏ´¦Àí:
rhel4-1->crs_stat -t
Name Type Target State Host
------------ ......
дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾÁ¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓ ......
Oracle RACѧϰ±Ê¼Ç
1. Introduction:
Cluster - ¶ÔÓû§À´Ëµ¶ą̀·þÎñÆ÷ºÃÏñÊÇһ̨·þÎñÆ÷Ò»Ñù¡£
Oracle Clusterware - OracleÌṩµÄ¼¯Èº½â¾ö·½°¸
Oracle RAC ¶à¸öʵÀý¶ÔÓ¦Ò»¸öÊý¾Ý¿â£¨Îļþ£©
Oracle Cluster Architecture: (Hardware)
Oracle RAC Á©¸ö×é¼þ£ºVoting DiskºÍOCR £¨Oracle Cluster Register£©
Voti ......