½«Êý¾Ýµ¼Èëµ½oracleÊý¾Ý¿â
1.Ê×ÏȽ«Òªµ¼ÈëµÄÊý¾ÝÉú³ÉexcelÎļþ¸ñʽ£¬×îÇ°Ãæ¿ÕÒ»¸ñ¡£
2.ÓÃPL/SQLÁ¬½ÓÒªµ¼ÈëµÄÊý¾Ý¿â£¬ÊäÈëÓï¾ä select * from ±íÃû for update
3.µã»÷СËø£¨±à¼Êý¾Ý£©£¬Ñ¡ÖÐÒ»Ðн«excel¸´ÖÆÊý¾ÝÕ³Ìùµ½±íÖÐ
ÒÔinformixÊý¾Ýµ¼³öΪÀý£¬Ê×ÏÈʹÓÃSecureCRT¹¤¾ß½øÈëÖնˡ£ÊäÈëÃüÁîdbaccessºóÖ´ÐУ¬Ñ¡ÖÐÊý¾Ý¿âNEWÒ»ÏÂSQLÓï¾äÊäÈëÃüÁunload to ±íÃû.unl select * from ±íÃû ºóÑ¡ÔñRUNÖ´ÐУ¬½«Éú³ÉÒ»¸öunlÎļþ£¬½«unlÎļþת»»³Éexcel£¬Ê×ÏȽ«|»»³É^tÔÚÉú³Éexcel¡£
µ¼³ö±í½á¹¹£ºÖ±½Ó½øÈëÖÕ¶ËÊäÈëdbschema -d Êý¾Ý¿âÃû -t ±íÃû a_topic_class.sql
Ïà¹ØÎĵµ£º
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
  ......
ÏÂÃæ¾ÍÀ´½éÉÜÒ»ÏÂÕâЩÔÚºǫ́ÐÁÇÚ¹¤×÷µÄ½ø³ÌÃÇ¡£ÏµÍ³¼ì²âÆ÷£¨System Monitor,SMON£©¡¢½ø³Ì¼àÊÓÆ÷£¨Process
Monitor,PMON£©¡¢Êý¾Ý¿âдÈëÆ÷£¨Database Writer,DBWn£©¡¢ÈÕ־дÈëÆ÷£¨Log
Writer,LGWR£©¡¢¼ì²éµã½ø³Ì£¨Checkpoint Process,CKPT£© ¡£
1¡¢SMON£º°²×°ºÍ´ò¿ªÊý¾Ý¿â¡£Í¨¹ý²éÕÒºÍ
ÑéÖ¤Êý¾Ý¿â¿ØÖÆ ......
¶ÔÓÚOracle¹¤×÷Á÷µÄÓÅ»¯·½Ê½Ö÷Òª·ÖÁ½´óÀ࣬һÀàÊÇÁ÷³ÌÉè¼ÆÉϵÄÓÅ»¯£¬Ò»ÀàÊÇÊý¾Ý¿âÐÔÄܵÄÓÅ»¯¡£
Á÷³ÌÉè¼ÆÓÅ»¯£º
×ÐϸѡÔñͬ²½´¦ÀíºÍÒì²½´¦Àíģʽ¡£
Èç¹ûÑ¡Ôñͬ²½´¦Àíģʽ£¬ÔòÔÚÌá½»ºóϵͳÁ¢¼´½øÐй¤×÷Á÷´¦Àí£¬ÔÚÁ÷³Ì½áÊøÇ°£¬Ç°¶Ë³ÌÐò½«Ò»Ö±´¦Óڵȴý×´ ̬¡£Èç¹ûÑ¡ÔñÒì²½´¦Àíģʽ£¬³ÌÐòÌá½»¹¤×÷Á÷ºó¿ØÖÆȨÁ¢¼´·µ»Ø£¬¹¤×÷Á÷º ......
1¡¢×ª»»·þÎñÆ÷¹éµµÄ£Ê½£¬Èç¹ûÒÑÊǹ鵵ģʽ¿ÉÌø¹ý´Ë²½£º
¡¡%sqlplus /nolog (Æô¶¯sqlplus)
¡¡¡¡SQL> conn / as sysdba (ÒÔDBAÉí·ÝÁ¬½ÓÊý¾Ý¿â)
¡¡¡¡SQL> shutdown immediate; (¼´Ê±¹Ø±ÕÊý¾Ý¿â)
¡¡¡¡SQL> startup mount (Æô¶¯ÊµÀý²¢¼ÓÔØÊý¾Ý¿â£¬µ«²»´ò¿ª)
¡¡¡¡SQL> alter database archivelog; (¸ü¸ÄÊ ......
˵µ½Èí½âÎö£¨soft prase
£©ºÍÓ²½âÎö£¨
hard prase
£©£¬¾Í²»Äܲ»ËµÒ»ÏÂ
Oracle
¶Ô
sql
µÄ´¦Àí¹ý³Ì¡£µ±Äã·¢³öÒ»Ìõ
sql
Óï¾ä½»¸¶
Oracle
£¬ÔÚÖ´ÐкͻñÈ¡½á¹ûÇ°£¬
Oracle
¶Ô´Ë
sql
½«½øÐм¸¸ö²½ÖèµÄ´¦Àí¹ý³Ì£º
1¡¢Óï·¨¼ì²é£¨
syntax check
£©
&nb ......