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

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


Ïà¹ØÎĵµ£º

oracle¸ßˮλÏß

ʲôÊÇË®Ïß(High Water Mark)?
----------------------------
ËùÓеÄoracle¶Î(segments£¬ÔÚ´Ë£¬ÎªÁËÀí½â·½±ã£¬½¨Òé°Ñsegment×÷Ϊ±íµÄÒ»¸öͬÒå´Ê) ¶¼ÓÐÒ»¸öÔÚ¶ÎÄÚÈÝÄÉÊý¾ÝµÄÉÏÏÞ£¬ÎÒÃǰÑÕâ¸öÉÏÏÞ³ÆÎª"high water mark"»òHWM¡£Õâ¸öHWMÊÇÒ»¸ö±ê¼Ç£¬ÓÃÀ´ËµÃ÷ÒѾ­ÓжàÉÙûÓÐʹÓõÄÊý¾Ý¿é·ÖÅ䏸Õâ¸ösegment¡£HWMͨ³£Ôö³¤µÄ·ù¶ ......

oracleÖжÔÅÅÐòµÄ×ܽá

¡¡¡¡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¹ÊÕÏ´¦Àí

Ò»´Îoracle 10g rac¹ÊÕÏ´¦Àí:
rhel4-1->crs_stat -t
Name           Type           Target    State     Host       
------------ ......

oracle startup shutdownÃüÁî

дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
     ²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾ­Á¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓ ......

Oracle RACѧϰ±Ê¼Ç

Oracle RACѧϰ±Ê¼Ç
1. Introduction:
Cluster - ¶ÔÓû§À´Ëµ¶ą̀·þÎñÆ÷ºÃÏñÊÇһ̨·þÎñÆ÷Ò»Ñù¡£
Oracle Clusterware - OracleÌṩµÄ¼¯Èº½â¾ö·½°¸
Oracle RAC ¶à¸öʵÀý¶ÔÓ¦Ò»¸öÊý¾Ý¿â£¨Îļþ£©
Oracle Cluster Architecture:  (Hardware)
Oracle RAC Á©¸ö×é¼þ£ºVoting DiskºÍOCR £¨Oracle Cluster Register£©
Voti ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ