±¾Îĵİ¢Àï°Í°ÍÊý¾Ý¿âÃæÊÔÌâÖ÷ÒªÕë¶ÔÓÚOracle DBA,ÌâÄ¿¿ÉÒÔÊDZÊÊÔÌ⣬Ҳ¿ÉÒÔ¿ÚÍ·»Ø´ð¡£
ÒÔÏÂÌâÄ¿£¬¿É¸ù¾Ý×Ô¼ºÇé¿öÌôÑ¡ÌâÄ¿×÷´ð£¬²»±ØÈ«²¿×÷´ð.ÄúÒ²¿ÉÒÔ¾ÍÏà¹ØÎÊÌâÖ±½ÓÕÒ¸ºÔðÃæÊÔÈËÔ±ÃæÊö¶ø²»±Ê´ð¡¡
Ò»:SQL tuning Àà
1:Áоټ¸ÖÖ±íÁ¬½Ó·½Ê½
2:²»½èÖúµÚÈý·½¹¤¾ß£¬ÔõÑù²é¿´sqlµÄÖ´Ðмƻ®
3:ÈçºÎʹÓÃCBO,CBOÓëRULEµÄÇø±ð
4:ÈçºÎ¶¨Î»ÖØÒª(ÏûºÄ×ÊÔ´¶à)µÄSQL
5:ÈçºÎ¸ú×Ùij¸ösessionµÄSQL
6:SQLµ÷Õû×î¹Ø×¢µÄÊÇʲô
7:˵˵Äã¶ÔË÷ÒýµÄÈÏʶ(Ë÷ÒýµÄ½á¹¹¡¢¶ÔdmlÓ°Ïì¡¢¶Ô²éѯӰÏ졢ΪʲôÌá¸ß²éѯÐÔÄÜ)
8:ʹÓÃË÷Òý²éѯһ¶¨ÄÜÌá¸ß²éѯµÄÐÔÄÜÂð Ϊʲô
9:°ó¶¨±äÁ¿ÊÇʲô °ó¶¨±äÁ¿ÓÐʲôÓÅȱµã
10:ÈçºÎÎȶ¨(¹Ì¶¨)Ö´Ðмƻ®
11:ºÍÅÅÐòÏà¹ØµÄÄÚ´æÔÚ8iºÍ9i·Ö±ðÔõÑùµ÷Õû£¬ÁÙʱ±í¿Õ¼äµÄ×÷ÓÃÊÇʲô
12:´æÔÚ±íT(a,b,c,d),Òª¸ù¾Ý×Ö¶ÎcÅÅÐòºóÈ¡µÚ21¡ª30Ìõ¼Ç¼ÏÔʾ£¬Çë¸ø³ösql
¶þ:Êý¾Ý¿â»ù±¾¸ÅÄîÀà
1:pctused and pctfree ±íʾʲôº¬ÒåÓÐʲô×÷ÓÃ
2:¼òµ¥ÃèÊötable / segment / extent / blockÖ®¼äµÄ¹Øϵ
3:ÃèÊötablespaceºÍdatafileÖ®¼äµÄ¹Øϵ
4:±¾µØ¹ÜÀí±í¿Õ¼äºÍ×Öµä¹ÜÀí±í¿Õ¼äµÄÌص㣬ASSMÓÐʲôÌصã
5:»Ø¹ö¶ÎµÄ×÷ÓÃÊÇʲô
6:ÈÕÖ¾µÄ×÷ÓÃÊÇʲô
7:SGAÖ÷ÒªÓÐÄÇЩ²¿·Ö£¬Ö÷Òª×÷ÓÃÊÇʲô
8:Oracleϵͳ½ø³ÌÖ÷ÒªÓÐÄÄЩ£¬×÷ÓÃÊÇʲô
Èý:±¸·Ý»Ö¸´Àà
1:±¸·ÝÈçºÎ·ÖÀà
2:¹éµµÊÇʲôº¬Òå
3:Èç¹ûÒ»¸ö±íÔÚ2004-08-04 10:30:00 ±»drop£¬ÔÚÓÐÍêÉƵĹ鵵ºÍ±¸·ÝµÄÇé¿öÏ£¬ÈçºÎ»Ö¸´
4:rmanÊÇʲô£¬ÓкÎÌصã
5:standbyµÄÌصã
6:¶ÔÓÚÒ»¸öÒªÇó»Ö¸´Ê±¼ä±È½Ï¶ÌµÄϵͳ(Êý¾Ý¿â50G,ÿÌì¹éµµ5G)£¬ÄãÈçºÎÉè¼Æ±¸·Ý²ßÂÔ
ËÄ:ϵͳ¹ÜÀíÀà
1:¶ÔÓÚÒ»¸ö´æÔÚϵͳÐÔÄܵÄϵͳ£¬Ëµ³öÄãµÄÕï¶Ï´¦Àí˼·
2:Áоټ¸ÖÖÕï¶ÏIO¡¢CPU¡¢ÐÔÄÜ×´¿öµÄ·½·¨
3:¶ÔstatspackÓкÎÈÏʶ
4:Èç¹ûϵͳÏÖÔÚÐèÒªÔÚÒ»¸öºÜ´óµÄ±íÉÏ´´½¨Ò»¸öË÷Òý£¬Äã»á¿¼ÂÇÄÇЩÒòËØ£¬ÈçºÎ×öÒÔ¾¡Á¿¼õС¶ÔÓ¦ÓõÄÓ°Ïì
5:¶Ôraid10ºÍraid5ÓкÎÈÏʶ