__________________
ÄãµÄÐÄÐØÓжà´ó£¬ÄãµÄÎę̀¾ÍÓжà´ó£¡
MSN: m77m78@188.com
ÌáÎʵÄÖÇ»Ûfor oracle:
1.³¢ÊÔÔÚgoogle,ÂÛ̳£¬metalink,online documentÀïËÑË÷¡£
2.дÇå³þÄãµÄÖ´ÐÐlog,±¨´íÐÅÏ¢£¬Ð´Çå³þDB version , OS
3.Instance ·½ÃæµÄÎÊÌ⣬ÇëÌù³öalertlog
4.ÍøÂçÎÊÌ⣬Ìù³öserver µÄlistener.ora , sqlnet.ora ÔËÐÐlsnrctl status , Ìù³öclient µÄ tnsnames.ora , sqlnet.ora ,ÔËÐÐtnsping
5.DB×ÜÌåÐÔÄÜÎÊÌ⣬ÇëÓÚpeak time ×ö statspack,ÉÏ´«statspack report¡£¸½ÉÏCPU/MEMÅäÖã¬ÒÔ¼° CPU IDLE/free menory µÄÇé¿ö
6.SQLÐÔÄÜÎÊÌ⣬Áгöµ±Ç°SQL,ÒÔ¼°Ö´Ðмƻ®¡£Í¬Ê±Ó¦Ìṩ±í½á¹¹£¬indexÇé¿ö£¬TableµÄrecordÊý¡£CBO/RBO,tableÊÇ·ñanalyzeµÈÐÅÏ¢¡£
7.È·±£ÄãµÄÎÊÌâÊÇOracleÏà¹Ø¡£
|