ITPUB¼¼Êõ´ÔÊéµÚÈý²á¡¶ÉîÈëdz³öOracle-DBAÈëÃÅ¡¢½ø½×ÓëÕï¶Ï°¸Àý¡·¼´½«ÓÉÈËÃñÓʵç³ö°æÉç³ö°æ, µÚÒ»²á¡¶OracleÊý¾Ý¿âDBAרÌâ¼¼Êõ¾«´â¡·ºÍµÚ¶þ²á¡¶OracleÊý¾Ý¿âÐÔÄÜÓÅ»¯¡·ÈÈÊÛÖÐ
×÷Õß:¸Ç¹úÇ¿(eygle)
±¾Êé·ÖΪ9Õ£¬¾ßÌå½á¹¹»®·ÖÈçÏ¡£
1 µÚÒ»Õ£ºÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ£¬´Ó»ù´¡ÈëÊÖ£¬½²½âOracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ£¬²¢ÉîÈë̽ÌÖÊý¾Ý¿âÆô¶¯¹Ø±ÕµÄºËÐı¾Öʼ°ÄÚ²¿´¦Àí¡£
1 µÚ¶þÕ£º²ÎÊý¼°²ÎÊýÎļþ£¬ÕâÒ»²¿·Ö´ÓOracleÆô¶¯±ØÐèµÄ²ÎÊýÎļþÈëÊÖ£¬½²½âÖØÒª²ÎÊý¡¢²ÎÊýÎļþ¶ÔÓÚOracleµÄ×÷Ó㬲¢½áºÏRAC»·¾³£¬Oracle10g»·¾³½éÉܲÎÊýÎļþµÈµÄ²»¶Ï¸Ä½øºÍ±äǨ¡£
1 µÚÈýÕ£ºÊý¾Ý×ֵ䣬ÉîÈëµ½Êý¾Ý¿âµÄºËÐÄ£¬È«ÃæÁ˽âÊý¾Ý×ÖµäµÄ»úÖÆºÍÖØÒªÐÔ¡£
1 µÚËÄÕ£ºÄÚ´æ¹ÜÀí£¬OracleµÄÄÚ´æ¹ÜÀí·Ç³£ÖØÒª£¬±¾Õ¾ÍSGA¡¢PGAµÄ¹ÜÀí½øÐÐ̽ÌÖ£¬²¢ÉîÈë½éÉÜOracleÄÚ´æ¹ÜÀí¼¼ÊõÔÚOracle8i/9i/10g²»Í¬°æ±¾ÖеıäǨ¡£
1 µÚÎåÕ£ºBuffer CacheÓëShared PoolÔÀí£¬±¾ÕÂÉîÈë½éÉÜÁËBuffer CacheºÍShared PoolµÄÔÀí£¬²¢Éæ¼°ãÅËøºÍÈȵã¿éµÈÉîÈë»°Ìâ¡£
1 µÚÁùÕ£ºÖØ×ö£¬ÖØ×ö»úÖÆÊÇOracle»Ö¸´µÄ±£ÕÏ£¬±¾ÕÂÕë¶ÔOracleµÄÖØ×ö»úÖÆ½øÐÐ̽ÌÖ£¬²¢Éæ¼°ÖØ×öµÄÄÚ²¿ÔÀí¼°¹¤×÷»úÖÆ¡£
1 µÚÆßÕ£º»Ø¹öÓë³·Ïú£¬»Ø¹öºÍÊÂÎñÃÜÇÐÏà¹Ø£¬±¾Õ´ӻù´¡³ö·¢£¬½éÉÜOracleµÄ»Ø¹ö»úÖÆ£¬½ø¶øÉîÈëÑо¿ºÍ̽Ìֻعö»úÖÆµÄÄÚ²¿²Ù×÷¼°ORA-01555´íÎóµÈÏà¹ØÖªÊ¶¡£
1 µÚ°ËÕ£ºµÈ´ýʼþ£¬µÈ´ýʼþÔÚÊý¾Ý¿âÐÔÄÜÕï¶ÏÖÐÆð׿«ÎªÖØÒªµÄ×÷Óã¬ÔÚ²»Í¬°æ±¾ÖУ¬OracleÒ»Ö±ÔÚ²»¶Ï¼ÓÇ¿µÈ´ýʼþµÄ¹¦ÄÜ£¬±¾Õ´ӵȴýʼþÈëÊÖ£¬½øÒ»²½½²½âÊý¾Ý¿âÐÔÄÜÕï¶ÏºÍÓÅ»¯ÖªÊ¶¡£
1 µÚ¾ÅÕ£ºÐÔÄÜÕï¶ÏÓëSQLÓÅ»¯£¬ÕâÒ»ÕÂÊÇʵ¼ùµÄ×ܽᣬͨ¹ýһЩʵ¼ùµÄ°¸Àý£¬½éÉÜÒ»ÖÖ˼·ºÍ·½·¨¸ø´ó¼Ò£¬½â¾öÎÊÌâÊÇѧϰµÄ×îÖÕÄ¿µÄ¡£
¹ØÓÚ±¾Êé
¸ù¾ÝGartner¹«Ë¾µÄ×îÐÂͳ¼ÆÊý¾Ý£¬ÔÚ2005Ä꣬OracleÊý¾Ý¿âÒÔ48.6%µÄÊг¡Õ¼ÓÐÂʼÌÐøÎȾӹØÏµÊý¾Ý¿âÊг¡µÄÊ×룬ÔÚ¹ýÈ¥ÕâÒ»ÄêÖУ¬¹úÄÚµÄOracle´ÓÒµÊг¡ºÍѧϰ»·¾³¶¼ÓÐÁ˺ܴóµÄ·¢Õ¹ºÍ½ø²½£¬Êг¡½øÒ»²½¹æ·¶ºÍ³ÉÊ죬´ÓÊÂÊý¾Ý¿â¹ÜÀí¹¤×÷µÄÅóÓÑÃÇÒ²Ô½À´Ô½¶à¡£
ΪÁËÈøü¶à½øÈëOracleÁìÓòµÄÅóÓÑÄܹ»¿ìËÙÁ˽âºÍÕÆÎÕOracle¼¼Êõ£¬Èþ߱¸Ò»¶¨¾ÑéºÍ»ýÀÛµÄOracle´ÓÒµÈËÔ±¼ÌÐøÉîÈëѧϰ£¬×÷ÕßÇãÁ¦×«Ð´Á˱¾Êé¡£
±¾Êé×÷Õß»îÔ¾ÓÚ¹úÄÚÖøÃûOracle¼¼ÊõÂÛ̳ITPUB£¨
www.itpub.net£©£¬²¢È«Á¦´òÔì¹úÄÚ×î¾ßÓ°ÏìÁ¦µÄ¸öÈËOracle¼¼ÊõÕ¾µãEygle.com£¨
www.eygle.com£©£¬±¾Êé´Ó»ù´¡³ö·¢£¬Öð²ãÉîÈ룬²¢½áºÏʵ¼Ê¹¤×÷ÖеÄÕï¶Ï°¸Àý½øÐÐÈ«Ãæ½²½â£¬Á¦Í¼´Óµãµ½Ã棬ÈöÁÕß¶Ôÿ¸öÖ÷Ìâ¶¼ÓÐÉîÈëµÄÁ˽âºÍÈÏʶ¡£
±¾ÊéÊÇITPUB¼¼Êõ´ÔÊéµÄµÚÈý±¾£¬ÔÚ¡¶OracleÊý¾Ý¿âDBAרÌâ¼¼Êõ¾«´â¡·ºÍ¡¶OracleÊý¾Ý¿âÐÔÄÜÓÅ»¯¡·¶þÊé³ö°æµÄ2Äê¶àÒÔÀ´£¬ITPUBºÍ OracleÊг¡¶¼ÓÐÁ˳¤×ãµÄ·¢Õ¹£¬Ï£Íû±¾ÊéµÄ³öÏÖÄÜΪ¶ÁÕß´øÀ´¸üÉîÈëµÄ¼¼Êõ֪ʶºÍ¸ü¶àµÄʵ¼ù¾Ñé¡£
±¾ÊéÌØµã
ĿǰÊг¡ÉϵÄOracleÊé¼®ÆÕ±é´æÔÚµÄÎÊÌâÊÇģʽµ¥Ò»£¬ÒªÃ´Ö»½²»ù´¡ÖªÊ¶£¬ÒªÃ´²àÖØ´úÂë±à³ÌʵÀý£¬ÒªÃ´Õë¶Ô¾ßÌåµÄ°æ±¾ÌØÐÔ£¨Oracle8i/Oracle9i/Oracle10gµÈ£©£¬ÒªÃ´È±ÉÙʵ¼ùÓ¦ÓüìÑ飬ºÜÉÙÄܶÔOracleÏà¹ØÖªÊ¶½øÐÐÈ«ÃæÉîÈë½²½â¡£
±¾ÊéÕë¶ÔÕâЩÎÊÌ⣬´Ó»ù´¡ÖªÊ¶ÈëÊÖ£¬ÔÙ½øÐÐÉîÈëÑо¿£¬½áºÏÐÔÄܵ÷Õû¡¢Õï¶Ï°¸Àýʵ¼ù£¬½«OracleÖªÊ¶È«Ãæ¡¢ÏµÍ³¡¢ÉîÈëµÄÕ¹ÏÖ¸ø¶ÁÕߣ»±¾ÊéÄÚÈݸüÉæ¼°Oracle8i/Oracle9i/Oracle10g£¬½«OracleµÄ°æ±¾±ä»¯£¬¹¦ÄܸĽø£¬Ò»ÒÔ¹áÖ®µÄÕ¹ÏÖ³öÀ´£¬Èôó¼Ò¿´µ½ÕâЩ±ä¸ïµÄÕæÕýÔÒòÒÔ¼°OracleµÄ²»¶Ï¼¼Êõ´´Ð£¬Í¨¹ýÕæÊµ°¸ÀýµÄѧϰ£¬¸ü¿ÉÒÔ¼ÓÉî´ó¼Ò¶ÔÏÖʵ»·¾³µÄÁ˽⣬´Ó¶øÌá¸ßʵ¼ùÄÜÁ¦¡£
±¾ÊéÊÇ×÷Õß¶àÄêʵ¼ù¹¤×÷µÄ»ýÀÛºÍ×ܽᣬ¸÷ƪÕ¸ü´ÓDBAµÄ³É³¤Àú³ÌÈëÊÖ£¬Òýµ¼´ó¼Ò¿ìËÙ½øÈë²¢ÉîÈëOracle֪ʶµÄ¹ú¶È¡£
±¾Êé¼ÌÐø¹á³¹ÁË×÷Õß¡°Óɵ㵽ÏßÔÙ¼°Ã桱µÄѧϰ·½·¨£¬¼È¿ÉÒÔÈóõѧÕ߲ο¼Ñ§Ï°£¬ÓÖ¿ÉÒÔ°ïÖú¾ß±¸Ò»¶¨»ù´¡µÄÖм¶DBA½øÐнø½×ѧϰ£¬²»Í¬²ã´ÎµÄѧϰÕß¶¼ÄÜ´Ó±¾ÊéµÄ²»Í¬ÄÚÈÝÖÐÊÜÒæ¡£
±¾ÊéµÄ¶ÁÕß¶ÔÏó
±¾ÊéÊÊÓÃÓÚ´òËã½øÈëOracleÁìÓòµÄ³õѧÕߣ¬Ò²ÊÊÓÃÓھ߱¸Ò»¶¨Êý¾Ý¿â»ù´¡¡¢´òËãÉîÈëѧϰOracle¼¼ÊõµÄÊý¾Ý¿â´ÓÒµÈËÔ±£¬ÓÈÆäÊÊÓÃÓÚÈëÃÅ¡¢½ø½×ÒÔ¼°Ï£ÍûÉîÈëÑо¿Oracle¼¼ÊõµÄÊý¾Ý¿â¹ÜÀíÈËÔ±£»
±¾ÊéÒ²¿ÉÒÔ×÷Ϊ¸÷´óÖÐרԺУÏà¹Ø×¨ÒµµÄ½Ìѧ¸¨µ¼ºÍ²Î¿¼ÓÃÊ飬»ò×÷ΪÏà¹ØÅàѵ»ú¹¹µÄÅàѵ½Ì²Ä¡£
ÁíÍâ,ITPUB¼¼Êõ´ÔÊéµÚÒ»²á¡¶OracleÊý¾Ý¿âDBAרÌâ¼¼Êõ¾«´â¡·ºÍµÚ¶þ²á¡¶OracleÊý¾Ý¿âÐÔÄÜÓÅ»¯¡·¼ÌÐøÈÈÊÛÖÐ,Ïêϸ¼û
http://book.itpub.net/
±¾Êé·âÃæ:
±¾ÊéÍøÉÏÊéµêÔ¤ÊÛ:
http://www.dearbook.com.cn/book/110471