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

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ÈÏΪÄã¼ÈȻѡÔñÁ˱ê×¼°æ£¬ÄÇôÄãµÄÊý¾ÝÒ»¶¨²»´óÁË£¬¼ÈÈ»²»´ó£¬ÄÇôҲ¾ÍÓò»µ½²¢ÐÐÈ¥Ìá


Ïà¹ØÎĵµ£º

Oracle DBA ÈëÃÅ¡¢½ø½×ѧϰ·Ïßͼ

¾­³£ÓÐDBAÅóÓÑÃÇÏòÎÒ×Éѯ£¬Èç¹û´òËã½øÈëDBAÕâÒ»ÐУ¬Ó¦¸ÃÔõÑùÈëÃÅ£¬»òÕß¿ÉÒÔͨ¹ýÔõÑùÒ»¸ö·ÏßͼÀ´½øÐÐѧϰ¡£
¹ØÓÚÕâ¸öÖ÷Ì⣬ÆäÊµÍøÂçÉÏÒѾ­ÓÐÁËһЩÄÚÈÝ¿ÉÒԲο¼¡£µ«ÊǼÈÈ»Õâô¶àÅóÓÑÎÊÌ⣬ÎҾͽ«Ö®Ç°Ð´ºÃµÄÒ»µãÄÚÈÝ·¢±í³öÀ´¡£
ËãÊǶԴó¼ÒµÄÒ»¸ö»Ø´ð£¬Èç¹ûÄܹ»ÓÐËù½è¼øÄÇÊÇ×îºÃµÄ¡£
ÎÒµÄÕâ·Ý·Ïßͼ£¬Êǰ´ÕÕÎÒд×÷µÄÁ½±¾Êé ......

Oracle ´¥·¢Æ÷Óï·¨¼°ÊµÀý

Oracle´¥·¢Æ÷Óï·¨(Ò»)
Ò» Oracle´¥·¢Æ÷Óï·¨
´¥·¢Æ÷ÊÇÌØ¶¨Ê¼þ³öÏÖµÄʱºò£¬×Ô¶¯Ö´ÐеĴúÂë¿é¡£ÀàËÆÓÚ´æ´¢¹ý³Ì£¬´¥·¢Æ÷Óë´æ´¢¹ý³ÌµÄÇø±ðÔÚÓÚ:´æ´¢¹ý³ÌÊÇÓÉÓû§»òÓ¦ÓóÌÐòÏÔʽµ÷ÓõÄ,¶ø´¥·¢Æ÷ÊDz»Äܱ»Ö±½Óµ÷Óõġ£
¹¦ÄÜ£º
1¡¢ ÔÊÐí/ÏÞÖÆ¶Ô±íµÄÐÞ¸Ä
2¡¢ ×Ô¶¯Éú³ÉÅÉÉúÁУ¬±ÈÈç×ÔÔö×Ö¶Î
3¡¢ Ç¿ÖÆÊý¾ÝÒ»ÖÂÐÔ
4¡¢ ÌṩÉó¼Æº ......

Oracle»ù´¡

---------------oracle ÈëÃÅ
 ´ò¿ª·þÎñÆ÷
 net start oracleserviceORCL
 ´ò¿ª¼àÌýÆ÷
 lsnrctl start
 ¹Ø±Õ·þÎñÆ÷
 net stop oracleserviceORCL
 ¹Ø±Õ¼àÌýÆ÷
 lsnrctl stop
-----------------------------
 1.´´½¨±í
 Create table ±íÃû
 (×Ö¶ÎÃû Êý¾Ý ......

oracle deterministic¹Ø¼ü×Ö

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 10g RAC OCR ºÍ VotingDisk µÄ±¸·ÝÓë»Ö¸´


 
Oracle RAC ÖÐOCR ºÍVoting Disk ±¸·ÝÔÚÎÒµÄblog£º Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî ÖÐÒѾ­ÓÐ˵Ã÷£¬ÏÖÔÚÔٴΰÑËüµ¥¶ÀÄóö×öÒ»¸ö˵Ã÷£¬ ÒòΪOCR ºÍ Voting Disk ¶ÔÓÚRAC ÏµÍ³À´ËµÌ«ÖØÒªÁË¡£
Oracle RAC ³£ÓÃά»¤¹¤¾ßºÍÃüÁî ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ