oracle 11g Óë 10g µÄÇø±ð - Oracle / ¿ª·¢
Ö»ÖªµÀ 11g ±È 10g ¶àÁËһЩ×é¼þ¡£¶øÕâЩ×é¼þ¶Ô DBA À´ËµÓ¦¸ÃÊÇÓÐÓõġ£µ«ÊÇÎÒÊÇÒ»¸öǰ̨¿ª·¢Õß¡£ÕâЩ¹¤¾ß²»ÊǺܳ£Óᣵ«ÎÒÏëÖªµÀ£¬ÕâÁ½¸ö°æ±¾ËùÓÃµÄ sql »ò PlusSql ÊÇ·ñÓÐÇø±ð£¿¸Õ²Å Google ÁËһϡ£·¢ÏÖÒ²ÓÐÌù×ÓÎÊij¸ö SQL ÔÚ 10g ÉÏÄÜÔËÐУ¬µ«µ½ 11g ÉÏÔò³öÏÖÁËÎÊÌâ¡£µ«¸öÈËÈÏΪÕâËÆºõ²»Ó¦¸Ã~~~~ºÇºÇ~~ËùÒÔÔÚ´ËÈ·ÈÏÒ»ÏÂ~~ 11g Óë 10g µÄ JDBC Á´½Ó·½Ê½Ó¦¸ÃÒ²ÊÇÒ»Ñù°É£¿ ×îÖØÒªµÄ~~~ÏÖÔÚ¡°ÆóÒµ¡±´ó¶àʹÓÃÄĸö°æ±¾°¡£¿
ÎÒÌý˵ 11g мÓÈëµÄ¹¦ÄÜ ±È 10 g ¶¼Éϰٸö ,µ«ÊÇÆäʵºËÐĶ¼Ò»ÑùµÄ£¡£¡ÒýÓà sqlºÍsqlplusÏòϼæÈÝÊǿ϶¨µÄ лл~~ »¹ÓÐÇë½Ì~~~ÏÖÔÚÆóÒµ¶¼ÓÃÄǸö°æ±¾°¡£¿ ¸÷¸öͬÈʶ¼ÓõÄÄĸö°æ±¾ÄØ£¿ Ö÷Á÷10G Ç÷ÊÆ 11G ÀÏϵͳ9I
Ïà¹ØÎÊ´ð£º
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......