OracleµÄ°æÈ¨ÉùÃ÷
ÒÔÍù´ÓÀ´Ã»ÓÐÏëÈ¥ÈÏÕæ¶ÁÒ»´ÎOracleµÄ°æÈ¨ÉùÃ÷£¬½ñÌì´ò¿ªOracle10gR2µÄÎĵµ£¬ÓÚÊǾÍË÷ÐÔ´ÓÍ·¿ªÊ¼¶ÁÒ»ÏÂÕâÆªÎÄÕ¡£
һЩÎÒÏë´ó¼Ò¶¼Ó¦¸ÃÈ¥ÖªµÀµÄ£¬ËäÈ»¹úÄڵİæÈ¨¸ÅÄîʵÔÚÊDZȽϵ±¡£¬µ«ÏëÀ´»áÔ½À´Ô½ºÃµÄ¡£
Oracle10g·ÖΪ4¸ö°æ±¾£¬·Ö±ðÊÇ£º
1¡£Oracle Database Standard Edition One£¬×î»ù±¾µÄÉÌÒµ°æ±¾£¬°üÀ¨»ù±¾µÄÊý¾Ý¿â¹¦ÄÜ¡£
2¡£Oracle Database Standard Edition £¬±ê×¼°æ£¬°üÀ¨ÉÏÃæÄǸö°æ±¾µÄ¹¦ÄܺÍRAC£¬Ö»ÓÐÔÚ10gµÄ±ê×¼°æÖвſªÊ¼°üº¬RAC¡£
3¡£Oracle Database Enterprise Edition£¬ÆóÒµ°æ£¬Ëä˵ÊÇ×îÇ¿¾¢µÄ°æ±¾£¬µ«ÊDz¢²»ÊÇËùÓÐÎÒÃdz£ÓõŦÄܶ¼ÔÚÕâ¸ö°æ±¾ÖУ¬ºÜ¶à¶«Î÷ÈÔÈ»ÊÇÒª¶îÍ⸶·ÑµÄ£¬ºóÃæ»á˵µ½¡£
4¡£Oracle Database Personal Edition£¬¸öÈ˰棬³ýÁ˲»Ö§³ÖRACÖ®Íâ°üº¬ÆóÒµ°æµÄËùÓй¦ÄÜ£¬µ«ÊÇ×¢ÒâµÄÊÇ£¬Ö»ÓÐWindowsƽ̨ÉϲÅÌṩ¸öÈ˰档
ÏÂÃæÀ´¿´Ò»Ï£¬ÔÚStandard Edition OneºÍStandard EditionÖв»Ö§³ÖµÄ¹¦ÄÜ£¨Ö»ÊÇÑ¡ÁËһЩ´ó¼Ò±È½Ï³£¼û»òÕß³£ÓõŦÄÜ£©£¬×¢Ò⣬ÕâЩ¹¦ÄܳýÁËRACÖ®ÍâÈÔÈ»°üº¬ÔÚ¸öÈ˰æÖС£
1¡£Oracle Data Guard£¬ÏëÒª¸ß¿ÉÓÃÐÔµÄÈ˲»ÒªÑ¡Ôñ±ê×¼°æÁË
2¡£Ò»Ð©Online²Ù×÷£¬±ÈÈçOnline index maintenance£¬Online table redefinitionµÈ
3¡£±¸·ÝºÍ»Ö¸´µÄijЩ²Ù×÷ÊÜÏÞ£¬±ÈÈç²»Ö§³ÖBlock¼¶±ðµÄ»Ö¸´£¨Block-level media recovery£©£¬²»Ö§³Ö²¢Ðб¸·ÝºÍ»Ö¸´£¨Parallel backup and recovery£©£¬¶àÖØ±¸·Ý£¨Duplexed backup sets£©µÈµÈ
4¡£Flashback¹¦ÄÜ£¬ÔÚ±ê×¼°æÖÐFlashback Table£¬Flashback Database£¬ Flashback Transaction Query¶¼ÊDz»Ö§³ÖµÄ
5¡£VPD£¨Virtual Private Database£©²»Ö§³Ö
6¡£FGA£¨Fine-grained auditing£©²»Ö§³Ö
7¡£Partitioning£¬×¢Òâ¹þ×¢Ò⣬·ÖÇøÒ²ÊDz»Ö§³ÖµÄ
8¡£Data compression£¬±ÈÈç±íѹËõ£¬·ÖÇøÑ¹Ëõ¶¼²»Ö§³Ö
9¡£Bitmapped index and bitmapped join index£¬ºÇºÇ£¬Ïë×öÊý¾Ý²Ö¿âµÄ¾Í²»ÒªÍýͼѡÔñ±ê×¼°æÁË
10¡£Export transportable tablespace£¬ÈÔȻҪעÒ⣬ÕâÀïÖ»Êǵ¼Èë²»Ö§³Ö£¬µ«ÊÇImport transportable tablespace£¬°üÀ¨¿çƽ̨µÄimport¶¼ÊÇÖ§³ÖµÄ£¬Ò²¾ÍÊÇ˵ÄãÈç¹ûÑ¡ÔñÁ˱ê×¼°æ£¬ÄÇôÏë°ÑÊý¾Ý¿â¼òµ¥µØ×ªÒƵ½ÆäËüƽ̨ÉÏÊDZȽϷѾ¢µÄÊÂÇéÁË
11¡£Ò»¶Ñ²¢ÐвÙ×÷¶¼²»Ö§³Ö£¬°üÀ¨Parallel query£¬Parallel DML£¬Parallel index build£¬Parallel Data Pump export and import£¬Ò²¾ÍÊÇOracleÈÏΪÄã¼ÈȻѡÔñÁ˱ê×¼°æ£¬ÄÇôÄãµÄÊý¾ÝÒ»¶¨²»´óÁË£¬¼ÈÈ»²»´ó£¬ÄÇôҲ¾ÍÓò»µ½²¢ÐÐÈ¥Ìá
Ïà¹ØÎĵµ£º
¾³£ÓÐDBAÅóÓÑÃÇÏòÎÒ×Éѯ£¬Èç¹û´òËã½øÈëDBAÕâÒ»ÐУ¬Ó¦¸ÃÔõÑùÈëÃÅ£¬»òÕß¿ÉÒÔͨ¹ýÔõÑùÒ»¸ö·ÏßͼÀ´½øÐÐѧϰ¡£
¹ØÓÚÕâ¸öÖ÷Ì⣬ÆäÊµÍøÂçÉÏÒѾÓÐÁËһЩÄÚÈÝ¿ÉÒԲο¼¡£µ«ÊǼÈÈ»Õâô¶àÅóÓÑÎÊÌ⣬ÎҾͽ«Ö®Ç°Ð´ºÃµÄÒ»µãÄÚÈÝ·¢±í³öÀ´¡£
ËãÊǶԴó¼ÒµÄÒ»¸ö»Ø´ð£¬Èç¹ûÄܹ»ÓÐËù½è¼øÄÇÊÇ×îºÃµÄ¡£
ÎÒµÄÕâ·Ý·Ïßͼ£¬Êǰ´ÕÕÎÒд×÷µÄÁ½±¾Êé ......
Oracle´¥·¢Æ÷Óï·¨(Ò»)
Ò» Oracle´¥·¢Æ÷Óï·¨
´¥·¢Æ÷ÊÇÌØ¶¨Ê¼þ³öÏÖµÄʱºò£¬×Ô¶¯Ö´ÐеĴúÂë¿é¡£ÀàËÆÓÚ´æ´¢¹ý³Ì£¬´¥·¢Æ÷Óë´æ´¢¹ý³ÌµÄÇø±ðÔÚÓÚ:´æ´¢¹ý³ÌÊÇÓÉÓû§»òÓ¦ÓóÌÐòÏÔʽµ÷ÓõÄ,¶ø´¥·¢Æ÷ÊDz»Äܱ»Ö±½Óµ÷Óõġ£
¹¦ÄÜ£º
1¡¢ ÔÊÐí/ÏÞÖÆ¶Ô±íµÄÐÞ¸Ä
2¡¢ ×Ô¶¯Éú³ÉÅÉÉúÁУ¬±ÈÈç×ÔÔö×Ö¶Î
3¡¢ Ç¿ÖÆÊý¾ÝÒ»ÖÂÐÔ
4¡¢ ÌṩÉó¼Æº ......
---------------oracle ÈëÃÅ
´ò¿ª·þÎñÆ÷
net start oracleserviceORCL
´ò¿ª¼àÌýÆ÷
lsnrctl start
¹Ø±Õ·þÎñÆ÷
net stop oracleserviceORCL
¹Ø±Õ¼àÌýÆ÷
lsnrctl stop
-----------------------------
1.´´½¨±í
Create table ±íÃû
(×Ö¶ÎÃû Êý¾Ý ......
http://inthirties.com:90/viewthread.jsp?tid=1395
Õâ¸ödeterministicÊDz»ÊǺÜÑÛÊìѽ£¬
ÎÒÃÇÔÚonline redefinitionÀï¼ûµ½¹ýÕâ¸ö¹Ø¼ü×Ö£¬Õâ¸ö¹Ø¼üÔÚÔÚ×Ô¶¨ÒåµÄº¯ÊýË÷ÒýÀïÒ²³öÏÖÁË¡£
ÏÈ¿´¿´Îĵµ
DETERMINISTIC Clause
Specify DETERMINISTIC to indicate that the function returns the same
result value whenever i ......
Oracle RAC ÖÐOCR ºÍVoting Disk ±¸·ÝÔÚÎÒµÄblog£º Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî ÖÐÒѾÓÐ˵Ã÷£¬ÏÖÔÚÔٴΰÑËüµ¥¶ÀÄóö×öÒ»¸ö˵Ã÷£¬ ÒòΪOCR ºÍ Voting Disk ¶ÔÓÚRAC ϵͳÀ´ËµÌ«ÖØÒªÁË¡£
Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî ......