Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 supportÒ»´ÎΣ»ú´¦Àí£¨Ö®Ò»£©

ÌìÓв»²â·çÔÆ£¬
IBM µÄÖж˴ÅÅÌÕóÁÐÕâ´ÎÓÖÈÇ»öÁË¡£ÔÚ΢ÂëÉý¼¶µÄʱºò£¬
DS4800 ·¢Éú¹ÊÕÏ¡£IBM¹¤³Ìʦ°ÑÕóÁйÊÕϻָ´ºó£¬ÅÄÅÄÆ¨¹É×ßÈË£¬ÁôÏÂÁËÕóÁÐÉϲ»Ò»ÖµÄÊý¾Ý¡£
û°ì·¨£¬ÕóÁÐÉϵÄÊý¾ÝÓÖµÃÎÒÃÇÀ´Ïë°ì·¨ÇÀ¾ÈÁË¡£¡£¡£¡£
»¹ºÃÓÐoracle supportµÄÖ§³ÖÎÒÃÇ×îÖÕ»¯½âÁËÕâ´ÎΣ»ú¡£ÏÂÎÄÏêϸ½éÉÜÁËÕû¸ö»Ö¸´µÄ¹ý³Ì¡£
 
&nbs ......

Oracle IO ²âÊÔ¹¤¾ßORION

Ò»Ö±ÏëѧϰÈçºÎµÃµ½Êý¾Ý¿âµÄIOÊý¾Ý£¬ORIONÊÇÒ»¸ö²»´íµÄ·ÂÕæ²âÊÔOracle IOµÄ¹¤¾ß¡£
ÏÂÃæÊÇÎҵIJâÊԵIJ½Ö裺
1 ´ÓoracleµÄÍøÕ¾ÉÏÏÂÔØORIONµÄÈí¼þ£¨11.1.0.7£©
2 ½âѹorion_linux_x86-64.gz
3 ½¨Á¢²ÎÊýÎļþ mytest.lun£¬ ÕâÀïµÄÁгöµÄÊÇ·ÖÇøÉ豸£¬ÎÒÔÚÉÏÃæ½¨Á¢ÁËasmÎļþϵͳ¡£ÒòΪÓÐÊý¾ÝÔÚÀïÃæ£¬ËùÒÔÎÒÓÃwrite=0Ö»²âÊ ......

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 ......

oracleÓësql server¶Ô±È·ÖÎö

±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | Ô­ÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......

oracleÖеÄÈ«¾ÖÊý¾Ý¿âÃû³ÆºÍsidµÄÇø±ð

Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ