Oracle Management ServerÅäÖÃ
Oracle Management ServerÅäÖò½ÖèÈçÏ£º
1¡¢Ê¹ÓÃenterprise manager configuration assistant½¨Á¢µµ°¸×ÊÁÏ¿â
ÆäÖпÉÑ¡Ôñн¨Ò»¸öÊý¾Ý¿âʵÀý»òÕßÔÚÒÑÓÐÊý¾Ý¿âʵÀýÖÐн¨×ÊÁϿ⣨н¨±í¿Õ¼ä£©¡£
2¡¢Æô¶¯management server
3¡¢ÔËÐÐenterprise manage console£¬Ñ¡ÔñµÇ¼µ½management server
µÇ¼Ãûsysman£¬³õʼÃÜÂëoem_temp¡£µÇ¼ºó»áÒªÇóÐÞ¸ÄÃÜÂë¡£
4¡¢½«Òª¹ÜÀíµÄÊý¾Ý¿âÌí¼Óµ½Ä¿Â¼Ê÷ÖС£Í¨¹ýµ¼º½Æ÷ÖеĽڵãËÑË÷¡£
Òª¹ÜÀíµÄÊý¾Ý¿â±ØÐ뿪http serverºÍ¿ªagent server¡£
5¡¢ÔÚ¹¤¾ßÖм´¿ÉÅäÖñ¸·Ý¹ÜÀí¡£
1£©ÒªÔÚÅäÖÃÖеÄÊ×Ñ¡ÏÊ×Ñ¡Éí·ÝÖ¤Ã÷ÖмÓÈëÒª±¸·ÝµÄÊý¾Ý¿â·þÎñÆ÷µÄÊ×Ñ¡Éí·ÝÖ¤Ã÷¡£
2£©ÔÚÒª±¸·ÝµÄÊý¾Ý¿â·þÎñÆ÷ÉÏÒªÊÚÓè²½Öè1£©Ê×Ñ¡Éí·ÝÖ¤Ã÷ËùÓÃÓû§Åú´¦ÀíȨÏÞ£º¹ÜÀí¹¤¾ß
£±¾µØ°²È«ÉèÖã±¾µØ²ßÂÔ£Óû§È¨ÀûÖ¸ÅÉÖÐÉèÖá£
Ïà¹ØÎĵµ£º
OracleϵÁУº¼Ç¼£¨Record£©
Ò»£¬Ê²Ã´ÊǼǼ£¨Record£©£¿
Óɵ¥ÐжàÁеıêÁ¿¹¹³ÉµÄ¸´ºÏ½á¹¹¡£¿ÉÒÔ¿´×öÊÇÒ»ÖÖÓû§×Ô¶¨ÒåÊý¾ÝÀàÐÍ¡£×é³ÉÀàËÆÓÚ¶àάÊý×é¡£
½«Ò»¸ö»ò¶à¸ö±êÁ¿·â×°³ÉÒ»¸ö¶ÔÏó½øÐвÙ×÷¡£ÊÇÒ»ÖÖÁÙʱ¸´ºÏ¶ÔÏóÀàÐÍ¡£
¼Ç¼¿ÉÒÔÖ±½Ó¸³Öµ¡£RECORD1 :=RECORD2£»
¼Ç¼²»¿ÉÒÔÕûÌå±È½Ï. ......
Oracle Database 10g ÌṩÁËÒ»¸öÏÔÖø¸Ä½øµÄ¹¤¾ß£º×Ô¶¯¹¤×÷¸ºÔØÐÅÏ¢¿â (AWR:Automatic Workload Repository)¡£Oracle ½¨ÒéÓû§ÓÃÕâ¸öÈ¡´ú Statspack¡£AWR ʵÖÊÉÏÊÇÒ»¸ö Oracle µÄÄÚÖù¤¾ß£¬Ëü²É¼¯ÓëÐÔÄÜÏà¹ØµÄͳ¼ÆÊý¾Ý£¬²¢´ÓÄÇЩͳ¼ÆÊý¾ÝÖе¼³öÐÔÄÜÁ¿¶È£¬ÒÔ¸ú×ÙDZÔÚµÄÎÊÌâ¡£Óë Statspack ²»Í¬£¬¿ìÕÕÓÉÒ»¸ö³ÆÎª MMON µÄеĺó ......
½ñÄêµÄOracleÈ«Çò´ó»áÓÚ10ÔÂ11ÈÕ£15ÈÕÔÚÃÀ¹ú¾É½ðɽµÄMosconeÖÐÐÄÒѾÀ¿ªÐòÄ»ÁË¡£
¡¡¡¡ Oracle¶ÔSun¹«Ë¾µÄ³¤ÆÚ¼Æ»®ÎÞÒÉÊDZ¾´ÎOOW´ó»áµÄ½¹µã¡£µ«ÔÚ̸ÂÛÕâ¸ö»°Ìâ֮ǰ£¬ÎÒÃÇ×¼±¸ÁËÒ»×é´ó»áµÄÓÐȤÊý¾Ý£¬ÏÈÈôó¼Ò¶Ô±¾´Î´ó»áÓиöÕûÌåµÄÓ¡Ïó¡£
¡¡¡¡ÓйØÕû¸ö´ó»áµÄÊý×Ö£º
¡¡¡¡· ½ü4.3ÍòÈ˵½»á
¡¡¡¡· ΪÃÀ¹ ......
ÎÒÃǶ¼¶¼ÖªµÀÔÚcontrolfileÖмǼ×Åÿһ¸öarchivelogµÄÏà¹ØÐÅÏ¢£¬µ±È»ÃÇÔÚOSϰÑÕâЩÎïÀíÎļþdeleteµôºó£¬ÔÚÎÒÃǵÄ
controlfileÖÐÈÔÈ»¼Ç¼×ÅÕâЩarchivelogµÄÐÅÏ¢£¬ÔÚoracleµÄOEM¹ÜÀíÆ÷ÖÐÓпÉÊÓ»¯µÄÈÕÖ¾Õ¹ÏÖ³ö£¬µ±ÎÒÃÇÊÖ¹¤Çå³ýarchiveĿ¼ÏµÄÎļþºó£¬ÕâЩ¼Ç¼²¢Ã»Óб»ÎÒÃÇ´ÓcontrolfileÖÐÇå³ýµô£¬Ò²¾ÍÊÇoracle²¢²» ......