oracleÊý¾Ý¿â¡¢±í¿Õ¼ä
ÎÒÊǸöoracleµÄ³õѧÕß¡£ÒòΪÒÔǰÓõÄÊÇMySQLºÍmssql£¬ËùÒÔÔÚѧoracleµÄʱºòÓеãÎóÇø¡£Ï£Íû¸ßÊÖÃǶà°ï°ïæ¡£ 1.ÎÒǰ¼¸ÌìÔÚÕâÀïÌá¹ýÎÊÌ⣬¾ÍÊÇoracleµÄÓû§ÊDz»ÊÇÏ൱ÓÚsqlµÄÒ»¸öÊý¾Ý¿â£¬»Ø´ðÊǿ϶¨µÄ£¬µ«ÊÇÎÒÔÚÍøÉϲ鵽µÄ½á¹ûȴ˵oracleµÄ±í¿Õ¼äÏ൱ÓÚsqlµÄÒ»¸öÊý¾Ý¿â£¬Õâµ½µ×ʲôÊÇÕýÈ·µÄ°¡£¿ 2.ÎÒ¸Õµ½ÏÖÔڵĹ«Ë¾²»³¤Ê±¼ä£¬ÒòΪ¸Õ¸Õ½Ó´¥Oracle£¬ËùÒÔÏë×Ô¼ºÑо¿Ò»Ï£¬ÎÒÃǵÄOracleÔÚaixµÄϵͳÏ£¬oracleÀïÃæ»¹ÓÐÎÒÃÇÓõIJâÊԵĶ«Î÷£¬ÎÒÓÃselect name from v$database;ÏÔʾxyzsµÄÒ»¸öÊý¾Ý¿â¡£ÄÇôÕâ¸öÊý¾Ý¿âÊÇʲôÒâ˼£¿µÇ½Óû§µÄÓµÓдËÊý¾Ý¿âô£¿»¹ÊÇÕû¸öoracle¾ÍÕâÒ»¸ö¿â£¿ 3.ÎÒÏëÒª×Ô¼ºÑо¿Ò»ÏÂoracle£¬ÓõľÍÊÇÎÒÃǹ«Ë¾µÄ»·¾³¡£ÎÒдÁËÒ»¶Î´úÂ룬ÏÖÔÚÐèÒª½¨Ò»¸öÊý¾Ý¿â£¨¾ÍÏñmssql£©µÄÄÇÑùµÄ¿â£¬ÍøÉÏÓÐÈ˸æËßÎÒ½¨Ò»¸öÓû§ÔÙ½¨Ò»¸ö±í¿Õ¼ä¾Í¿ÉÒÔÁË£¬µ«Èç¹ûÎÒ½¨ÁËÒÔºó»á²»»áÔÚxyzsÏÂÃæÄØ£¬¶ÔÎÒÃDzâÊÔµÄÊý¾Ý¿âÓÐûÓÐÓ°ÏìÄØ£¿±ðÈ˻ῴµ½Ã´£¿ÎÒ×Ô¼ºÒª×ö¸ötest¿âÁ¬½Ó×Ô¼ºµÄ³ÌÐòÓ¦¸ÃÔõô×öÄØ£¿ÖØÐ½¨¸ö¿â»¹Êǽ¨¸öÓû§ºÍ±í¿Õ¼ä¾Í¿ÉÒÔÁËÄØ£¿ Çëǰ±²ÃÇÖ¸µãһϡ£Ð»Ð»£¡
ºÃÏñÉÏ´ÎÓÐÈËÎʹýÁËÀàËÆµÄÎÊÌâ¡£ÏÂÃæÊÇÌû×ÓµÄÁ´½Ó£º http://topic.csdn.net/u/20100329/11/ed383ba0-7ca3-4fd5-8b49-46150667b927.html ÕâЩ¶¼ÊÇORACLEµÄ»ù±¾µÄ¶«Î÷£¬½¨ÒéÂ¥Ö÷ÏÈ¿´Ò»Ð©ORACLE»ù´¡·½ÃæµÄ×ÊÁÏ£¬Èç¹Ù·½Îĵµ¡£ ÕâЩ»ù´¡ÖªÊ¶lZ»¹ÊÇ×Ô¼º¿´×ÊÁÏ×Ô¼ºÃþË÷±È½ÏºÃ£¬±ðÈ˸æËßÄãµÄÓÀÔ¶ÊÇÒ»Ð©Æ¬ÃæµÄ¶«Î÷¡£ÒýÓà ÕâЩ»ù´¡ÖªÊ¶lZ»¹ÊÇ×Ô¼º¿´×ÊÁÏ×Ô¼ºÃþË÷±È½ÏºÃ£¬±ðÈ˸æËßÄãµÄÓÀÔ¶ÊÇÒ»Ð©Æ¬ÃæµÄ¶«Î÷¡£ °¥¡¡ ¹Ø¼üÎÒÊÇ¿´²»¶®°¡£¬ÕâºÜÈÃÎÒÓôÃÆ¡£ÎÒѧµÄ¶«Î÷¶¼ÊÇ´Óʵ¼ù¹ýÀ´µÄ£¬Ö®ºó²Åż¶û¿´¿´ÊéѧϰһЩµ×²ãµÄ¶«Î÷¡£¹Ø¼ü¸Õ¿ªÊ¼Ì«·Ñʱ¼äÁË£¬¹¤×÷Ò
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......