! „sáØV  s "-5<ELT\bjouËÑÖÛâçëñøþ 27@FLSZahpx{~ƒ‹’˜Ÿ¥¬´»ÀÈùdn„˜„�š¦®í %-29<@DIOV`int{ƒ†” ÔÝèô ´ »=HÎÒ×Ûßãç•‹Ÿ¶Ìåñ÷ü #(-QU[`cgkps2vŒ½c¯Ì¿¼ÂÇÔÚÖ÷»úÖÐÌí¼Ó¸ü¶à CPU, »òÌí¼ÓΪÆäËûÖ÷»úÉϵÄÊý¾Ý¿âÌṩ·þÎñµÄʵÀý¡£CPU ²»ÊÇ´ËʵÀýµÄÆ¿¾±¡£¶Ô SQL_ID Ϊ "%s" µÄ SQL Óï¾äÔËÐÐ SQL ÓÅ»¯Ö¸µ¼¡£ Ö÷»ú CPU ÊÇÆ¿¾±, ʵÀýÕýÔÚÏûºÄÖ÷»ú CPU µÄ %s\\%¡£ËùÓеȴýʱ¼ä½ÔÒòµÈ´ý CPU ¶øÑÓ³¤¡£·¢ÏÖ´æÔÚ²¢·¢¶Áд²Ù×÷µÄÀàÐÍΪ "%s" µÄÈȿ顣´Ë¿éÊôÓÚ¶Î "%s.%s", ÊÇ¿é %s, ÔÚ %s ÎļþÖС£¶ÔÊý¾Ý¿â¿éµÄ¶ÁдÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£È»¶ø, ´ËÕùÓò»ÊÇÓɵ¥¸ö¶ÔÏóÔì³ÉµÄ¡£¹À¼Æ¼õÉÙµÄÊý¾Ý¿âʱ¼ä (΢Ãë)¡£& j š ý 'åÑо¿Ó¦ÓóÌÐòÂß¼­, ÒÔÕÒ³ö¶Ô´Ë¿éÖеÄÊý¾ÝµÄ²¢·¢¶Áд²Ù×÷Èç´ËƵ·±µÄÔ­Òò¡£¶Ô "»º³åÇøÃ¦" ʼþµÄµÈ´ý²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÖÁÉÙ·¢ÏÖ %s Ìõ´øÓÐ PLAN_HASH_VALUE %s µÄ SQL Óï¾äÕýÔÚʹÓÃ×ÖÃæÖµ¡£Çë²ÎÔÄ V$SQL Öиà SQL Óï¾äµÄʾÀý¡£¶ÔÊý¾Ý¿â¿éµÄ¶ÁдÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£¶ÔÓÚ±í¿Õ¼ä "%s" (°üº¬ %s "%s.%s", ¶ÔÏó ID Ϊ %s), ¿¼ÂÇÔÚ±¾µØ¹ÜÀíµÄ±í¿Õ¼äÖÐʹÓà ORACLE ½¨ÒéµÄ×Ô¶¯¶Î¿Õ¼ä¹ÜÀí½â¾ö·½°¸¡£ÁíÍâ, Ò²¿ÉÒÔ½«´Ë¶ÔÏóÒÆ¶¯µ½Ê¹ÓÃ×Ô¶¯¶Î¿Õ¼ä¹ÜÀíÔÚ±¾µØ½øÐйÜÀíµÄÆäËû±í¿Õ¼äÖС£ ,‰ÃEŠò¿¼ÂÇʹÓÃÒÔÏ·½·¨¶Ô %s "%s.%s" (¶ÔÏó ID Ϊ %s) ½øÐÐÉ¢ÁзÖÇø: ½«²¢·¢ DML ƽ¾ù·Ö²¼ÔÚ¶à¸ö·ÖÇøÉÏ¡£¿¼ÂÇʹÓøü´óµÄ PCTFREE ÖµÖØ½¨ %s "%s.%s" (¶ÔÏó ID Ϊ %s)¡£SQL_ID Ϊ "%s" µÄ UPDATE Óï¾äÊܵ½ "»º³åÇøÃ¦" µÈ´ýµÄÑÏÖØÓ°Ïì¡£SQL_ID Ϊ "%s" µÄ INSERT Óï¾äÊܵ½ "È«¾Ö¸ßËÙ»º´æ»º³åÇøÃ¦" µÄÑÏÖØÓ°Ï졣ʵÀýÕ¼ÓÃÁË´óÁ¿ CPU ʱ¼ä¡£È»¶ø, ²¢²»´æÔÚÏÔÖøÓ°Ïì CPU ¸ºÔØµÄ SQL Óï¾ä¡£¶Ô "%s" ÀàÐ͵ÄÊý¾Ý¿â¿éµÄÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£´Ë¿éÊôÓÚ¶Î "%s.%s", ±êʶ´Ë¿éµÄ¿éºÅΪ %s, ÎļþºÅΪ %s¡£2‹½ï4f«׿¼ÂÇʹÓÃÒÔÏ·½·¨¶Ô %s "%s.%s" (¶ÔÏó ID Ϊ %s) ½øÐзÖÇø: ½«²¢·¢ DML ƽ¾ù·Ö²¼ÔÚ¶à¸ö·ÖÇøÉÏ¡£¶Ô»º³åÇø¸ßËÙ»º´æãÅËøµÄÕùÓò¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£¿¼ÂÇΪ SQL_ID Ϊ "%s" µÄ INSERT Óï¾äʹÓÃÊý×é½Ó¿Ú¡£SQL_ID Ϊ "%s" µÄ UPDATE Óï¾äÊܵ½ "È«¾Ö¸ßËÙ»º´æ»º³åÇøÃ¦" µÄÑÏÖØÓ°Ïì¡£DBMS_PIPE.PUT µ÷ÓÃÖеĵȴý²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£SQL_ID Ϊ "%s" µÄ DELETE Óï¾äÊܵ½ "È«¾Ö¸ßËÙ»º´æ»º³åÇøÃ¦" µÄÑÏÖØÓ°Ïì¡£¿¼ÂÇÔö¼Ó¹ÜµÀ¶Á½ø³ÌµÄÊýÁ¿»òÌá¸ß¶Á½ø³ÌµÄËÙ¶È¡£ >m±á+ b!ˆ"²Ø¿¼ÂÇʹÓà DBMS_PIPE ³ÌÐò°üÔö¼ÓËù´´½¨¹ÜµÀµÄ´óС¡£Ê¹ÓÃÌṩµÄÐÅÏ¢, ¸ú×ÙÆðÒòÓÚÓ¦ÓóÌÐòÖÐµÄ SELECT Óï¾äµÄ¶ÔÏóÕùÓõÄÔ­Òò¡£DBMS_PIPE.PUT µ÷ÓÃÖеĵȴýÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "²¢·¢" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "²¢·¢" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýʼþ "%s" (ÔڵȴýÀà "%s" ÖÐ) ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "¹ÜÀí" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "Ó¦ÓóÌÐò" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "¼¯Èº" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ #J$p%–&¼'æ()2*V+z,ž-ÂêµÈ´ýÀà "Ìá½»" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "ÅäÖÃ" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "ÍøÂç" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "µ÷¶È³ÌÐò" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "Ó¦ÓóÌÐò" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "¹ÜÀí" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "¼¯Èº" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "Ìá½»" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "ÅäÖÃ" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "ÍøÂç" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "µ÷¶È³ÌÐò" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£.8/§0ß12I3x4±5ÙýÔÚ %s "%s.%s" (¶ÔÏó ID Ϊ %s) Öмì²âµ½ÁËÑÏÖØµÄÐÐÕùÓá£Ê¹ÓÃÖ¸¶¨µÄ×èÈû SQL Óï¾äÔÚÓ¦ÓóÌÐòÂß¼­Öиú×ÙÐÐÕùÓÃµÄÆðÒò¡£¼¯ÈºÖÐµÄ %s "%s.%s" (¶ÔÏó ID Ϊ %s) ÉÏ´æÔÚ´óÁ¿¶ÁдÕùÓá£Ê¹Óà "DBMS_LOCK" ʱ, ·¢ÏÖ SQL_ID Ϊ "%s" µÄ SQL Óï¾äÕýÔڵȴýËø¡£SQL_ID Ϊ "%s" µÄ SQL Óï¾äÔÚÐÐËøÉϱ»×èÈû¡£%s "%s.%s" (¶ÔÏó ID Ϊ "%s") ±»Ëø¶¨Á˺ܳ¤Ê±¼ä¡£µÈ´ýʹÓà "DBMS_LOCK" ³ÌÐò°ü»ñÈ¡µÄËøÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÐòÁиßËÙ»º´æÎ´ÃüÖÐÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£±íËøµÄÕùÓõȴýÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£627w8Â9â:;^<§俼ÂÇͨ¹ýÉèÖà "log_archive_max_processes" ²ÎÊýµÄÖµÌí¼Ó¸ü¶àµÄ¹éµµ½ø³Ì¡£µ±²¢·¢ÐÞ¸ÄͬһÊý¾Ý¿â¿éµÄÊÂÎñ´¦ÀíÊý´ïµ½ÏÞÖÆÊ±, ÕâЩÊÂÎñ´¦Àí½«µÈ´ý ITL Èë¶Ó¡£ÑéÖ¤ÔöÁ¿´«µÝÊÇ·ñÓÃÓÚ±¸ÓÃÊý¾Ý¿â¡£·¢ÏÖ±í¿Õ¼ä %s ´¦ÓÚ±¸·Ýģʽ¡£ÑéÖ¤ÕâÊÇ·ñÊÇÕýÈ·µÄ¡£Ñо¿Ó¦ÓóÌÐòÂß¼­, Á˽âͨ¹ýÔö¼ÓÊÂÎñ´¦ÀíµÄ´óСÀ´¼õÉÙ COMMIT ²Ù×÷ÊýÁ¿µÄ¿ÉÄÜÐÔ¡£¿¼ÂÇͨ¹ýÉèÖà "db_writer_processes" ²ÎÊýÔö¼ÓÊý¾Ý¿âдÈë½ø³Ì (DBWR) µÄÊýÁ¿¡£½«ÈÕÖ¾ÎļþµÄ´óСÔö¼Óµ½ %s M, ÒÔ±ã½«ÖØ×öÐÅÏ¢ÖÁÉÙ±£Áô %s ·ÖÖÓ¡£ =>>o?£@ËA÷BC?D{E¥÷ÔÚÈȱ¸·Ýģʽ϶Աí¿Õ¼äÖ´ÐÐ DML ½«²úÉú¸½¼ÓµÄÖØ×ö¡£ÔÚ¼¯ÈºÖÐ, ¶ÔÊý¾Ý¿â¿éµÄ¶ÁдÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ý¿ÕÏеĻº³åÇø²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£¸ßË®Ïß (HW) Èë¶ÓµÈ´ý²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ITL Èë¶ÓµÈ´ý²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ý¹éµµ½ø³Ì²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ôڵȴý¼ì²éµãÍê³Éʱ, ÈÕÖ¾ÎļþÇл»²Ù×÷²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÈÕÖ¾»º³åÇø¿Õ¼ä²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÔÚÖ´ÐÐ COMMIT ºÍ ROLLBACK ²Ù×÷ʱ, µÈ´ý "ÈÕÖ¾Îļþͬ²½" ʼþ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£F2GRH„I¤JÛK-L™ìÐÐËøµÈ´ý²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£¿Õ¼äÊÂÎñ´¦Àí (ST) Èë¶ÓµÈ´ý²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£±íËøµÈ´ý²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ê¹Óà "DBMS_LOCK" ³ÌÐò°ü»ñÈ¡µÄËø²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£·¢ÏÖ SQL_ID Ϊ "%s" µÄ SQL Óï¾äÕýÔڵȴý %s "%s.%s" (¶ÔÏó ID Ϊ %s) µÄ¸ßË®Ïß (HW)¡£·¢ÏÖ SQL_ID Ϊ "%s" µÄ SQL Óï¾äÕýÔڵȴý¼ÓÈë %s "%s.%s" (¶ÔÏó ID Ϊ %s) ÉϵĸÐÐËȤµÄÊÂÎñ´¦ÀíÁбí (ITL) ¶ÓÁС£¶ÔÓÚ±í¿Õ¼ä "%s", ¿¼ÂÇÔÚ±¾µØ¹ÜÀíµÄ±í¿Õ¼äÖÐʹÓà ORACLE ½¨ÒéµÄ×Ô¶¯¶Î¿Õ¼ä¹ÜÀí½â¾ö·½°¸¡£M8NWO§PóQ%ROSoT¼ö·¢ÏÖ SQL Óï¾äÕý´¦ÓÚÐÐËø¶¨µÈ´ý¡£ÔÚÖ´ÐÐ COMMIT ºÍ ROLLBACK ²Ù×÷ʱ, µÈ´ý "ÈÕÖ¾Îļþͬ²½" ʼþÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ó¦ÓóÌÐòÿ·ÖÖÓÖ´ÐÐ %s ¸öÊÂÎñ´¦Àí, ÿ¸öÊÂÎñ´¦ÀíµÄƽ¾ùÖØ×öÈÕÖ¾´óСΪ %s ×Ö½Ú¡£Êý¾Ý¿âдÈë½ø³Ì (DBWR) ÎÞ·¨Âú×ã¶Ô¿ÕÏлº³åÇøµÄÐèÒª¡£ÐòÁиßËÙ»º´æÎ´ÃüÖв¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£¹éµµ½ø³ÌÎÞ·¨Âú×ãÖØ×öÉú³ÉµÄÐèÇó¡£ÔÚÈȱ¸·Ýģʽ϶Աí¿Õ¼äÖ´ÐÐ DML »á²úÉú¸½¼ÓµÄÖØ×ö, Òò¶øÔö¼ÓÁ˹鵵½ø³ÌµÄ¹¤×÷Á¿¡£Ôڵȴý¼ì²éµãÍê³Éʱ, ÈÕÖ¾ÎļþÇл»²Ù×÷ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£U8V{W©XßYZ?[V\z·Í¨¹ý½« "log_buffer" ²ÎÊýµÄÖµÉèÖÃΪ %s M, Ôö¼ÓÖØ×öÈÕÖ¾»º³åÇøµÄ´óС¡£¶Ô¸ßË®Ïß (HW) Èë¶ÓµÄÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£¿Õ¼äÊÂÎñ´¦Àí (ST) Èë¶ÓµÈ´ýµÄÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ý ITL Èë¶ÓÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£SQL_ID Ϊ "%s" µÄ INSERT Óï¾äÊܵ½ "»º³åÇøÃ¦" µÈ´ýµÄÑÏÖØÓ°Ïì¡£Ö÷»ú CPU ¿ªÏúΪ %s\\%¡£µÈ´ý¿ÕÏлº³åÇøÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£SQL_ID Ϊ "%s" µÄ DELETE Óï¾äÊܵ½ "»º³åÇøÃ¦" µÈ´ýµÄÑÏÖØÓ°Ïì¡£],^˜_È`ôa"b`ÅÑо¿Ó¦ÓóÌÐò»ò²é¿´¶¥¼¶ SQL ÒÔ²éÕÒÈÈÐòÁС£¶ÔÕâЩÐòÁÐʹÓøü´óµÄ¸ßËÙ»º´æ¡£Èç¹ûÔËÐÐ RAC, Ôò±ÜÃâʹÓà ORDER ÉèÖ᣶Իº³åÇø¸ßËÙ»º´æãÅËøµÄÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£¶ÔÏó ID Ϊ "%s" µÄÊý¾Ý¿â¶ÔÏóÒÑËø¶¨ºÜ³¤Ê±¼ä¡£»á»°Á¬½ÓºÍ¶Ï¿ªÁ¬½ÓµÄµ÷ÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£´Ó SQL_ID Ϊ "%s" µÄ SELECT Óï¾äÌáÈ¡½á¹ûʱʹÓøü´óµÄÌáÈ¡Êý×é¡£ORACLE Ç¿ÁÒ½¨Òé²»ÒªÔÚ SYSTEM ±í¿Õ¼äÖд洢ÈκÎÓ¦ÓóÌÐò»òÁÙʱÊý¾Ý¡£Ç뿼Âǽ«´ËÀàÊý¾ÝÒÆ¶¯µ½ÆäËû±í¿Õ¼äÖС£c8dueºfÍgûhSiƒj¿ÿSQL_ID Ϊ "%s" µÄ SELECT Óï¾äÊܵ½ "»º³åÇøÃ¦" µÈ´ýµÄÑÏÖØÓ°Ïì¡£SQL_ID Ϊ "%s" µÄ SELECT Óï¾äÊܵ½ "È«¾Ö¸ßËÙ»º´æ»º³åÇøÃ¦" µÄÑÏÖØÓ°Ïì¡£Êý¾Ý¿âʱ¼ä (΢Ãë)¡£ÊµÀý¼äÏûÏ¢´«ËÍÔÚ´ËʵÀýÉÏÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚ¶©»§µÄËٶȽÏÂý²¢ÇÒÁ÷µÄÈë¶Ó²Ù×÷ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä, Òò´Ë¸Ã²Ù×÷ÔÚÁ÷¿ØÖƵȴýÖб»×èÖ¹¡£ÊµÀý¼äÏûÏ¢´«ËͲ¢Î´ÔÚ´ËʵÀýÉÏÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚ¶©»§µÄËٶȽÏÂý, Òò´ËÁ÷µÄÈë¶Ó²Ù×÷δÔÚÁ÷¿ØÖƵȴýÖб»×èÖ¹¡£Ñо¿Ó¦ÓóÌÐòÒÔ¼õÉÙ¶Î %s.%s (SEGMENT_ID Ϊ %s) µÄʵÀý¼äÏûÏ¢´«ËÍ¡£k&l�mBnˆo¦ÍÑо¿Êý¾Ý¿âʵÀýÖ®¼äµÄÍøÂ绥Á¬µÈ´ýʱ¼äÈç´Ë¸ßµÄÔ­Òò¡£Oracle ÍÆ¼öµÄ½â¾ö·½°¸ÎªÊ¹ÓøßËÙרÓÃÍøÂç¡£Ôö¼ÓÈ«¾Ö¸ßËÙ»º´æ·þÎñ (LMSn) ½ø³ÌµÄÍÌÍÂÁ¿¡£Í¨¹ýÔö¼Ó "gcs_server_processes" ²ÎÊýµÄÖµÔö¼ÓÈ«¾Ö¸ßËÙ»º´æ·þÎñ½ø³ÌµÄÊýÁ¿¡£»òÕß, Èç¹ûÖ÷»úÊÇÊÜ CPU ÏÞÖÆµÄ, Ôò¿¼ÂÇÔö´óÈ«¾Ö¸ßËÙ»º´æ·þÎñ½ø³ÌµÄ²Ù×÷ϵͳÓÅÏȼ¶¡£Èç¹ûÏìӦʱ¼äºÜ³¤, Çë¼ì²éÓ¦ÓóÌÐòÓÃÀ´Á¬½ÓÊý¾Ý¿âµÄ·þÎñ¼¯µÄÅäÖÃÊÇ·ñºÏÀí¡£Ñо¿ %s "%s.%s" ÉϽÏÂýµÄ¶©»§¡£·¢ÏÖ SQL Óï¾äÔì³ÉÁË´óÁ¿ÊµÀý¼äÏûÏ¢´«ËÍ¡£p&qpr®tçuB©µÈ´ýʱ¼äÔ¶¸ßÓÚÔ¤ÆÚµÄ¼¯Èº»¥Á¬µÈ´ýʱ¼äÊÇÔÚ´ËʵÀýÉÏÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼äµÄÔ­Òò¡£ÆäËûʵÀýÖеÄÈ«¾Ö¸ßËÙ»º´æ·þÎñ½ø³Ì (LMSn) ´¦ÀíÇëÇóµÄËٶȲ»¹»¿ì¡£ÆäËû RAC ʵÀý¶ÔÊý¾ÝµÄÕùÓÃÔÚ´ËʵÀýÉÏÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÔÚ´ØÖз¢ÏÖÓÃÓÚ²¢·¢¶Áд²Ù×÷µÄÀàÐÍΪ "%s" µÄÈȿ顣´Ë¿éÊôÓÚ¶Î "%s.%s", ÊÇ¿é %s, ÔÚ %s ÎļþÖС£¶Ô "%s" ÀàÐ͵ÄÊý¾Ý¿â¿éµÄÕùÓÃÔÚ¼¯ÈºÖÐÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£´Ë¿éÊôÓÚ¶Î "%s.%s", ´Ë¿éΪ %s, ÔÚÎļþ %s ÖС£z&{xÉÉÊñË kÔÚ´ØÖз¢ÏÖÓÃÓÚ²¢·¢¶Áд²Ù×÷µÄÀàÐÍΪ "%s" µÄÈȿ顣±êʶ´Ë¿éµÄ¿éºÅΪ %s, ÎļþºÅΪ %s¡£ÔÚ´ØÖз¢ÏÖÓÃÓÚ²¢·¢¶Áд²Ù×÷µÄÈÈÊý¾Ý¿é¡£´Ë¿éÊôÓÚ¶Î "%s.%s", ÊÇ¿é %s, ÔÚ %s ÎļþÖС£µÈ´ýÀà "Óû§ I/O" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ñо¿¸ÄÉÆ¶ÔÁª»úÖØ×öÈÕÖ¾ÎļþµÄ I/O ÐÔÄܵĿÉÄÜÐÔ¡£¶ÔÁª»úÖØ×öÈÕÖ¾ÎļþÖ´ÐÐдÈëµÄƽ¾ù´óСΪ %s K, ÿ´ÎдÈëµÄƽ¾ùʱ¼äΪ %s ºÁÃë¡£Ì,ÍÀÎìÏVÐ|ѬìPGA µÄ´óС²»ºÏÊÊ, µ¼Ö¶ÔÁÙʱ±í¿Õ¼äµÄ¸½¼Ó I/O, ´Ó¶øÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÒòΪÔÚ·ÖÎöÆÚ¼ä¸ü¸ÄÁË "pga_aggregate_target" ²ÎÊýµÄÖµ, ËùÒÔÎÞ·¨½øÐÐÉîÈë·ÖÎö¡£·¢ÏÖ¸ö±ð SQL Óï¾äÔì³ÉÁË´óÁ¿µÄÓû§ I/O µÈ´ý¡£Îļþ %s µÄÐÔÄÜ±ÈÆäËûÎļþµÍµÃ¶à¡£Èç¹û²»ÄÜʹÓà SAME ·½·¨½«ËùÓеÄÎļþÌõ´ø»¯, ¿É¿¼Âǽ«´ËÎļþÌõ´ø»¯ÖÁ¶à¸ö´ÅÅÌ¡£I/O ×ÓϵͳµÄÍÌÍÂÁ¿±ÈÔ¤ÆÚÍÌÍÂÁ¿Ð¡µÃ¶à¡£»º³åÇø¸ßËÙ»º´æ²»¹»´ó, ´Ó¶øµ¼Ö´óÁ¿µÄ¸½¼Ó¶Á I/O¡£·ÇĬÈÏ´óСµÄ¿éµÄ»º³åÇø¸ßËÙ»º´æ²»¹»´ó, ´Ó¶øµ¼Ö´óÁ¿µÄ¸½¼Ó¶Á I/O¡£Ò&ÓlÔÕCÖƒáPGA ´óС²»ºÏÊʵ¼ÖÂÁ˶ÔÁÙʱ±í¿Õ¼äµÄ¸½¼Ó I/O, ´Ó¶øÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚÉèÖÃ·ÏÆúµÄ²ÎÊý "fast_start_io_target", "log_checkpoint_interval" ºÍ "log_checkpoint_timeout" ¶ø²úÉú»º³åÇø¸ßËÙ»º´æÐ´Èë, ´Ó¶øÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚ MTTR ÉèÖÃÌ«µÍ¶ø²úÉúµÄ»º³åÇø¸ßËÙ»º´æÐ´ÈëÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚÈÕÖ¾Îļþ̫С¶ø²úÉúµÄ»º³åÇø¸ßËÙ»º´æÐ´ÈëÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚ¶ÔÏàͬ¶ÔÏóµÄ²¢·¢ DML ºÍ²¢Ðвéѯ¶ø²úÉúµÄ»º³åÇø¸ßËÙ»º´æÐ´Èë¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿ÓкܴóÓ°Ïì¡£×&Ø{ÙÐÚúÛ„ÌÓÉÓÚ DROP ºÍ TRUNCATE ²Ù×÷¶ø²úÉúµÄ»º³åÇø¸ßËÙ»º´æÐ´Èë¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿ÓкܴóÓ°Ïì¡£ÓÉÓÚ ALTER TABLESPACE ²Ù×÷¶ø²úÉúµÄ»º³åÇø¸ßËÙ»º´æÐ´Èë¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿ÓкܴóÓ°Ïì¡£µÈ´ýÀà "Óû§ I/O" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýµ¥¸öÈÕÖ¾ÎļþдÈëµÄƽ¾ùÊÂÎñ´¦ÀíÊýÁ¿Îª %s, ÒѾ­³¬³öÁËÖ÷»ú CPU µÄÊýÁ¿ %s¡£Òò´Ë, ÓÐЩÊÂÎñ´¦Àí±ØÐëµÈµ½ÓпÕÏÐµÄ CPU ºó²ÅÄÜÍê³É COMMIT ²Ù×÷¡£SQL_ID Ϊ "%s" µÄ SQL Óï¾äÔÚ "»º³åÇøÃ¦" µÈ´ýÉÏ»¨·ÑÁË´óÁ¿Ê±¼äÒÔ»ñÈ¡Èȿ顣Ü2ÝdތߢàÏáâG§´óÁ¿ I/O µÈ´ý²»ÊÇÓÉÓÚµ¥¸ö SQL »òÊý¾Ý¿âÓï¾äÔì³ÉµÄ¡£I/O ×ÓϵͳµÄÍÌÍÂÁ¿²»±ÈÔ¤ÆÚÍÌÍÂÁ¿Ð¡ºÜ¶à¡£»º³åÇø¸ßËÙ»º´æ²»¹»´ó¡£µÈ´ýÁÙʱ±í¿Õ¼äµÄ I/O ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚÈÕÖ¾Îļþ´óСºÍ²ÎÊýÉèÖÃÒýÆðµÄ»º³åÇø¸ßËÙ»º´æÐ´Èë²»»áÕ¼ÓôóÁ¿µÄÊý¾Ý¿â I/O¡£»¹Ô­ I/O ¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿Ã»ÓкܴóÓ°Ïì¡£ÓÉÓÚ¶ÔÏàͬ¶ÔÏóµÄ²¢·¢ DML ºÍ²¢Ðвéѯ¶ø²úÉúµÄ»º³åÇø¸ßËÙ»º´æÐ´Èë¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿Ã»ÓкܴóÓ°Ïì¡£ã&ä}åÔæçr¡ÓÉÓÚ DROP ºÍ TRUNCATE ²Ù×÷¶ø²úÉúµÄ»º³åÇø¸ßËÙ»º´æÐ´Èë¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿Ã»ÓкܴóÓ°Ïì¡£ÓÉÓÚ ALTER TABLESPACE ²Ù×÷¶ø²úÉúµÄ»º³åÇø¸ßËÙ»º´æÐ´Èë¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿Ã»ÓкܴóÓ°Ïì¡£¼õСÓÉÓ¦ÓóÌÐòÉú³ÉµÄÖØ×öµÄ´óС¿ÉÒÔ¼õÉÙ¶Ô "ÈÕÖ¾Îļþͬ²½" ʼþµÄµÈ´ýʱ¼ä¡£SQL_ID Ϊ "%s" µÄ SQL Óï¾äÔÚ "È«¾Ö¸ßËÙ»º´æ»º³åÇøÃ¦" ÉÏ»¨·ÑÁË´óÁ¿Êý¾Ý¿âʱ¼äÒÔ»ñÈ¡Èȿ顣ÔÚ %s "%s.%s" (¶ÔÏó ID Ϊ %s) ÉÏÔËÐÐ "¶ÎÖ¸µ¼"¡£è é¢êèë,Ÿ¿¼ÂÇÔö¼Ó I/O ×ÓϵͳµÄÍÌÍÂÁ¿¡£Oracle ½¨ÒéµÄ½â¾ö·½°¸ÊÇʹÓà SAME ·½·¨½«ËùÓÐÊý¾ÝÎļþÌõ´ø»¯¡£Äú¿ÉÄÜ»¹ÐèÒªÔö¼Ó´ÅÅÌÊýÁ¿ÒÔ»ñµÃ¸üºÃµÄÐÔÄÜ¡£Í¨¹ý½« "db_cache_size" ²ÎÊýµÄÖµÉèÖÃΪ %s M, Ôö¼Ó»º³åÇø¸ßËÙ»º´æµÄ´óС¡£Í¨¹ý½« "pga_aggregate_target" ²ÎÊýµÄÖµÉèÖÃΪ %s M, Ôö¼Ó PGA µÄ´óС¡£Oracle ÍÆ¼öµÄ½â¾ö·½°¸ÎªÆôÓà PGA ×Ô¶¯ÄÚ´æ¹ÜÀí¹¦ÄÜ¡£Õâ¿ÉÒÔͨ¹ý½« "pga_aggregate_target" ²ÎÊýÉèÖÃΪ 0 Ö®ÍâµÄÖµÀ´ÊµÏÖ¡£ì,íÌî ï;ð“ñ³íOracle ½¨ÒéʹÓà "fast_start_mttr_target" ²ÎÊý¿ØÖÆ MTTR ÉèÖÃ, ¶ø²»Ê¹Óà "fast_start_io_target", "log_checkpoint_interval" ºÍ "log_checkpoint_timeout" ²ÎÊýÀ´¿ØÖÆ¡£¿¼ÂÇͨ¹ýÔö´ó "fast_start_mttr_target" ²ÎÊýµÄÖµÀ´Ôö¼Ó MTTR ÉèÖá£Oracle ½¨ÒéʹÓá°×Ô¶¯»¹Ô­¹ÜÀí¡±À´¼õÉÙ»¹Ô­ÕùÓ᣿ìÕÕ %s ºÍ %s µÄË¢ÐÂÐèÒª %s ÃëµÄʱ¼ä, Õ¼·ÖÎöʱ¶ÎµÄ %s\\%¡£Õâ¿ÉÄܽµµÍ ADDM ·ÖÎöµÄ¿É¿¿ÐÔ¡£Ã»ÓÐÔËÐÐ ADDM µÄ´óÁ¿Êý¾Ý¿â»î¶¯¡£²é³öÓ¦ÓóÌÐòÖÐµÄ %s "%s.%s" (¶ÔÏó ID Ϊ %s) ÉÏÕùÓõÄÔ­Òò¡£ò2óiô�õµö÷Dø�¿Ñо¿Éæ¼°¶Ô ID Ϊ %s µÄÊý¾Ý¿â¶ÔÏóµÄ I/O µÄÓ¦ÓóÌÐòÂß¼­¡£Ë÷Òý¿é·ÖÀëµÄÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ë÷Òý¿é·ÖÀëµÄÕùÓÃδÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ë÷Òý¿é·ÖÀëµÄÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£²»¹ý, ´ËÕùÓò»ÊÇÖ÷ÒªÓÉij¸öË÷Òýµ¼Öµġ£SQL_ID Ϊ "%s" µÄ SQL Óï¾äÔڵȴýÈȶÔÏóµÄÓû§ I/O ÉÏÏûºÄÁË´óÁ¿Ê±¼ä¡£·ÖÎöʱ¶ÎµÄ %s\\% µÄͳ¼ÆÐÅÏ¢ (´óԼΪ¹¤×÷Á¿µÄ %s\\%) ȱʧ¡£Õâ¿ÉÄܻήµÍ ADDM ·ÖÎöµÄ¿É¿¿ÐÔ¡£¾ÛÀà¶à¿éÇëÇóÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ù,ú|û®üàý¢þÓó¶Ô SQL_ID Ϊ "%s" µÄ SQL Óï¾äÔËÐÐ SQL ÓÅ»¯Ö¸µ¼¡£Çë²éÕÒδʹÓöÔÏóɨÃèµÄÌæ´ú¼Æ»®¡£ÓÉÓÚ¶ªÊ§µÄ¿éδÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä, ÒÑÖØÊÔ¾ÛÀàͨÐÅ¡£ÓÉÓÚ¶ªÊ§µÄ¿éÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä, ÒÑÖØÊÔ¾ÛÀàͨÐÅ¡£¼ì²é¼¯Èº»¥Á¬µÄÅäÖ᣼ì²é²Ù×÷ϵͳÉèÖà (ÈçÊÊÅäÆ÷ÉèÖÃ, ¹Ì¼þºÍÇý¶¯³ÌÐò°æ±¾)¡£¼ì²é²Ù×÷ϵͳµÄÌ×½Ó×Ö½ÓÊÕ»º³åÇøÊÇ·ñ×ãÒÔ´æ´¢Õû¸ö¶à¿é¶ÁÈ¡¡£×÷Ϊ½â¾ö·½·¨, ¿ÉÒÔ¼õС²ÎÊý "db_file_multiblock_read_count" µÄÖµ¡£Ê¹ÓÃÉ豸 "%s" (IP µØÖ·Îª "%s") ½«ÊµÀýÁ¬½Óµ½ÍøÂ硣ʵÀýÏûºÄµÄ»¥Á¬´ø¿íΪÿÃë %s kb¡£ÿ,\¨Ü3m伯Ⱥ»¥Á¬µÄÍøÂçµÈ´ýʱ¼äÔڿɽÓÊÜµÄ %s ºÁÃëÏÞÖÆÄÚ¡£ÆäËûʵÀýÖеÄÈ«¾Ö¸ßËÙ»º´æ·þÎñ½ø³Ì (LMSn) µÄÖ´ÐÐʱ¼äÔڿɽÓÊÜµÄ %s ºÁÃëÏÞÖÆÄÚ¡£ÔÚ¾ÛÀàÖÐ, ¶ÔÊý¾Ý¿â¿éµÄ¶ÁдÕùÓÃδÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ñо¿ SQL_ID Ϊ "%s" µÄ SQL Óï¾ä, È·¶¨ÊÇ·ñ¿ÉÒÔ¸ÄÉÆÐÔÄÜ¡£Çë²éÕÒδʹÓöÔÏóɨÃèµÄÌæ´ú¼Æ»®¡£ÔÚ·ÖÎöʱ¶ÎµÄ %s%% ÆÚ¼ä, Êý¾Ý¿âµÄά»¤´°¿ÚÊÇ´¦Óڻ״̬µÄ¡£µÈ´ýʼþ "%s" (ÔڵȴýÀà "%s" ÖÐ) ÏûºÄÁËÊý¾Ý¿âʱ¼äµÄ %s%% (¸ÃÊý¾Ý¿âʱ¼äΪ´¦Àí¾ßÓÐ SQL_ID "%s" µÄ SQL Óï¾äʱËùÓõÄʱ¼ä)¡£,c¼Þ , ’¾·þÎñ "%s" ºÍÄ£¿é "%s" ¹¹³É´Ë½¨Òé°¸ÖеÄÓÅ»¯½¨ÒéµÄ %s%%¡£¾ßÓÐ ID "%s", Óû§ ID "%s", ³ÌÐò "%s" ºÍÄ£¿é "%s" µÄ»á»°¹¹³É´Ë½¨Òé°¸ÖеÄÓÅ»¯½¨ÒéµÄ %s%%¡£¼ì²éÓ¦ÓóÌÐòÂß¼­ÖеÄãÅËøÕùÓÃÇé¿ö¡£¾ßÓзþÎñ "%s" ºÍÄ£¿é "%s" µÄ»á»°Êǹ¹³É´Ë½¨Òé°¸ÖеÄÓÅ»¯½¨ÒéµÄ %s%% µÄ×èÈû»á»°¡£¾ßÓÐ ID "%s", Óû§ ID "%s", ³ÌÐò "%s" ºÍÄ£¿é "%s" µÄ»á»°Êǹ¹³É´Ë½¨Òé°¸ÖеÄÓÅ»¯½¨ÒéµÄ %s%% µÄ×èÈû»á»°¡£Ê¹ÓÃÖ¸¶¨µÄ×èÈû»á»°»òÄ£¿éµ÷²éãÅËøÕùÓõÄÔ­Òò¡£ 8,¨-../[0~1Ÿ2Àß¿¼ÂÇͨ¹ýÉèÖà "db_writer_processes" ²ÎÊýÔö¼ÓÊý¾Ý¿âдÈë½ø³Ì (DBWR) µÄÊýÁ¿¡£Í¬Ê±¿¼ÂÇÒì²½ I/O ÊÇ·ñÊʺÏÄúµÄÌåϵ½á¹¹¡£Ñо¿ "%s" µÈ´ýÊý½Ï´óµÄÔ­Òò¡£Óйش˵ȴýʼþµÄ˵Ã÷, Çë²ÎÔÄ Oracle µÄ "Database Reference"¡£¶Ô SQL Óï¾äµÄÓ²Óï·¨·ÖÎöÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£¶Ô SQL Óï¾äµÄÈíÓï·¨·ÖÎöÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£·¢ÏÖ SQL Óï¾äÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£PL/SQL Ö´ÐÐÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£PL/SQL ±àÒëÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£JAVA Ö´ÐÐÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£3&4œ5Ì670êÕÒ³ö "%s" µÈ´ýÊý½Ï´óµÄÔ­Òò¡£Óйش˵ȴýʼþµÄ˵Ã÷, Çë²ÎÔÄ Oracle µÄ "Database Reference"¡£Ê¹ÓÃÖ¸¶¨ SQL ½øÐнøÒ»²½µ÷²é¡£»á»°Á¬½ÓºÍ¶Ï¿ªÁ¬½ÓµÄµ÷Óò¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£·¢ÏÖ SQL_ID Ϊ "%s" µÄ SQL Óï¾äÕýÔڵȴý "%s" µÈ´ýʼþ¡£¶Ô SQL Óï¾äµÄÓï·¨·ÖÎö²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚ¹²Ïí³ØµÄ´óС²»ºÏÊʶø²úÉúµÄÓï·¨·ÖÎö´íÎóÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£Çë×¢Òâ, Èç¹û½« "cursor_space_for_time" ²ÎÊýÉèÖÃΪ "Õæ", ¶øÇÒ¹²Ïí³Ø´óС²»×ãÒÔͬʱ´æ·ÅËùÓдò¿ªµÄÓαê, Ò²ÄܲúÉúÓï·¨·ÖÎö´íÎó¡£ 8>9m:œ;Ç<ê= >.?a@�Ä¶Ô SQL Óï¾äµÄÓ²Óï·¨·ÖÎö²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£¶Ô SQL Óï¾äµÄÈíÓï·¨·ÖÎö²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ã»Óз¢ÏÖÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼äµÄµ¥¸ö SQL Óï¾ä¡£PL/SQL Ö´Ðв¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£PL/SQL ±àÒ벢δÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£JAVA Ö´Ðв¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÊµÀýÔÚ CPU ÉÏ»¨·ÑµÄʱ¼äÕ¼¾ÝÁËÊý¾Ý¿âʱ¼äÖеĴ󲿷֡£µÈ´ýÖØ×öÈÕÖ¾»º³åÇø¿Õ¼äÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£²éÕÒ V$SQL_SHARED_CURSOR ÖÐÓα껷¾³²»Æ¥ÅäµÄ×îÖ÷ÒªÔ­Òò¡£A,BlCƒD§EÝF?“ÓÉÓÚ¹²Ïí³ØµÄ´óС²»ºÏÊʶø²úÉúµÄÓï·¨·ÖÎö´íÎóδÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ñо¿ DDL ²Ù×÷µÄºÏÀíÐÔ¡£Ñо¿Ó¦ÓóÌÐòÂß¼­ÒÔ±ÜÃâÓï·¨·ÖÎö´íÎó¡£Ñо¿Ó¦ÓóÌÐòÂß¼­, ̽ÌÖʹÓð󶨱äÁ¿À´´úÌæÎÄ×ֵĿÉÄÜÐÔ¡£Ñо¿Ó¦ÓóÌÐòÂß¼­, ʹ¾­³£Ê¹ÓõÄÓα걣³Ö´ò¿ª¡£Çë×¢Òâ, ¿ÉÒÔͨ¹ýÓÎ±ê¹Ø±Õµ÷Óûò»á»°¶Ï¿ªÁ¬½ÓÀ´¹Ø±ÕÓαꡣÎÞ·¨´ÓÖ÷»úµÄ²Ù×÷ϵͳÖлñÈ¡ CPU ÔËÐжÓÁÐͳ¼ÆÐÅÏ¢¡£Òò´Ë, ADDM ÎÞ·¨¹À¼Æ´Ë´Î²éÕÒµÄÓ°Ïì¡£G,H•IÖJ'KaLž÷ÒòΪÓα껷¾³²»Æ¥Åä, ²»Äܹ²Ïí¾ßÓÐÏàͬÎı¾µÄ SQL Óï¾ä¡£ÕâÑù»áµ¼Ö¸½¼ÓµÄÓ²Óï·¨·ÖÎö, Òò¶øÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£»·¾³²»Æ¥ÅäµÄ³£¼ûÔ­ÒòÊǻỰ NLS ÉèÖÃ, SQL ¸ú×ÙÉèÖúÍÓÅ»¯³ÌÐò²ÎÊý¡£ÓÉÓÚ DDL ²Ù×÷, Óα꽫ʧЧ¡£ÕâÑù»áµ¼Ö¸½¼ÓµÄÓ²Óï·¨·ÖÎö, Òò¶øÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚ¹²Ïí³Ø´óС²»×ã¶ø²úÉúµÄÓ²Óï·¨·ÖÎöÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£³öÏÖÓï·¨·ÖÎö´íÎóµÄ SQL Óï¾äµÄÓ²Óï·¨·ÖÎöÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚʹÓÃÁËÎÄ×Ö, ²»ÔÙ¹²Ïí SQL Óï¾ä¡£ÕâÑù»áµ¼Ö¸½¼ÓµÄÓ²Óï·¨·ÖÎö, Òò¶øÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£M2NnOšPÆQRGS‰åÓÉÓÚÓα껷¾³²»Æ¥Åä¶ø²úÉúµÄÓ²Óï·¨·ÖÎö²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ñо¿ "%s" µÈ´ýÊýÔÚ "%s" Ä£¿éÖзdz£¸ßµÄÔ­Òò¡£Ñо¿ "%s" µÈ´ýÊýÔÚ "%s" ·þÎñÖзdz£¸ßµÄÔ­Òò¡£ÓÉÓÚ¹²Ïí³ØÖеÄÓαêʧЧ¶øÒýÆðµÄÓ²ÐÔÓï·¨·ÖÎöδÏûºÄ´óÁ¿µÄÊý¾Ý¿âʱ¼ä¡£³öÏÖÓï·¨·ÖÎö´íÎóµÄ SQL Óï¾äµÄÓ²Óï·¨·ÖÎö²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚʹÓÃÁËÎÄ×ÖºÍÓαêʧЧ¶ø²úÉúµÄÓ²Óï·¨·ÖÎö²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ñо¿Ó¦ÓóÌÐòÂß¼­, ̽ÌÖ¼õÉÙÁ¬½Óµ÷ÓúͶϿªÁ¬½Óµ÷ÓõĿÉÄÜÐÔ¡£ÀýÈç, ¿ÉÒÔÔÚÖмä²ãʹÓÃÁ¬½Ó³Ø·½°¸¡£T2U`VŒWXCYiZ±äÓë¹²Ïí³ØÏà¹ØµÄãÅËøÕùÓò¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Óë¹²Ïí³ØÏà¹ØµÄãÅËøÕùÓý«ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÁÙʱ±í¿Õ¼ä "%s" (°üº¬ %s "%s.%s", ¶ÔÏó ID Ϊ %s) ²»ÊDZ¾µØ¹ÜÀíµÄ±í¿Õ¼ä¡£Oracle ½¨ÒéʹÓà CREATE TEMPORARY TABLESPACE Óï¾ä´´½¨ÁÙʱ±í¿Õ¼äÒÔ½â¾ö´ËÎÊÌâ¡£µÈ´ýÀà "ÆäËû" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýÀà "ÆäËû" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ãÅËø "%s" (ãÅËø ID Ϊ %s) ÊDzúÉú´óÁ¿ "ãÅËøÊÍ·Å" µÈ´ýµÄ×îÖ÷ÒªµÄãÅËøÖ®Ò»¡£"ÆäËû" µÈ´ýÀàÖеÄÊý¾Ý¿âãÅËø²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£[2\c]š^_&`Naµï"ÆäËû" µÈ´ýÀàÖеÄÊý¾Ý¿âãÅËøÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ñо¿ SQL_ID Ϊ "%s" µÄ SQL Óï¾ä, È·¶¨ÊÇ·ñ¿ÉÒÔ¸ÄÉÆÐÔÄÜ¡£¶ÔÓÚ³ý SYSTEM ±í¿Õ¼äÒÔÍâµÄËùÓбí¿Õ¼ä, ¿¼ÂÇÔÚ±¾µØ¹ÜÀíµÄ±í¿Õ¼äÖÐʹÓà ORACLE ½¨ÒéµÄ×Ô¶¯¶Î¿Õ¼ä¹ÜÀí½â¾ö·½°¸¡£µÈ´ý "%s" µÄÊý¾Ý¿âʱ¼ä×ܼÆÎª %s\\%¡£µÈ´ý±êʶ·û %s µÄËøÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£Ñо¿Ê¹Óà "DBMS_LOCK" ³ÌÐò°üµÄÓ¦ÓóÌÐòÂß¼­¡£¿¼ÂǼõÉÙÓ¦ÓóÌÐò³ÖÓÐÕâÐ©ËøµÄʱ¼ä, »òÕß¿¼ÂÇʹÓøüϸÁ£¶ÈµÄËø¡£µ÷²éÉæ¼°¶ÔÌṩµÄ×èÈû¶ÔÏóÖ´ÐÐµÄ DDL ºÍ DML µÄÓ¦ÓóÌÐòÂß¼­¡£b2c~dÉef9ghh¦Ù·¢ÏÖ´æÔÚ²¢·¢¶Áд²Ù×÷µÄÀàÐÍΪ "%s" µÄÈȿ顣±êʶ´Ë¿éµÄ¿éºÅΪ %s, ÎļþºÅΪ %s¡£·¢ÏÖÓÃÓÚ²¢·¢¶Áд²Ù×÷µÄÈÈÊý¾Ý¿é¡£´Ë¿éÊôÓÚ¶Î "%s.%s", ÊÇ¿é %s, ÔÚ %s ÎļþÖС£ÔÚ¶Î "%s.%s" ÖÐÔö¼Ó¿ÉÓÃÁбíÊý¿ÉÒÔ×÷ΪһÖÖÁÙʱ½â¾ö·½°¸¡£ÔÚ¶Î "%s.%s" ÖÐÔö¼Ó¿ÉÓÃÁбí×éÊý¿ÉÒÔ×÷ΪһÖÖÁÙʱ½â¾ö·½°¸¡£%s "%s.%s" (¶ÔÏó ID Ϊ %s) ÉÏ´æÔÚ´óÁ¿¶ÁдÕùÓ᣿¼ÂÇÔö´ó %s "%s.%s" (¶ÔÏó ID Ϊ %s) µÄ INITRANS Öµ, ¶ø²»Öؽ¨¡£¿¼ÂÇÔö´ó %s "%s.%s" (¶ÔÏó ID Ϊ %s) µÄ PCTFREE Öµ¡£i8jskŒlÒmþnFo�pÕý¿¼ÂÇʹÓøü´óµÄ INITRANS ÖµÖØ½¨ %s "%s.%s" (¶ÔÏó ID Ϊ %s)¡£Ñо¿ I/O ×ÓϵͳµÄдÐÔÄÜ¡£Ñо¿Ó¦ÓóÌÐòÂß¼­, ̽ÌÖʹÓÃÖ±½Ó·¾¶²åÈëÀ´Ìæ´ú¶à¸ö INSERT ²Ù×÷µÄ¿ÉÄÜÐÔ¡£ÔÚ±í¿Õ¼äÉÏʹÓÃÈȱ¸·Ýģʽ¿ÉÄܻᵼÖÂÕâÖÖÎÊÌâ¡£¿¼ÂÇͨ¹ýÔö¼Ó "open_cursors" ²ÎÊýµÄÖµÀ´Ôö¼Óÿ¸ö»á»°¿ÉÒÔ´ò¿ªµÄ×î´óÓαêÊý¡£¿¼ÂÇͨ¹ýÔö¼Ó "session_cached_cursors" ²ÎÊýµÄÖµÀ´Ôö¼Ó»á»°Óαê¸ßËÙ»º´æ´óС¡£Ñо¿ PL/SQL ±àÒëµÄºÏÀíÐÔ¡£¶Ô´ÓÊô¶ÔÏóÖ´ÐÐ DDL ¿ÉÄÜ»á²úÉú PL/SQL ±àÒë¡£Ñо¿Ä£¿é "%s" ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼äµÄÔ­Òò¡£q8r`s–t¶uävwix¸öÑо¿·þÎñ "%s" ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼äµÄÔ­Òò¡£¶à¸öʵÀý¶ÔÁÙʱ±í¿Õ¼äÖеĿռäÕùÓÃÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£¿¼ÂÇÔö¼ÓÁÙʱ±í¿Õ¼ä "%s" µÄ´óС¡£¿¼ÂÇÔö¼Ó³öÏÖ´óÁ¿ÊµÀý¼äÕùÓõÄÁÙʱ±í¿Õ¼äµÄ´óС¡£Ñо¿ "%s" µÈ´ýÊý (P1 ["%s"] µÄֵΪ "%s") ·Ç³£¸ßµÄÔ­Òò¡£Ñо¿ "%s" µÈ´ýÊý (P1 ["%s"] µÄֵΪ "%s", P2 ["%s"] µÄֵΪ "%s") ·Ç³£¸ßµÄÔ­Òò¡£Ñо¿ "%s" µÈ´ýÊý (P1,P2,P3 ("%s") µÄÖµ·Ö±ðΪ "%s", "%s" ºÍ "%s") ·Ç³£¸ßµÄÔ­Òò¡£¶ÔÒÑ°ó¶¨Æä°ó¶¨±äÁ¿µÄÓαêµÄ¶îÍâ°ó¶¨µ÷ÓÃÊýÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£yzê{éÑо¿Ó¦ÓóÌÐòÂß¼­ÒÔ¼õÉÙÒÑ·¢³öµÄ°ó¶¨µ÷ÓõÄÊýÄ¿¡£¿¼ÂÇʹÓõ¥¸ö°´ÒýÓð󶨻òÊý×é°ó¶¨À´Ìæ»»ÖØ¸´µÄ°´Öµ°ó¶¨µ÷Óá£Çë×¢Òâ, ¼´Ê¹µ±°´ÒýÓð󶨱äΪ°ó¶¨µ½°ó¶¨ÔªÊý¾Ý (Èç°ó¶¨µÄ×î´ó³¤¶È»òÊý¾ÝÀàÐÍ) ʱ, Ò²¿ÉÄܵ¼Ö¸½¼ÓµÄ°ó¶¨µ÷Óá£ÔÚÖ÷»ú²Ù×÷ϵͳÖмì²âµ½´óÁ¿ÐéÄâÄÚ´æÐ´Èë/д³ö¡£ÊµÀýÏûºÄµÄ×ÜÄڴ泬¹ýÁËÖ÷»úÉÏ¿ÉÓõÄÎïÀíÄÚ´æ¡£Ç뿼ÂÇÔÚÖ÷»úÖÐÌí¼Ó¸ü¶àÎïÀíÄÚ´æ, »òͨ¹ý±ä¸üÏàÓ¦µÄ INIT.ORA ²ÎÊý (Èç "sga_target", "shared_pool_size", "db_cache_size" ºÍ "pga_aggregate_target") À´¼õÉÙʵÀýÏûºÄµÄÄÚ´æ¡£|}µ~vÖ÷»ú²Ù×÷ϵͳ³öÏÖ´óÁ¿ÄÚ´æÐ´Èë/д³ö, µ«Î´¼ì²âµ½¸ù±¾Ô­Òò¡£ÇëÑо¿²»ÊôÓÚ (ÔÚÏûºÄÁË´óÁ¿ÐéÄâÄÚ´æµÄÖ÷»úÉÏÔËÐеÄ) ´ËʵÀýµÄ½ø³Ì¡£»¹¿ÉÒÔ¿¼ÂÇÔÚÖ÷»úÖÐÌí¼Ó¸ü¶àÎïÀíÄÚ´æ¡£¿¼ÂÇͨ¹ýÉèÖòÎÊý "sga_target" À´ÆôÓÃ×Ô¶¯¹²ÏíÄÚ´æ¹ÜÀí¹¦ÄÜ, ÒÔ±ã¿ØÖÆ´ËʵÀýÏûºÄµÄ SGA µÄÊýÁ¿¡£¿¼ÂÇͨ¹ýÉèÖòÎÊý "pga_aggregate_target" À´ÆôÓÃ×Ô¶¯ PGA ÄÚ´æ¹ÜÀí¹¦ÄÜ, ÒÔ±ã¿ØÖÆ´ËʵÀýÏûºÄµÄ PGA µÄÊýÁ¿¡£&€å�‚Uƒ§嵱ǰʹÓÃµÄ PGA ÄÚ´æ×ÜÁ¿ÓëÖ¸¶¨µÄ "pga_aggregate_target" ÖµÏà±È³¬¹ýÁË %s%%¡£Ç뿼ÂÇÔö¼Óµ±Ç°µÄ "pga_aggregate_target"¡£Çë×¢Òâ, "pga_aggregate_target" ºÍ SGA ´óСµÄ×ܺÍӦСÓÚÖ÷»úÉÏ¿ÉÓõÄÎïÀíÄÚ´æ¡£Ñо¿ "%s" ½ø³ÌÏûºÄ %s%% Ö÷»ú CPU µÄÔ­Òò¡£ÊµÀýÏûºÄÁË %s M SGA ÄÚ´æºÍ %s M PGA ÄÚ´æ, Ö÷»úÉÏ¿ÉÓõÄÎïÀíÄÚ´æÎª %s M¡£»¹¿É¿¼ÂÇʹÓà Oracle Database Resource Manager À´Çø·Ö¸÷ÖÖʹÓÃÕß×éÖй¤×÷Á¿µÄÓÅÏȼ¶¡£SQL_ID Ϊ "%s" µÄ SQL Óï¾äÖ´ÐÐÁË %s ´Î, ÿ´ÎÖ´Ðд¦ÀíÁË %s ÐС£„8…x† ‡Æˆö‰Š_‹”ÕSQL_ID Ϊ "%s" µÄ SQL Óï¾äÖ´ÐÐÁË %s ´Î, ÿ´ÎÖ´ÐÐÆ½¾ùÓÃʱ %s Ãë¡£ÔÚ PL/SQL Ö´ÐÐÉÏ»¨·ÑµÄƽ¾ùʱ¼äΪ %s Ãë¡£ÔÚ Java Ö´ÐÐÉÏ»¨·ÑµÄƽ¾ùʱ¼äΪ %s Ã롣ÿ´ÎÖ´ÐÐÔÚ¾ÛÀàµÈ´ýʼþÉÏ»¨·ÑµÄƽ¾ùʱ¼äΪ %s Ã롣ÿ´ÎÖ´ÐÐʹÓà CPU µÄƽ¾ùʱ¼äΪ %s Ãë¡£Ôڴ˶ÔÏóÉϳöÏÖµÄÐÐËøÕùÓÃÖÐ, ·þÎñ "%s" ºÍÄ£¿é "%s" µ¼ÖµÄÕùÓÃÕ¼ %s%¡£Ã¿´ÎÖ´ÐÐÔÚÓû§ I/O µÈ´ýʼþÉÏ»¨·ÑµÄƽ¾ùʱ¼äΪ %s Ãë¡£ÒÑÕÒµ½ÕýÔڵȴý Oracle Resource Manager µÄ»î¶¯»á»°²ÛµÄÊý¾Ý¿â»á»°¡£Œ,��Žç�‘’±ÝÒÑÕÒµ½ÕýÔڵȴý»î¶¯»á»°²ÛµÄ»á»°¡£Ç뿼ÂÇΪÕâЩ Oracle Resource Manager ʹÓÃÕß×éÌá¸ß»î¶¯»á»°ÏÞÖÆÖµ¡£»á»° CPU ÏûºÄÓÉ Oracle Resource Manager µ÷Õû¡£Ç뿼ÂÇÐÞ¸ÄÔÚ·ÖÎöÆÚ¼ä´¦Óڻ״̬µÄ×ÊÔ´¼Æ»®¡£ÁíÍâ, Ò²¿ÉÒÔ½«²ÎÊý "cursor_sharing" ÉèÖÃΪ "force"¡£¶Ô SQL Óï¾ä½øÐÐÓï·¨·ÖÎöÕ¼ÓÃÁË´óÁ¿ CPU ×ÊÔ´¡£ÓйØÏêϸ×ÊÁÏ, Çë²ÎÔÄ´ËÈÎÎñÖÐÓйØÓï·¨·ÖÎöµÄÆäËû²éÕÒ½á¹û¡£»¹Ô­ I/O ÊÇÊý¾Ý¿â I/O ×ÜÁ¿µÄÖØÒª×é³É²¿·Ö (%s\\%)¡£¿¼Âǽ« "undo_retention" ²ÎÊýµÄÖµ½µÎª %s Ãë¡£“,”‰•Ó–ô—4˜ˆÅ"undo_retention" µÄֵΪ %s Ãë, ¶ø×µÄÔËÐвéѯ½ö³ÖÐøÁË %s Ãë¡£¶îÍâµÄ±£Áô²úÉúÁ˲»±ØÒªµÄ I/O¡£¼õСÓÉÓ¦ÓóÌÐòÉú³ÉµÄÖØ×öµÄ´óС¿ÉÒÔ¼õÉÙ¶Ô "ÈÕÖ¾»º³åÇø¿Õ¼ä" ʼþµÄµÈ´ýʱ¼ä¡£·ÖÎöÆÚ¼ä, ²ÎÊý "%s" µÄֵΪ "%s"¡£Í¨¹ý½« "shared_pool_size" ²ÎÊýµÄÖµÉèÖÃΪ %s M À´Ôö¼Ó¹²Ïí³Ø´óС¡£¶ÔÏóµÄ I/O ʹÓÃͳ¼ÆÐÅϢΪ: %s ÍêÕû¶ÔÏóɨÃè, %s ÎïÀí¶ÁÈ¡, %s ÎïÀíдÈëºÍ %s Ö±½Ó¶ÁÈ¡¡£Í¨¹ý½« "sga_target" ²ÎÊýµÄÖµÔö¼Ó %s M À´Ôö¼Ó SGA Ä¿±êµÄ´óС¡£™2š³›ãœ�3žWŸ“ùÓÅ»¯ SQL_ID Ϊ "%s" µÄ PL/SQL ¿é¡£Çë²ÎÔÄ Oracle µÄ "PL/SQL User\\'s Guide and Reference" ÖÐµÄ "Tuning PL/SQL Applications" Ò»Õ¡£´óÁ¿ÎïÀí I/O ²»ÊÇÓɵ¥¸ö SQL »òÊý¾Ý¿âÓï¾äÔì³ÉµÄ¡£·¢ÏÖ¸ö±ðÊý¾Ý¿â¶ÎÔì³ÉÁË´óÁ¿µÄÓû§ I/O µÈ´ý¡£·¢ÏÖ¸ö±ð SQL Óï¾äÔì³ÉÁË´óÁ¿ÎïÀí I/O¡£·¢ÏÖ¸ö±ðÊý¾Ý¿â¶ÎÔì³ÉÁË´óÁ¿ÎïÀí I/O¡£Ñо¿Éæ¼° %s "%s.%s" (¶ÔÏó ID Ϊ %s) µÄ I/O µÄÓ¦ÓóÌÐòÂß¼­¡£ Ϊ¾ßÓзÇĬÈÏ´óС %s K µÄ¿éÔö¼Ó»º³åÇø¸ßËÙ»º´æµÄ´óС, ·½·¨Êǽ« "db_%sk_cache_size" ²ÎÊýµÄÖµÉèÖÃΪ %s M¡£ ,¡¼¢ï£/¤j¥»çÔö¼Ó·ÇĬÈÏ»º³åÇø¸ßËÙ»º´æµÄ´óСʱ, ÄÚ´æÀ´×ÔĬÈÏ»º³åÇø¸ßËÙ»º´æ¡£½¨ÒéµÄÉèÖà "sga_target" ²Ù×÷¿Éͨ¹ý´óÁ¿Ôö¼ÓĬÈÏ»º³åÇø¸ßËÙ»º´æµÄ´óСÀ´ÃÖ²¹ÕâÒ»ÎÊÌâ¡£ÓÉÓÚ×Ô¶¯»¹Ô­¹ÜÀí¹¦ÄÜÒѽûÓÃ, ÎÞ·¨Õï¶Ï»¹Ô­ I/O ÎÊÌâ¡£ÓÉÓÚ¹²Ïí³Ø´óС·¢ÉúÁ˱仯, ÎÞ·¨È·¶¨¹²Ïí³ØÖÐʧЧµÄÓαêÔì³ÉµÄÓ°Ïì¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨¹²Ïí³ØÖÐʧЧµÄÓαêÔì³ÉµÄÓ°Ïì¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨ÒòÓαêʧЧºÍʹÓÃÁËÎÄ×Ö¶ø²úÉúµÄÓ²Óï·¨·ÖÎöÔì³ÉµÄÓ°Ïì¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨Õï¶Ï I/O ÈÝÁ¿ÎÊÌâ¡£¦2§}¨¹©ªV«Œ¬ÃóÓÉÓÚ»º³åÇø¸ßËÙ»º´æµÄ´óС·¢ÉúÁ˱仯, ADDM ÎÞ·¨È·¶¨»º³åÇø¸ßËÙ»º´æÊÇ·ñ²»¹»´ó¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ADDM ÎÞ·¨È·¶¨»º³åÇø¸ßËÙ»º´æÊÇ·ñ²»¹»´ó¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨Òò MTTR ÉèÖöø²úÉúµÄ¼ì²éµã»î¶¯ËùÔì³ÉµÄÓ°Ïì¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨Òò²¢ÐвéѯºÍ±í¿Õ¼ä DDL ¶ø²úÉúµÄ¼ì²éµã»î¶¯ËùÔì³ÉµÄÓ°Ïì¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨»¹Ô­ I/O »î¶¯Ôì³ÉµÄÓ°Ïì¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨ RMAN I/O »î¶¯Ôì³ÉµÄÓ°Ïì¡£RMAN I/O »î¶¯¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿Ã»ÓкܴóÓ°Ïì¡£­8®f¯ °±²?³€´®äRMAN I/O »î¶¯¶Ô I/O ×ÓϵͳµÄÍÌÍÂÁ¿ÓкܴóÓ°Ïì¡£¿¼ÂÇÔÚÓû§»î¶¯½ÏÉÙʱ½µµÍ RMAN »î¶¯µÄËÙ¶È»òµ÷¶È RMAN ×÷Òµ¡£¿¼ÂÇ¶Ô RMAN ×÷Òµ²»Ê¹ÓÃѹËõÑ¡Ïî¡£ÁíÍâ, Ò²¿ÉÒÔ¿¼ÂÇÔÚÓû§»î¶¯½ÏÉÙʱ½µµÍ RMAN »î¶¯µÄËÙ¶È»òµ÷¶È RMAN ×÷Òµ¡£SGA ´óСºÏÊÊ¡£SGA ´óС²»ºÏÊÊ, µ¼Ö¸½¼Ó I/O »òÓ²Óï·¨·ÖÎö¡£ÓÉÓÚÔÚ·ÖÎöÆÚ¼ä¸ü¸ÄÁË "sga_target" µÄÖµ, ÎÞ·¨È·¶¨ SGA µÄ×î¼Ñ´óС¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨ SGA µÄ×î¼Ñ´óС¡£Í¨¹ý½«²ÎÊý "sga_target" ÉèÖÃΪ %s M, Ôö¼Ó SGA µÄ´óС¡£µ2¶£·ð¸¹ºI»…³SGA ´óС²»ºÏÊÊ, µ¼Ö¸½¼Ó I/O »òÓ²Óï·¨·ÖÎö¡£»òÕß, ·ÇĬÈÏ´óСµÄ¿éµÄijЩ»º³åÇø¸ßËÙ»º´æ²»¹»´ó, µ¼Ö´óÁ¿¸½¼Ó¶ÁÈ¡ I/O¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨Òòɾ³ýºÍ½Ø¶Ï²Ù×÷¶ø²úÉúµÄ¼ì²éµã»î¶¯ËùÔì³ÉµÄÓ°Ïì¡£Á÷³Ø´óС²»ºÏÊÊ, µ¼Ö¸½¼Ó I/O¡£Á÷³Ø´óСºÏÊÊ¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, ÎÞ·¨È·¶¨Á÷³ØµÄ×î¼Ñ´óС¡£Í¨¹ý½«²ÎÊý "streams_pool_size" ÉèÖÃΪ %s M, Ôö¼ÓÁ÷³ØµÄ´óС¡£ÓÉÓÚµ÷ÕûÁËÁ÷³ØµÄ´óС, ÎÞ·¨È·¶¨Á÷³ØµÄ×î¼Ñ´óС¡£¼&½š¾õ¿>À­ÝÑо¿¶Ô´ËʵÀý´ÓÔ¶³ÌʵÀý "%s" ½ÓÊÕµ½µÄ¿éµÄÕùÓÃÔ­Òò¡£´ËÎÊÌâͨ³£Ó볤ʱ¼äµÈ´ýÔ¶³ÌʵÀýÖÐµÄ "gcs log flush sync" ʼþÏà¹Ø¡£ÊÍ·ÅÊý¾Ý¿éʱ, "ÈÕÖ¾Îļþͬ²½" ʼþµÈ´ýµ¼Ö "È«¾Ö¸ßËÙ»º´æ»º³åÇøÃ¦ÓÚÊÍ·Å" ³öÏÖ´óÁ¿Êý¾Ý¿âµÈ´ý¡£µÈ´ý´ËʵÀýÖÐµÄ "log file sync" ʼþ¿ÉÄܵ¼Ö¶ÔÔ¶³ÌʵÀýµÄÈ«¾Ö¸ßËÙ»º´æÕùÓ᣷ÖÎöÆÚ¼ä, Êý¾ÝÎļþµÄƽ¾ù I/O ÍÌÍÂÁ¿, ¶ÔÓÚ¶ÁȡΪÿÃë %s, ¶ÔÓÚдÈëΪÿÃë %s¡£µ¥¸ö¿é¶ÁÈ¡µÄƽ¾ùÏìӦʱ¼äΪ %s ºÁÃë¡£¶ÔÓÚ´ËÎļþ, µ¥¸ö¿é¶ÁÈ¡µÄƽ¾ùÏìӦʱ¼äΪ %s ºÁÃë¡£Â&Ã{ÄíÇ/È\·¢ÏÖ´ø PLAN_HASH_VALUE %s µÄ SQL Óï¾äÕýÔÚʹÓÃÎÄ×Ö¡£Çë²ÎÕÕ V$SQL Öиà SQL Óï¾äµÄʾÀý¡£¸ú×ÙÓ¦ÓóÌÐòÂß¼­ÖÐÐÐÕùÓõÄÔ­Òò¡£Ê¹ÓÃÖ¸¶¨µÄ×èÈû SQL À´±êÊ¶Éæ¼°µÄÊý¾Ý¿â¶ÔÏó¡£µ÷²éÉæ¼°ÕâЩ¶ÔÏóµÄ DML µÄÓ¦ÓóÌÐòÂß¼­¡£¿¼ÂÇÔÚ±¾µØ¹ÜÀíµÄ±í¿Õ¼äÖÐʹÓà ORACLE ½¨ÒéµÄ×Ô¶¯¶Î¿Õ¼ä¹ÜÀí½â¾ö·½°¸¡£´óÁ¿ÊµÀý¼äÏûÏ¢´«ËͲ»ÊÇÓɵ¥¸ö SQL Óï¾äÔì³ÉµÄ¡£¶ÔÊý¾Ý¿â¿éµÄʵÀý¼ä¶ÁдÕùÓÃÔÚ´ËʵÀýÉÏÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£µ«ÊÇ, ´ËÕùÓò»ÊÇÖ÷ÒªÓÉijЩÈÈ¿é»ò¶ÔÏóÔì³ÉµÄ¡£É2Êxõµö÷/ø—ù¹߷DZê×¼´óС %s K µÄ¿éµÄ»º³åÇø¸ßËÙ»º´æ²»¹»´ó, ´Ó¶øµ¼Ö´óÁ¿µÄ¸½¼Ó¶Á I/O¡£½« "sga_target" ²ÎÊýµÄÖµÔö¼Ó %s M, ÒÔ±ãÔö´ó¹²Ïí³Ø¿ÉÓõÄÄÚ´æ¡£ÓÉÓÚÁ÷³ØÖеÄÄÚ´æ²»×ã²¢ÇÒÁ÷µÄÈë¶Ó²Ù×÷ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä, Òò´Ë¸Ã²Ù×÷±»×èÖ¹¡£ÓÉÓÚÁ÷³ØÖеÄÄÚ´æ²»×ã, Òò´ËÁ÷µÄÈë¶Ó²Ù×÷±»×èÖ¹¡£ÖÁÉÙ·¢ÏÖ %s Ìõ´øÓÐ PLAN_HASH_VALUE %s µÄ SQL Óï¾äÕýÔÚʹÓÃ×ÖÃæÖµ¡£Çë²ÎÔÄ SQL_ID Ϊ "%s" µÄ SQL Óï¾äʾÀý¡£¸ÃÓï¾äµÄÖ´ÐÐÖÁÉÙÓÐÒ»´ÎÊDz¢Ðз½Ê½¡£µÈ´ýÀà "ÅŶÓ" ²¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ú\X€Y–Zž[·\Å]Ó^Û_ö`a"b?c†d¡ĵȴýÀà "ÅŶÓ" ÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÈÎÎñ '%s' µÄ ADDM ±¨¸æ·ÖÎöʱ¶ÎAWR ¿ìÕÕ·¶Î§´Ó %s µ½ %s¡£Ê±¶Î´Ó %s ¿ªÊ¼Ê±¶ÎÔÚ %s ½áÊø·ÖÎöÄ¿±êÊý¾Ý¿â '%s' (DB ID Ϊ %s)¡£Êý¾Ý¿â°æ±¾ %s¡£ÔÚ·ÖÎöÆÚ¼äÄÚÊý¾Ý¿â°æ±¾ÊÇ %s¡£Ö´ÐÐ ADDM ʱÊý¾Ý¿â°æ±¾ÊÇ %s¡£ADDM Éú³ÉµÄËùÓн¨Òé°¸¶ÔÊý¾Ý¿â°æ±¾ %s ¾ùÓÐЧ, ¸Ã°æ±¾ÎªÖ´ÐÐ ADDM µÄ°æ±¾¡£ADDM ¶ÔËùÓÐʵÀýÖ´ÐÐÁË·ÖÎö¡£ADDM ¶Ô±àºÅΪ %s µÄʵÀýÖ´ÐÐÁË·ÖÎö¡£ eDf~g°høi@jrk„lšm³nÝ÷ADDM ¶ÔʵÀý %s Ö´ÐÐÁË·ÖÎö, ¸ÃʵÀýµÄ±àºÅΪ %s ²¢ÔËÐÐÓÚ %s¡£ÇëÇó¶ÔËùÓÐʵÀý½øÐзÖÎö, µ« ADDM Ö»·ÖÎöÁ˲¿·ÖʵÀý¡£ÇëÇó¶ÔËùÓÐʵÀý½øÐзÖÎö, µ« ADDM Ö»·ÖÎöÁËʵÀý %s, Æä±àºÅΪ %s ²¢Î»ÓÚ %s¡£ÇëÇó¶Ô²¿·ÖʵÀý½øÐзÖÎö, µ« ADDM Ö»·ÖÎöÁËʵÀý %s, Æä±àºÅΪ %s ²¢Î»ÓÚ %s¡£ÓйØËùÇëÇóʵÀýµÄÏêϸÐÅÏ¢, Çë²ÎÔÄ "¸½¼ÓÐÅÏ¢" ²¿·Ö¡£·ÖÎöʱ¶ÎÆÚ¼äµÄ»î¶¯×ÜÊý¾Ý¿âʱ¼äΪ %s Ãë¡£»î¶¯»á»°µÄƽ¾ùÊýÁ¿Îª %s¡£ADDM ·ÖÎöÁË %s ¸öʵÀý (ÇëÇóÁË %s ¸öʵÀý)¡£Ã»ÓÐÈκβéÕÒ½á¹û¿ÉÒÔ±¨¸æ¡£oŒpšq½rÅsÒtéuívñw÷xy z{5|E}U~lp€x��‚¼ƒ×„ãîÊý¾Ý¿â ID %s¡£ADDM ¶Ô±àºÅΪ %s µÄʵÀýÖ´ÐÐÁË·ÖÎö¡£¸½¼ÓÐÅÏ¢ÒÑ·ÖÎöµÄʵÀý:ÇëÇóÁ˵«Î´±»·ÖÎöµÄʵÀý:±àºÅÃû³ÆÖ÷»úÃû»î¶¯µÄ»á»°»î¶¯µÄ°Ù·Ö±ÈÅųýʵÀýµÄÔ­ÒòÔÚ·ÖÎöʱ¶ÎÆÚ¼äµÄÆô¶¯»ò¹Ø±Õ¿ìÕÕȱʧ»òÓдíÎóȱʧÃÜԿͳ¼ÆÐÅÏ¢ÕÒ²»µ½¸ÃʵÀýµÄ AWR ¿ìÕÕ¾¯¸æ¸÷ÖÖÐÅÏ¢¾ßÓзÇĬÈÏÉèÖõÄÈÎÎñ²ÎÊýÊÜÓ°ÏìµÄÊÇ %s ¸ö»î¶¯»á»°, Õ¼×ܻµÄ %s\\%¡£Êܴ˲éÕÒ½á¹ûÑÏÖØÓ°ÏìµÄʵÀý:Ó°ÏìµÄ°Ù·Ö±ÈADDM ÈÎÎñÃû…€†¦‡²ˆ¼‰ÄŠÌ‹ÒŒÚ�êŽü��‘'’U“Y”]•e–”—®˜Åþ¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÌṩ½¨Òé°¸Ó¦ÓóÌÐò·ÖÎöÊý¾Ý¿âÅäÖÃÖ÷»úÅäÖÃSQL ÓÅ»¯¶ÎÓÅ»¯·½°¸¸ü¸Äδ֪µÄ½¨Òé°¸ÀàÐÍûÓпÉÓõĽ¨Òé°¸¡£¿ÉÓõĽ¨Òé°¸¾ßÓÐÒÔÏÂÀàÐÍ:½¨Òé°¸ÀàÐͽ¨Òé°¸Êý¹À¼ÆµÄÊÕÒæÎª %s ¸ö»î¶¯»á»°, Õ¼×ܻµÄ %s\\%¡£²Ù×÷Ô­ÀíÏà¹Ø¶ÔÏóSQL_ID Ϊ %s ²¢ÇÒ PLAN_HASH Ϊ %s µÄ SQL Óï¾ä¡£SQL_ID Ϊ %s µÄ SQL Óï¾ä¡£ID Ϊ %s µÄÊý¾Ý¿â¶ÔÏó¡£¶ÔÏó±àºÅΪ %s, Îļþ±àºÅΪ %s ÒÔ¼°¿é±àºÅΪ %s µÄÊý¾Ý¿â¿é¡£™Œš–›¬œ»�ÊžåŸ  !¡.¢;£H¤U¥_¦k§w¨{©�«‘¬¨­Ô®é„öÊý¾Ý¿âÎļþ±í¿Õ¼ä %s (ID Ϊ %s)¡£Êý¾Ý¿âãÅËø %s¡£Êý¾Ý¿âÈë¶Ó %s¡£Êý¾Ý¿âÈë¶Ó %s (ID1 Ϊ %s)¡£Êý¾Ý¿âÈë¶Ó %s (ID1 Ϊ %s, ID2 Ϊ %s)¡£ÀàÐÍΪ %s µÄÏà¹Ø¶ÔÏó¡£ATTR1 Ϊ %s¡£ATTR2 Ϊ %s¡£ATTR3 Ϊ %s¡£ATTR4 Ϊ %s¡£½¨Òé°¸ %s:²éÕÒ½á¹û %s:²éÕÒ½á¹û¸ÅҪ˵Ã÷½¨Òé°¸²éÕÒ½á¹ûºÍ½¨Òé°¸µ¼Ö²éÕÒ½á¹ûµÄ¹ÊÕÏÏÖÏó:ÊÜÓ°ÏìµÄÊÇ %s ¸ö»î¶¯»á»°, Õ¼×ܻµÄ %s\\%¡£¿ÉÄÜÓ°Ïì´Ë±¨¸æµÄÖ¸Áî:¼ì²éʵÀý ADDM·ÏÆúµÄ²ÎÊý …P†e‡–ˆ·‰ÊŠã‹óŒ �/Žx�™�ºÛADDM Ó¦Ö´ÐеķÖÎöÀàÐÍÓÃÓÚ´ÓÊý¾ÝÎļþ¶Áȡһ¸öÊý¾Ý¿éµÄÔ¤ÆÚÏìӦʱ¼ä (ºÁÃë)ÔÚ·ÖÎöÆÚ¼äÀÛ»ýµÄÊý¾Ý¿âʱ¼ä (ºÁÃë)ÓÃÓÚ·ÖÎöµÄÊý¾Ý¿â ID·ÖÎöÆÚ¼äµÄ×îºóÒ»¸ö¿ìÕÕ IDÓÃÓÚ·ÖÎöµÄʵÀýºÅ·ÖÎöÆÚ¼äµÄµÚÒ»¸ö¿ìÕÕ IDÓÃÓÚ´Ó SQL ÓÅ»¯¼¯¹ýÂË SQL µÄ SQL ν´Êµ±Í¬Ò»Óï¾ä´æÔÚ¶à¸öÏà¹ØÁªµÄ¼Æ»® (plan_hash_value) µÄÇé¿öÏÂÊÊÓõļƻ®¹ýÂËÆ÷ËùÑ¡ SQL ÉϵĵÚÒ»¸ö ORDER BY ×Ó¾äËùÑ¡ SQL Éϵĵڶþ¸ö ORDER BY ×Ó¾äËùÑ¡ SQL ÉϵĵÚÈý¸ö ORDER BY ×Ó¾ä ‘D’n“„”�•Ç–ñ—˜M™„š¹×ÏÞÖÆ¹ýÂ˵ĺÍÅÅÃûµÄ SQL ÓÅ»¯¼¯ÖÐµÄ SQL ÊýĿռÅÅÃû¶ÈÁ¿×ÜÊýµÄ°Ù·Ö±È½«ÓÅ»¯Æä SQL Óï¾äµÄÓû§Ãû·ÖÎöʱ¶ÎµÄ¿ªÊ¼Ê±¼äºÍµ±Ç°Ê±¼äÖ®¼äÏà²îµÄÃëÊý·ÖÎöʱ¶ÎµÄ½áÊøÊ±¼äºÍµ±Ç°Ê±¼äÖ®¼äÏà²îµÄÃëÊý×Ô¶¯µ÷ÓõÄÖ¸µ¼Éú³ÉµÄΨһÈÎÎñ IDÈç¹ûÈÎÎñÊÇ×Ô¶¯´´½¨µÄÔòΪ TRUE, Èç¹ûÈÎÎñÊÇÊÖ¶¯´´½¨µÄÔòΪ FALSEÈç¹û½á¹ûÖÐÓ¦°üº¬²éÕÒ½á¹û¼°½¨Òé°¸ÔòΪ TRUE, ·ñÔòΪ FALSEÓï¾äÊýÄ¿, ³¬¹ý¸ÃÊýĿ֮ºó, ½«Ìá½» SQL ÓÅ»¯¼¯µÄÓÅ»¯½á¹ûSQL ÓÅ»¯¼¯ÄÚÿÌõÓï¾äµÄʱ¼äÏÞÖÆ ›Pœ‡�Ÿž²Ÿè &¡W¢Š£�¤´¥Ò¦åÿ»Ö¸´ÓÅ»¯ÈÎÎñʱ, ÓÃÓÚ´Ó SQL ÓÅ»¯¼¯ÄÚ¹ýÂË SQL µÄ SQL ν´ÊÖ¸¶¨ÈÎÎñÖ´ÐеÄĬÈϲÙ×÷¡£ÓÅ»¯ SQL Óï¾äµÄÐÔÄÜÈç¹û SQL ¸ÅÒªÎļþÓ¦ÓÉÈÎÎñ´´½¨, ÔòΪ TRUE, ·ñÔòΪ FALSEÈç¹ûÓ¦¸ÃÌæ»»ÓÉÓû§´´½¨µÄ SQL ¸ÅÒªÎļþ, ÔòΪ TRUE, ·ñÔòΪ FALSEÔÚÒ»´ÎÔËÐÐÖпÉÓÉϵͳ´´½¨µÄ SQL ¸ÅÒªÎļþµÄ×î´óÊýÄ¿¿ÉÒÔÔÚÈÎÒâʱ¼äͬʱÔÊÐíµÄϵͳ SQL ¸ÅÒªÎļþµÄ×î´óÊýÄ¿²âÊÔ SQL Óï¾äµÄÖ´ÐÐÉú³É SQL Óï¾äµÄ½âÊͼƻ®Ö¸¶¨µ±Ç°ÈÎÎñµ¥¶ÀÖ´ÐеÄʧЧÌìÊý·ÖÎö SQL Óï¾äµÄÐÔÄÜSQL Óï¾ä¶Ô¹¤×÷Á¿Ó°ÏìµÄãÐÖµ§8¨S©ª›«·¬í­®®ý¶Ô SQL Óï¾äµÄ¸ü¸ÄÓ°ÏìµÄãÐÖµÖ¸¶¨ÔÚÐÔÄܱȽÏÖÐʹÓõÄÖ´ÐÐͳ¼ÆÐÅÏ¢µÄ±í´ïʽ¡£Òª·ÖÎöµÄµÚÒ»¸öÈÎÎñÖ´ÐеÄÃû³ÆÒª·ÖÎöµÄµÚ¶þ¸öÈÎÎñÖ´ÐеÄÃû³ÆÈç¹û SQL Óï¾äÓ¦Ö´ÐвâÊÔÀ´ºâÁ¿ÊÕÒæ, ÔòΪ YES; ·ñÔòΪ NOÒÑָʾָµ¼ÊÇ·ñ¿ÉÒÔʹÓà SQL Óï¾ä²¶»ñµÄ±àÒë»·¾³Èç¹û SQL Óï¾äÓ¦¶ÔÍêÕûµÄ±¾µØÊ±¼äÏÞÖÆÖ´ÐвâÊÔÒÔºâÁ¿ÊÕÒæ, ÔòΪ FULL; Èç¹ûijЩÇé¿öÏÂ×Ô¶¯Ñ¡Ôñ½ÏСµÄʱ¼ä, ÔòΪ AUTO; Èç¹ûÔÚÈκÎÇé¿ö϶¼²»Ö´ÐвâÊÔ, ÔòΪ NOTRUE ±íʾ²âÊÔÖ´ÐÐÐèÒªËùÓÐÖØÒª°ó¶¨, FALSE ±íʾ°²×°¼ÙµÄ NULL °ó¶¨À´Ìæ´úȱÉٵİó¶¨è&éŒê ëhí˜õ´ËÊôÐÔ½«´ËÓï¾äµÄ²ÎÊý OPTIMIZER_FEATURES_ENABLE ÉèÖÃΪĬÈÏÖµ, ¶ø²»ÊÇ %s¡£´Ë²Ù×÷ÆôÓÃ×îеÄÓÅ»¯³ÌÐò¹¦ÄÜ¡£´ËÊôÐÔ½«²ÎÊý OPTIMIZER_FEATURES_ENABLE ÉèÖÃΪĬÈÏÖµ, ÒòΪÖÁÉÙÒ»¸öÓÅ»¯³ÌÐòÏà¹Ø²ÎÊýÒÑÉèÖÃΪ·ÇĬÈÏÖµ¡£´Ë²Ù×÷ÆôÓÃ×îеÄÓÅ»¯³ÌÐò¹¦ÄÜ¡£´ËÊôÐÔ½«´ËÓï¾äµÄ²ÎÊý OPTIMIZER_FEATURES_ENABLE ÉèÖÃΪĬÈÏÖµ, ÕâÑù¿ÉÆôÓÃ×îеÄÓÅ»¯³ÌÐò¹¦ÄÜ¡£´ËÊôÐÔµ¼ÖÂÓÅ»¯³ÌÐòΪ´ËÓï¾ä³¢ÊÔ¸ÐÐËȤµÄÌæ´ú¼Æ»®¡£´ËÊôÐÔ½«ÓÅ»¯³ÌÐòģʽ´Ó %s ¸ü¸ÄΪ %s¡£ÔÚ¼ì²éÁË´ËÓï¾äµÄÖ´ÐÐͳ¼ÆÐÅÏ¢ÒÔºó, ÓÅ»¯³ÌÐòģʽÒѱ»¸ü¸Ä¡£ îPï~ðœñ¶òØüðýþ%ÿ=d“¼ò´ËÊôÐÔ±£Áô²éѯµÄÓû§Ö¸¶¨ÌáʾÖеÄÓÅ»¯³ÌÐòģʽ¡£´ËÊôÐÔÆôÓûùÓڳɱ¾µÄÓÅ»¯³ÌÐò¡£´ËÊôÐÔµ÷ÕûÓÅ»¯³ÌÐò¹À¼ÆÖµ¡£´ËÊôÐÔÆôÓà "µÚÒ»ÐÐ" ÓÅ»¯³ÌÐòģʽ¡£´ËÊôÐÔ½ûÓÃÓÅ»¯³ÌÐòÌáʾ¡£ÉÐδ·ÖÎö±í "%s"."%s"¡£ÉÐδ·ÖÎö±í "%s"."%s" ¼°ÆäË÷Òý¡£ÉÐδ·ÖÎöË÷Òý "%s"."%s"¡£±í "%s"."%s" µÄÓÅ»¯³ÌÐòͳ¼ÆÐÅÏ¢ÒÑʧЧ¡£±í "%s"."%s" ¼°ÆäË÷ÒýµÄÓÅ»¯³ÌÐòͳ¼ÆÐÅÏ¢ÒÑʧЧ¡£Ë÷Òý "%s"."%s" µÄÓÅ»¯³ÌÐòͳ¼ÆÐÅÏ¢ÒÑʧЧ¡£ÎªÁËÑ¡ÔñºÃµÄÖ´Ðмƻ®, ÓÅ»¯³ÌÐòÐèÒª´Ë±íµÄ×îÐÂͳ¼ÆÐÅÏ¢¡£2p¦ì2r ¸üΪÁËÑ¡ÔñºÃµÄÖ´Ðмƻ®, ÓÅ»¯³ÌÐòÐèÒª´Ë±í¼°ÆäË÷ÒýµÄ×îÐÂͳ¼ÆÐÅÏ¢¡£ÎªÁËÑ¡ÔñºÃµÄÖ´Ðмƻ®, ÓÅ»¯³ÌÐòÐèÒªË÷ÒýµÄ×îÐÂͳ¼ÆÐÅÏ¢¡£´ËÊôÐÔÏòÓÅ»¯³ÌÐòÌṩÁË»ù±¾µÄ±íͳ¼ÆÐÅÏ¢, ÒòΪ´Ë±íµÄ±íͳ¼ÆÐÅÏ¢ÒѾ­¶ªÊ§¡£´ËÊôÐÔÏòÓÅ»¯³ÌÐòÌṩÁË»ù±¾µÄ±íͳ¼ÆÐÅÏ¢, ÒòΪ´Ë±íµÄ±íͳ¼ÆÐÅÏ¢ÒѾ­¹ýʱ¡£´ËÊôÐÔÌṩÁË´ø»ù±¾ÁÐͳ¼ÆÐÅÏ¢µÄÓÅ»¯³ÌÐò, ÒòΪ´Ë±íȱʧ±íͳ¼ÆÐÅÏ¢¡£´ËÊôÐÔÏòÓÅ»¯³ÌÐòÌṩÁË»ù±¾µÄÁÐͳ¼ÆÐÅÏ¢, ÒòΪ´Ë±íµÄ±íͳ¼ÆÐÅÏ¢ÒѾ­¹ýʱ¡£´ËÊôÐÔÌṩÁË´ø»ù±¾Ë÷Òýͳ¼ÆÐÅÏ¢µÄÓÅ»¯³ÌÐò, ÒòΪ´Ë±íȱʧË÷Òýͳ¼ÆÐÅÏ¢¡£ 8 € � ½ßeš¼ä´ËÊôÐÔÌṩÁË´ø»ù±¾Ë÷Òýͳ¼ÆÐÅÏ¢µÄÓÅ»¯³ÌÐò, ÒòΪ´Ë±íµÄË÷Òýͳ¼ÆÐÅÏ¢ÒÑʧЧ¡£¿¼ÂǽÓÊÜÍÆ¼öµÄ SQL ¸ÅÒªÎļþ¡£¿¼ÂÇÊÕ¼¯´Ë±íµÄÓÅ»¯³ÌÐòͳ¼ÆÐÅÏ¢¡£¿¼ÂÇÊÕ¼¯´ËË÷ÒýµÄÓÅ»¯³ÌÐòͳ¼ÆÐÅÏ¢¡£´ËÓï¾äµÄ´æ´¢´ó¸Ù "%s" ´æÔÚ, ÔÚÓÅ»¯¹ý³ÌÖн«ºöÂԸôó¸Ù¡£Ç뿼ÂÇʹÓà dbms_spm.migrate_stored_outline API ½«´æ´¢µÄ´ó¸ÙÒÆÖ²µ½ SQL ¼Æ»®»ùÏß¡£´ËÓï¾äµÄ SQL ¸ÅÒªÎļþ "%s" ÒÑ´æÔÚ, µ«ÔÚÓÅ»¯Ê±±»ºöÂÔ¡£Îª´ËÓï¾äÕÒµ½ÁËÐÔÄܸüºÃµÄÖ´Ðмƻ®¡£¿¼ÂÇÊÕ¼¯´Ë±í¼°ÆäË÷ÒýµÄÓÅ»¯³ÌÐòͳ¼ÆÐÅÏ¢¡£8OŒ¥¾Tž³ë²»Ö§³ÖµÄ SQL Óï¾äÀàÐÍ¡£´ËÓï¾äµÄ¹Ì¶¨ SQL ¼Æ»®»ùÏß "%s" ÒÑ´æÔÚ, µ«ÔÚÓÅ»¯¹ý³ÌÖб»ºöÂÔ¡£ÏµÍ³ÖдæÔÚ×Ô¶¯´´½¨µÄ %s¡£ÏµÍ³ÖдæÔÚÊÖ¶¯´´½¨µÄ %s¡£ÒÑ¶Ô %s ½øÐвâÊÔ, ·½·¨ÎªÖ´ÐÐÆä¼Æ»®ºÍԭʼ¼Æ»®²¢²âÁ¿Óë¼Æ»®Ïà¶ÔÓ¦µÄÖ´ÐÐͳ¼ÆÐÅÏ¢¡£Èç¹ûÆäÖÐÒ»¸ö¼Æ»®ÔËÐÐÔں̵ܶÄʱ¼äÄÚ¾ÍÍê³É, ÔòÁíÒ»¼Æ»®¿ÉÄÜÖ»Ö´ÐÐÁËÒ»²¿·Ö¡£ÒÑÌø¹ý´ËÓï¾ä, ÒòΪ×î½üÒѶÔËüÓÅ»¯¹ý¡£Çë²ÎÔÄÈÎÎñÖ´ÐÐ "%s" ÖеÄ×îÐÂÓÅ»¯½á¹û¡£ÏµÍ³ÖÐÒѲ»ÔÙ´æÔÚ %s¡£´ËÓï¾äÒѱ»Ìø¹ý, ÒòΪËüÒѱ»Óû§ºÚÃûµ¥¹ýÂËÆ÷ "%s" ɸѡµô¡£,W€è%šÓ%s δ×Ô¶¯´´½¨, ÒòΪ¾­ÑéÖ¤¿É»ñµÃµÄÊÕÒæÌ«ÉÙ¡£%s δ×Ô¶¯´´½¨, ÒòΪÎÞ·¨ÑéÖ¤Æä´øÀ´µÄÊÕÒæ¡£%s δ×Ô¶¯´´½¨, ÒòΪ×Ô¶¯´´½¨¹¦ÄÜÒѽûÓá£Ç뽫ÈÎÎñ²ÎÊý ACCEPT_SQL_PROFILES ÉèÖÃΪ TRUE ÒÔÆôÓÃ×Ô¶¯´´½¨¹¦ÄÜ¡£%s δ×Ô¶¯´´½¨, ÒòΪ¸Ã SQL ¾ßÓй̶¨µÄ SQL ¼Æ»®»ùÏß»ò´æ´¢´ó¸Ù¡£SQL ¸ÅÒªÎļþδ×Ô¶¯´´½¨, ÒòΪÓÅ»¯³ÌÐòͳ¼ÆÐÅÏ¢Òѳ¾ɻòȱʧ¡£ÔÚ´´½¨ SQL ¸ÅÒªÎļþǰ, Ó¦ÏȽâ¾ö»ù±¾ÓÅ»¯³ÌÐòͳ¼ÆÐÅÏ¢µÄÎÊÌâ¡£SQL ¸ÅÒªÎļþδ×Ô¶¯´´½¨, ÒòΪÒѴﵽȫ¾Ö SQL ¸ÅÒªÎļþÏÞÖÆ¡£ ,!Â"'#6$j%žÒSQL ¸ÅÒªÎļþδ×Ô¶¯´´½¨, ÒòÎªÌæ»»Óû§ SQL ¸ÅÒªÎļþµÄ¹¦ÄÜÒѽûÓá£Ç뽫ÈÎÎñ²ÎÊý REPLACE_USER_SQL_PROFILES ÉèÖÃΪ TRUE, ÒÔÆôÓÃÌæ»»Óû§ SQL ¸ÅÒªÎļþµÄ¹¦ÄÜ¡£%s δ×Ô¶¯´´½¨, ÒòΪ²âÊÔÖ´Ðй¦ÄÜÒѽûÓá£Ç뽫ÈÎÎñ²ÎÊý TEST_EXECUTE ÉèÖÃΪ FULL »ò AUTO ÒÔÆôÓòâÊÔÖ´ÐС£%s δ×Ô¶¯´´½¨¡£ÓÉÓÚ³öÏÖ´íÎó, Òò´ËÎÞ·¨Í¨¹ý²âÊÔÖ´ÐÐÀ´ÑéÖ¤ %s µÄÊÕÒæ¡£ÓÉÓÚ²Ù×÷³¬Ê±, Òò´ËÎÞ·¨Í¨¹ý²âÊÔÖ´ÐÐÀ´ÑéÖ¤ %s µÄÊÕÒæ¡£ÓÉÓÚ²¢Ðвéѯ²»Ö§³Ö²âÊÔÖ´ÐÐ, Òò´ËÎÞ·¨ÑéÖ¤ %s µÄÊÕÒæ¡£&8'p(¦)È*ä+,X-±ÎÓÉÓÚ DML »ò DDL ²»Ö§³Ö²âÊÔÖ´ÐÐ, Òò´ËÎÞ·¨ÑéÖ¤ %s µÄÊÕÒæ¡£ÓÉÓÚ´ËÓï¾äÀàÐͲ»Ö§³Ö²âÊÔÖ´ÐÐ, Òò´ËÎÞ·¨ÑéÖ¤ %s µÄÊÕÒæ¡£ÎÞ·¨Í¨¹ý²âÊÔÖ´ÐÐÀ´ÑéÖ¤ %s µÄÊÕÒæ¡£ÒÑ×Ô¶¯Îª´ËÓï¾ä´´½¨ %s "%s"¡£ÒÑ×Ô¶¯Îª´ËÓï¾ä´´½¨ SQL ¸ÅÒªÎļþ "%s" ºÍ SQL ¼Æ»®»ùÏß "%s"¡£ÓÉÓÚÒÑ´ïµ½½¨Òé°¸ÏÞÖÆ, Òò´Ë¸ÃÈÎÎñδ·ÖÎöÍêÕûµÄºòÑ¡ SQL ¼¯¡£¿¼ÂǽÓÊÜÍÆ¼öµÄ SQL ¸ÅÒªÎļþ¡£Í¬Ê±»á´´½¨Óë¾ßÓиà SQL ¸ÅÒªÎļþµÄ¼Æ»®Ïà¶ÔÓ¦µÄ SQL ¼Æ»®»ùÏß¡£¿¼ÂǽÓÊÜÍÆ¼öµÄ SQL ¼Æ»®»ùÏß¡£.&/{0ä12ZÃÈÎÎñÖ´ÐÐÒÑÖÕÖ¹, ״̬Ϊ "FATAL ERROR", µ« SQL ¸ÅÒªÎļþ "%s" ÔÚ·¢Éú´íÎó֮ǰÒѳɹ¦ÊµÊ©¡£¿¼ÂǽÓÊÜÍÆ¼öµÄ SQL ¸ÅÒªÎļþ¡£Í¬Ê±»á½«Óë¾ßÓиà SQL ¸ÅÒªÎļþµÄ¼Æ»®Ïà¶ÔÓ¦µÄ SQL ¼Æ»®»ùÏ߸üÐÂΪ¿É½ÓÊܵļƻ®¡£¿¼ÂǽÓÊÜÍÆ¼öµÄ SQL ²¹¶¡³ÌÐò¡£¿¼ÂǽÓÊÜÍÆ¼öµÄ SQL ²¹¶¡³ÌÐò¡£Í¬Ê±»á´´½¨Óë¾ßÓиà SQL ²¹¶¡³ÌÐòµÄ¼Æ»®Ïà¶ÔÓ¦µÄ SQL ¼Æ»®»ùÏß¡£¿¼ÂǽÓÊÜÍÆ¼öµÄ SQL ²¹¶¡³ÌÐò¡£Í¬Ê±»á½«Óë¾ßÓиà SQL ²¹¶¡³ÌÐòµÄ¼Æ»®Ïà¶ÔÓ¦µÄ SQL ¼Æ»®»ùÏ߸üÐÂΪ¿É½ÓÊܵļƻ®¡£324…5¾6ä7 8*9>d´Ë SQL Óï¾äÖÁÉÙȱÉÙÒ»¸öÖØÒª°ó¶¨Öµ¡£Ö¸µ¼·ÖÎöµÄ׼ȷÐÔ¿ÉÄÜÈ¡¾öÓÚÌṩµÄËùÓÐÖØÒª°ó¶¨Öµ¡£ÓÉÓÚ %s ¿ÉÄÜÔì³ÉÁËÏÔÖøµÄ I/O ʱ¼äËõ¶Ì, Òò´Ëδ×Ô¶¯´´½¨Ëü¡£¸ÃÓï¾äÒÑÊ×ÏÈÖ´ÐÐÒÔÔ¤ÈÈ»º³åÇø¸ßËÙ»º´æ¡£ÏÔʾµÄͳ¼ÆÐÅÏ¢ÊǺóÃæµÄ %s Ö´ÐÐµÄÆ½¾ùÖµ¡£ÏÔʾµÄͳ¼ÆÐÅÏ¢À´×ÔµÚ¶þ´ÎÖ´ÐС£´ËÊôÐÔÆôÓò¢ÐÐÖ´ÐС£Îª´ËÓï¾äÕÒµ½ÁËÐÔÄܸüºÃµÄ²¢ÐÐÖ´Ðмƻ®¡£:;0<g¯Óë DOP %s ²¢ÐÐÖ´Ðд˲éѯ»áʹ SQL ¸ÅÒªÎļþ¼Æ»®ÉϵÄÏìӦʱ¼äËõ¶Ì %s%%¡£µ«ÊÇ, ÆôÓò¢ÐÐÖ´ÐÐʱҪ¸¶³öһЩ´ú¼Û¡£Ëü½«Ôö¼ÓÓï¾äµÄ×ÊÔ´ÏûºÄ (Ô¤¼ÆÎª %s%%), Õâ»áµ¼ÖÂϵͳÍÌÍÂÁ¿½µµÍ¡£´ËÍâ, ÓÉÓÚÔڷdz£¶ÌµÄ³ÖÐøÊ±¼äÄÚÏûºÄÁËÕâЩ×ÊÔ´, Òò´ËÈç¹ûûÓÐ×ã¹»¿ÉÓõÄÓ²¼þÈÝÁ¿, ²¢·¢Óï¾äµÄÏìӦʱ¼ä½«Êܵ½¸ºÃæÓ°Ïì¡£¿¼ÂǽÓÊܽ¨ÒéµÄ SQL ¸ÅÒªÎļþ, ÒÔ±ã¶Ô´ËÓï¾äʹÓò¢ÐÐÖ´ÐС£Îª´ËÓï¾äÕÒµ½ÁËÐÔÄܸüºÃµÄÖ´Ðмƻ® %s¡£Ñ¡ÔñÒÔÏ SQL ¸ÅÒªÎļþÖ®Ò»½øÐÐʵʩ¡£= >-?m@µäÓë DOP %s ²¢ÐÐÖ´Ðд˲éѯ»áʹԭʼ¼Æ»®ÉϵÄÏìӦʱ¼äËõ¶Ì %s%%¡£µ«ÊÇ, ÆôÓò¢ÐÐÖ´ÐÐʱҪ¸¶³öһЩ´ú¼Û¡£Ëü½«Ôö¼ÓÓï¾äµÄ×ÊÔ´ÏûºÄ (Ô¤¼ÆÎª %s%%), Õâ»áµ¼ÖÂϵͳÍÌÍÂÁ¿½µµÍ¡£´ËÍâ, ÓÉÓÚÔڷdz£¶ÌµÄ³ÖÐøÊ±¼äÄÚÏûºÄÁËÕâЩ×ÊÔ´, Òò´ËÈç¹ûûÓÐ×ã¹»¿ÉÓõÄÓ²¼þÈÝÁ¿, ²¢·¢Óï¾äµÄÏìӦʱ¼ä½«Êܵ½¸ºÃæÓ°Ï졣ͨ¹ýËÑË÷ϵͳµÄʵʱºÍÀúÊ·ÐÔÄÜÊý¾ÝÕÒµ½ÁË´ËÓï¾äµÄÄ³Ð©Ìæ´úÖ´Ðмƻ®¡£Ê¹ÓÃ×î¼ÑÓÃʱΪ¼Æ»®´´½¨¼Æ»®»ùÏß½«½ûÖ¹ Oracle ÓÅ»¯³ÌÐòÑ¡ÔñÐÔÄܽϲîµÄ¼Æ»®¡£Ç뿼ÂÇʹÓÃ×î¼Ñƽ¾ùÓÃʱΪ¼Æ»®´´½¨ SQL ¼Æ»®»ùÏß¡£A BÕCÄDÐà¸ù¾Ýÿ´ÎÖ´ÐеÄÓÃʱ, ԭʼ¼Æ»®¿ÉÄܾßÓÐ×î¼ÑÐÔÄÜ¡£µ«ÊÇ, Èç¹ûÄúÖªµÀij¸öÌæ´ú¼Æ»®ÓÅÓÚԭʼ¼Æ»®, ¿ÉÒÔΪ¸ÃÌæ´ú¼Æ»®´´½¨ SQL ¼Æ»®»ùÏß¡£Õ⽫ָʾ Oracle ÓÅ»¯³ÌÐòÔÚ½«À´ÓÅÏÈÓÚÈÎºÎÆäËûÑ¡ÔñÀ´Ñ¡È¡Ëü¡£ÒòΪÕÒ²»µ½Ô­Ê¼¼Æ»®µÄÈκÎÖ´ÐÐÀúÊ·¼Ç¼, SQL ÓÅ»¯Ö¸µ¼ÎÞ·¨È·¶¨ÕâЩִÐмƻ®ÖÐÊÇ·ñÓÐһЩִÐмƻ®ÓÅÓÚԭʼ¼Æ»®¡£µ«ÊÇ, Èç¹ûÄúÖªµÀij¸öÌæ´ú¼Æ»®ÓÅÓÚԭʼ¼Æ»®, ¿ÉÒÔΪ¸ÃÌæ´ú¼Æ»®´´½¨ SQL ¼Æ»®»ùÏß¡£Õ⽫ָʾ Oracle ÓÅ»¯³ÌÐòÔÚ½«À´ÓÅÏÈÓÚÈÎºÎÆäËûÑ¡ÔñÀ´Ñ¡È¡Ëü¡£¸Ã¶ÔÏóȱʧ¡£¿ÉÒÔɾ³ý¸Ã¶ÔÏó¡£E&FTGÉH>I²æ¸ù¾Ýÿ´ÎÖ´ÐеÄÓÃʱ, ԭʼ¼Æ»®¿ÉÄܾßÓÐ×î¼ÑÐÔÄÜ¡£ÎÞ·¨ÖØÐÂÉú³É¾ßÓÐ ID %s µÄ¼Æ»®, ÒòΪȱÉÙ %s¡£ÓÉÓÚ´ËÔ­Òò, ÎÞ·¨´´½¨ SQL ¼Æ»®»ùÏßÒÔָʾ Oracle ÓÅ»¯³ÌÐòÔÚ½«À´Ñ¡È¡¸Ã¼Æ»®¡£ÎÞ·¨ÖØÐÂÉú³É¾ßÓÐ ID %s µÄ¼Æ»®, ÒòΪȱÉÙ %s¡£ÓÉÓÚ´ËÔ­Òò, ÎÞ·¨´´½¨ SQL ¼Æ»®»ùÏßÒÔָʾ Oracle ÓÅ»¯³ÌÐòÔÚ½«À´Ñ¡È¡¸Ã¼Æ»®¡£ÔÚµ±Ç°»·¾³ÖÐÎÞ·¨ÖØÐÂÉú³É¾ßÓÐ ID %s µÄ¼Æ»®¡£ÓÉÓÚ´ËÔ­Òò, ÎÞ·¨´´½¨ SQL ¼Æ»®»ùÏßÒÔָʾ Oracle ÓÅ»¯³ÌÐòÔÚ½«À´Ñ¡È¡¸Ã¼Æ»®¡£ÔÚµ±Ç°»·¾³ÖÐÎÞ·¨ÖØÐÂÉú³Éԭʼ¼Æ»®Ö®ÍâµÄËùÓÐÌæ´ú¼Æ»®¡£J,KMLnMŽNÏOGÚÎÞ·¨ÖØÐÂÉú³É´Ë¼Æ»®, ÒòΪȱÉÙ %s¡£ÎÞ·¨ÖØÐÂÉú³É´Ë¼Æ»®, ÒòΪȱÉÙ %s¡£ÔÚµ±Ç°»·¾³ÖÐÎÞ·¨ÖØÐÂÉú³É´Ë¼Æ»®¡£Èç¹ûÔÊÐíÖØ¸´»ò¿ÉÒÔ±£Ö¤Î¨Ò»ÐÔ, Ôò¿¼ÂÇÓà "UNION ALL" ´úÌæ "UNION"¡£"UNION" ²Ù×÷µÄ¿ªÏúºÜ´ó²¢ÇÒ±»×èÈû, ÒòΪËüÒªÇóÏû³ýÖØ¸´µÄÐС£"UNION ALL" µÄ¿ªÏúÔòÏà¶Ô½ÏС, ǰÌáÊÇÔÊÐíÖØ¸´»òÄܹ»±£Ö¤Î¨Ò»ÐÔ¡£¿¼ÂÇÓà "NOT EXISTS" ´úÌæ "NOT IN", »òÕßÈ·±£ÒÑͨ¹ýÌí¼Ó "NOT NULL" Ô¼ÊøÌõ¼þ»ò "IS NOT NULL" ν´Ê½« "NOT IN" ÔËËã·ûµÄÁ½±ßËùʹÓõÄÁÐÉùÃ÷Ϊ "NOT NULL"¡£P&S÷T7UwV�ü"FILTER" ²Ù×÷µÄ¿ªÏú·Ç³£´ó, ÒòΪËüΪ¸¸²éѯÖеÄÿһÐмÆËã×Ó²éѯ¡£×Ó²éѯÔÚ·ÇǶÌ×µÄÇé¿öÏ¿ÉÒÔ´ó´óËõ¶ÌÖ´ÐÐʱ¼ä, ÒòΪ "FILTER" ²Ù×÷ÒÑת»»ÎªÁª½Ó¡£Òª×¢ÒâµÄÊÇ "NOT IN" ºÍ "NOT EXISTS" ¿ÉÄÜ»á¶Ô "NULL" Öµ²úÉú²»Í¬µÄ½á¹û¡£¿¼ÂÇ´Ó´ËÓï¾äÖÐÒÆÈ¥¶Ï¿ªÁ¬½ÓµÄ±í»òÊÓͼ, »òÕßÌí¼ÓÒýÓÃËüµÄÁª½ÓÌõ¼þ¡£Ó¦¾¡¿ÉÄܱÜÃâµÑ¿¨¶û»ý²Ù×÷, ÒòΪËüµÄ¿ªÏúºÜ´ó, ²¢ÇÒ»á²úÉú´óÁ¿Êý¾Ý¡£¿¼ÂÇÒÆÈ¥ "ORDERED" Ìáʾ¡£"ORDERED" Ìáʾ¿ÉÒÔÇ¿ÖÆÓÅ»¯³ÌÐòÉú³ÉµÑ¿¨¶û»ý¡£Ó¦¾¡¿ÉÄܱÜÃâµÑ¿¨¶û»ý²Ù×÷, ÒòΪËüµÄ¿ªÏúºÜ´ó, ²¢ÇÒ»á²úÉú´óÁ¿Êý¾Ý¡£Y8Z§[Ñ\÷]^J_t`®ÒÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬ "ORDER BY" ×Ó¾äµÄÊÓͼ, ³ý·Ç´ËÓï¾äΪ "DELETE" »ò "UPDATE", ²¢ÇÒ¸¸²éѯΪ´ËÓï¾äÖеĶ¥¼¶²éѯ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬ "ROWNUM" αÁеÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬ÉèÖÃÔËËã·ûµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬´°¿Úº¯ÊýµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬ "SPREADSHEET" ×Ó¾äµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬Ç¶Ì׵ľۼ¯º¯ÊýµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬²»´ø "GROUP BY" ×Ó¾äµÄ¾Û¼¯º¯ÊýµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬·Ö×麯ÊýµÄÊÓͼ¡£a2b‹c¹dãgh7iuªÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬´ø "ROLLUP", "CUBE" »ò "GROUPING SETS" Ñ¡ÏîµÄ "GROUP BY" ×Ó¾äµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬ "START WITH" ×Ó¾äµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬ NO_MERGE ÌáʾµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬ "CURSOR" ±í´ïʽµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬ "WITH" ×Ó¾äµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢´ø°üº¬ÍⲿÁª½ÓÖÐËùÉæ¼°µÄǶÌ×±íÁеÄν´ÊµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢Î»ÓÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦µÄ¸´ÔÓÊÓͼ¡£j&k®löm>nËÊÓͼºÏ²¢¿ÉÒÔÉú³É¸üºÃµÄÖ´Ðмƻ®, ´Ó¶øËõ¶ÌÖ´ÐÐʱ¼ä¡£½« OPTIMIZER_FEATURES_ENABLE ²ÎÊýÉèÖÃΪСÓÚ 9.0.1 µÄÖµ, ¿ÉÒÔ·ÀÖ¹ÓÅ»¯³ÌÐòºÏ²¢¸´ÔÓÊÓͼ¡£Èç¹û¸´ÔÓÊÓͼµÄ¸¸²éѯ°üº¬ "START WITH" ×Ó¾ä, ÓÅ»¯³ÌÐò²»Äܺϲ¢´Ë¸´ÔÓÊÓͼ¡£Èç¹û¸´ÔÓÊÓͼµÄ¸¸²éѯΪ "SELECT FOR UPDATE", ÓÅ»¯³ÌÐò²»Äܺϲ¢´Ë¸´ÔÓÊÓͼ¡£½öµ±ÍⲿÁª½ÓÓÒ²àµÄÊÓͼ°üº¬´øµ¥¸ö "WHERE" ×Ó¾äµÄµ¥¸ö±íʱ²ÅÄܺϲ¢¡£Èç¹û¸´ÔÓÊÓͼµÄ¸¸²éѯ°üº¬¶Ô "ROWNUM" αÁеÄÒýÓÃ, ÓÅ»¯³ÌÐò²»Äܺϲ¢´Ë¸´ÔÓÊÓͼ¡£o,pwqÂrs<thÍÈç¹û¸´ÔÓÊÓͼµÄ¸¸²éѯ°üº¬ "GROUP BY CUBE" ×Ó¾ä, ÓÅ»¯³ÌÐò²»Äܺϲ¢´Ë¸´ÔÓÊÓͼ¡£Èç¹û¸´ÔÓÊÓͼµÄ¸¸²éѯ°üº¬ "GROUPING SETS" ×Ó¾ä, ÓÅ»¯³ÌÐò²»Äܺϲ¢´Ë¸´ÔÓÊÓͼ¡£Èç¹û¸´ÔÓÊÓͼµÄ¸¸²éѯµÄ "SELECT" Áбí°üº¬ "SEQUENCE" ÁÐ, ÓÅ»¯³ÌÐò²»Äܺϲ¢´Ë¸´ÔÓÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üº¬×éÍⲿÁª½ÓµÄÊÓͼ¡£ÓÅ»¯³ÌÐò²»Äܺϲ¢°üÀ¨×éÍⲿÁª½ÓÖÐÉæ¼°µÄÊÓͼ¡£¿¼ÂÇͨ¹ýʹÓà "MERGE" Ìáʾ»òͨ¹ý½« OPTIMIZER_FEATURES_ENABLE ²ÎÊýÖÁÉÙÉèÖÃΪ 9.0.1 À´ÆôÓø´ÔÓÊÓͼºÏ²¢¡£u2vewšxËyÿz/{iØÔÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦·¢ÏÖ¿ªÏúºÜ´óµÄµÑ¿¨¶û»ý²Ù×÷¡£ÓÅ»¯³ÌÐò²»ÄÜÈ¡ÏûÖ´Ðмƻ®µÄÐÐ ID %s ´¦µÄ×Ó²éѯµÄǶÌס£ÓÅ»¯³ÌÐò²»Äܺϲ¢Î»ÓÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦µÄÊÓͼ¡£ÔÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦·¢ÏÖ¿ªÏúºÜ´óµÄ "UNION" ²Ù×÷¡£Í¨¹ý´´½¨Ò»¸ö»ò¶à¸öË÷Òý¿ÉÒԸĽø´ËÓï¾äµÄÖ´Ðмƻ®¡£¿¼ÂÇÔËÐпÉÒԸĽøÎïÀí·½°¸Éè¼ÆµÄ·ÃÎÊÖ¸µ¼»òÕß´´½¨ÍƼöµÄË÷Òý¡£Î½´Ê %s (ÔÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦Ê¹ÓÃ) °üº¬Ë÷ÒýÁÐ "%s" µÄ±í´ïʽ¡£´Ë±í´ïʽʹÓÅ»¯³ÌÐòÎÞ·¨Ñ¡Ôñ±í "%s"."%s" µÄË÷Òý¡£| }•~¡ÿν´Ê %s (ÔÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦Ê¹ÓÃ) °üº¬Ë÷ÒýÁÐ "%s" µÄ±í´ïʽ¡£´Ë±í´ïʽʹÓÅ»¯³ÌÐòÎÞ·¨ÓÐЧµØÊ¹Óñí "%s"."%s" µÄË÷Òý¡£Î½´Ê %s (ÔÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦Ê¹ÓÃ) °üº¬Ë÷ÒýÁÐ "%s" µÄÒþʽÊý¾ÝÀàÐÍת»»¡£´ËÒþʽÊý¾ÝÀàÐÍת»»Ê¹ÓÅ»¯³ÌÐòÎÞ·¨Ñ¡Ôñ±í "%s"."%s" µÄË÷Òý¡£Î½´Ê %s (ÔÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦Ê¹ÓÃ) °üº¬Ë÷ÒýÁÐ "%s" µÄÒþʽÊý¾ÝÀàÐÍת»»¡£´ËÒþʽÊý¾ÝÀàÐÍת»»Ê¹ÓÅ»¯³ÌÐòÎÞ·¨ÓÐЧµØÊ¹Óñí "%s"."%s" µÄË÷Òý¡£Èç¹ûν´ÊÊDz»µÈʽÌõ¼þ»òÕßÈç¹û´æÔÚ¹ØÓÚË÷ÒýÁеıí´ïʽ»òÒþʽÊý¾ÝÀàÐÍת»», ÔòÓÅ»¯³ÌÐòÎÞ·¨Ê¹ÓÃË÷Òý¡£€ �d‚„ƒùt½«Î½´ÊÖØÐ´ÎªµÈ¼ÛÐÍÒÔ±ãʹÓÃË÷Òý¡£»òÕß, ¶Ô´Ë±í´ïʽ´´½¨»ùÓÚº¯ÊýµÄË÷Òý¡£½«Î½´ÊÖØÐ´ÎªµÈ¼ÛÐÍÒÔ±ãÀûÓÃË÷Òý¡£Î½´Ê %s (ÔÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦Ê¹ÓÃ) ÊÇË÷ÒýÁÐ "%s" µÄ²»µÈʽÌõ¼þ¡£´Ë²»µÈʽÌõ¼þʹÓÅ»¯³ÌÐòÎÞ·¨Ñ¡Ôñ±í "%s"."%s" µÄË÷Òý¡£Î½´Ê %s (ÔÚÖ´Ðмƻ®µÄÐÐ ID %s ´¦Ê¹ÓÃ) ÊÇË÷ÒýÁÐ "%s" µÄ²»µÈʽÌõ¼þ¡£´Ë²»µÈʽÌõ¼þʹÓÅ»¯³ÌÐòÎÞ·¨ÓÐЧµØÊ¹Óñí "%s"."%s" µÄË÷Òý¡£„…׆=Š´´½¨ÍƼöµÄË÷Òý¿ÉÒÔÏÔÖøµØ¸Ä½ø´ËÓï¾äµÄÖ´Ðмƻ®¡£µ«ÊÇ, ʹÓõäÐ굀 SQL ¹¤×÷Á¿ÔËÐÐ "·ÃÎÊÖ¸µ¼" ¿ÉÄܱȵ¥¸öÓï¾ä¸ü¿ÉÈ¡¡£Í¨¹ýÕâÖÖ·½·¨¿ÉÒÔ»ñµÃÈ«ÃæµÄË÷Òý½¨Òé°¸, °üÀ¨¼ÆËãË÷Òýά»¤µÄ¿ªÏúºÍ¸½¼ÓµÄ¿Õ¼äÏûºÄ¡£Í¬Ê±Îª´ËÓï¾äÍÆ¼öÁËË÷ÒýºÍ SQL ¸ÅÒªÎļþ¡£ÓÅ»¯³ÌÐòÐèÒªÏÈ´´½¨ SQL ¸ÅÒªÎļþ, È»ºó²ÅÄܽ«¼Æ»®ÓÃÓÚÍÆ¼öµÄË÷Òý¡£¾ßÓÐÍÆ¼öË÷ÒýµÄ¼Æ»®±ØÐë×÷Ϊ SQL ¼Æ»®»ùÏßÀ´¼ÓÔØ, ÕâÑùÓÅ»¯³ÌÐò²ÅÄÜʹÓÃÄÇЩË÷Òý¡£‡&ˆ¨‰“”Ûô¿¼ÂÇÔËÐзÃÎÊÖ¸µ¼ÒԸĽøÎïÀí·½°¸Éè¼Æ»òÕß´´½¨ÍƼöµÄË÷Òý¡£Èç¹ûÑ¡Ôñ´´½¨ÍƼöµÄË÷Òý, Ç뿼ÂÇɾ³ýË÷Òý "%s"."%s", ÒòΪËüÊÇÍÆ¼öµÄË÷ÒýµÄǰ׺¡£ÒÑ´æÔÚ¿ÉÄÜÓÐÒæµÄË÷Òý, µ«¸ÃË÷Òýµ±Ç°Òѱê¼ÇΪ²»¿ÉÓá£Ç뿼ÂÇÖØ½¨¸ÃË÷Òý, ÒÔ±ãÓÅ»¯³ÌÐò¿ÉÒÔʹÓÃËü¡£¿¼ÂÇÔËÐзÃÎÊÖ¸µ¼ÒԸĽøÎïÀí·½°¸Éè¼Æ»òÕß´´½¨ÍƼöµÄË÷Òý¡£Çë×¢Òâ, ϵͳÖÐÒÑ´æÔÚÍÆ¼öµÄË÷ÒýµÄ¶à¸öǰ׺Ë÷Òý¡£Èç¹ûÑ¡Ôñ´´½¨ÍƼöµÄË÷Òý, Ç뿼ÂÇɾ³ýÄÇЩ²»Ç¿ÖÆÖ´ÐÐÈκÎÔ¼ÊøÌõ¼þµÄǰ׺Ë÷Òý, ÒòΪËüÃÇÊǶàÓàµÄ¡£´Ë SQL µÄÐÔÄܵõ½Á˸ÄÉÆ¡£´Ë SQL µÄÐÔÄÜ·¢ÉúÁ˵¹ÍË¡£ •J–s—Š˜¦™èš(›<¦f§h¹Çï·ÖÎö´Ë SQL Óï¾äʱËùÐèµÄij¸öÖ´Ðмƻ®È±Ê§¡£´Ë SQL Óï¾äûÓзµ»ØÐС£SQL Ö´Ðмƻ®µÄ½á¹¹ÒѾ­¸ü¸Ä¡£Ö´ÐÐ '%s' ÖÐµÄ SQL ¼Æ»®µÄ½á¹¹²»Í¬ÓÚ´æ´¢ÔÚ SQL ÓÅ»¯¼¯ÖеĶÔÓ¦¼Æ»®¡£Ö´ÐÐ '%s' ÖÐ SQL ¼Æ»®µÄ½á¹¹Óë´æ´¢ÔÚ SQL ÓÅ»¯¼¯ÖеĶÔÓ¦¼Æ»®ÏàËÆ¡£Ö´ÐÐ '%s' ʱ³ö´í: %sÖ´ÐÐ '%s' Öзµ»ØµÄÐÐÊýÓëÖ´ÐÐ '%s' Öв»Í¬¡£%s´¦Àí´Ë SQL Óï¾äʱ³öÏÖ´íÎó, Ôì³ÉÈÎÎñÖ´ÐÐʧ°Ü¡£ÈÎÎñʧ°ÜÖ®ºó, ³É¹¦»Ö¸´Á˸ÃÈÎÎñÖ´ÐС£Ê¹ÓõŦÄÜ: %s²ßÂÔ %s µÄ¼Æ»®ÏûºÄÁË %s, ¼Æ»®É¢ÁÐֵΪ %s D`ŽÚ&Py’Õ åû½ÓÊÜÁ˹¦ÄÜ %s, Ô­ÒòÊÇÓÉÓÚ %s²ßÂÔÖ´ÐÐ %s ʧ°Ü, ´íÎó´úÂëΪ %s, ´íÎóÏûϢΪ %sÉ¢ÁÐֵΪ %s µÄÌæ´ú¼Æ»®¾ßÓÐÐÐÊý %s, УÑéºÍ %s, Ö´ÐÐʱ¼ä %s ºÍ»º³åÇø»ñÈ¡Êý %s É¢ÁÐֵΪ %s µÄÍÆ¼ö¼Æ»®¾ßÓÐÐÐÊý %s, УÑéºÍ %s, Ö´ÐÐʱ¼ä %s ºÍ»º³åÇø»ñÈ¡Êý %s %s CR Diff: ¹¦ÄÜ %s [»ù´¡Îª %s, Ä¿±êΪ %s]%s CR Diff: ¶ÔÏó»ù´¡½á¹¹ %s ΪĿ±êÖÐµÄ %sÑéÖ¤ [¹æÔò: %s, ״̬: %s]²ßÂÔ %s µÄ¼Æ»® (´øÓмƻ®Ö¸Áî (Ìáʾ) %s) ÏûºÄÁË %s (¼Æ»®É¢ÁÐֵΪ %s)ÎÊÌâÀàÐ͵ÄÖµÎÞЧÒâÍâʼþ±êʶ·ûµÄÖµÎÞЧ!2"~ÐŽÑëÒ/Ó?ÔWªÉ¢ÁÐֵΪ %s µÄԭʼ¼Æ»®¾ßÓÐÐÐÊý %s, УÑéºÍ %s, Ö´ÐÐʱ¼ä %s ºÍ»º³åÇø»ñÈ¡Êý %s %s P1: %s P2: %s¼ì²âµ½¿ìÕÕÌ«¾É´íÎó: SQL ID %s, ¿ìÕÕ SCN %s, ×îРSCN %s, »¹Ô­±í¿Õ¼ä %s, µ±Ç°µÄ»¹Ô­±£ÁôÆÚ %s¡£¼ì²âµ½¿ìÕÕÌ«¾É´íÎó: SQL ID %s, ¿ìÕÕ SCN %s, ×îРSCN %s, »ØÍ˶Π%s¡£ÇëÔËÐл¹Ô­Ö¸µ¼¡£Çë¼ì²é»ØÍ˶εÄʹÓÃÇé¿ö¡£¶Ô¿É»Ö¸´»á»° %s (»á»° ID Ϊ %s) µÄ²Ù×÷±»¹ÒÆð, Ô­ÒòÊDZí¿Õ¼ä %s Öгö´í¡£´íÎóÏûϢΪ %s Õ>Ö‘×ÞØ-ÙGÚlۊܰÝÔæ¶Ô¿É»Ö¸´»á»° %s (»á»° ID Ϊ %s) µÄ²Ù×÷±»¹ÒÆð, Ô­ÒòÊÇ»ØÍ˶Π%s Öгö´í¡£´íÎóÏûϢΪ %s¶Ô¿É»Ö¸´»á»° %s (»á»° ID Ϊ %s) µÄ²Ù×÷±»¹ÒÆð, Ô­ÒòÊÇ %s Öгö´í¡£´íÎóÏûϢΪ %s¶Ô¿É»Ö¸´»á»° %s (»á»° ID Ϊ %s) µÄ²Ù×÷±»¹ÒÆð, Ô­ÒòÊÇÓû§ÏÞ¶î³ö´í¡£´íÎóÏûϢΪ %sÇë¼ì²éÊÓͼ dba_resumable¡£½«³õʼ»¯²ÎÊý undo_retention ÉèÖÃΪ %d½«»¹Ô­±í¿Õ¼äµÄ´óСÉèÖÃΪ %d MB×µÄ²éѯ³ÖÐøÊ±¼ä´óÓÚ»¹Ô­±£ÁôÆÚÉèÖá£ÓÉÓÚ¿ìÕÕÌ«¾É´íÎó, ÓÐЩ²éѯ¿ÉÄÜʧ°Ü¡£»¹Ô­±í¿Õ¼äÒÑ¿ìÂú¡£ ÞJßpà¨áÖâã$ä8åLæ^çnè¶ìÓÉÓÚ»¹Ô­±í¿Õ¼äÒÑÂú, ÓÐЩ²Ù×÷¿ÉÄÜʧ°Ü¡£½«»¹Ô­±£ÁôÆÚÉèÖÃΪ×²éѯ³ÖÐøÊ±¼ä, ÒÔ±ÜÃâ¿ìÕÕÌ«¾É´íÎ󡣸ù¾Ý»¹Ô­Éú³ÉËÙÂʺͻ¹Ô­±£ÁôÆÚÉèÖû¹Ô­±í¿Õ¼ä´óСµ±ÏµÍ³ÔÚÊÖ¶¯»¹Ô­¹ÜÀíģʽÏÂÔËÐÐʱ²»ÄÜÔËÐл¹Ô­Ö¸µ¼¡£ÏµÍ³ÕýÔÚ×Ô¶¯ÓÅ»¯»¹Ô­±£ÁôÆÚ¡£AWR ÖÐûÓÐ×ã¹»Êý¾Ý¡£Ã»ÓÐ target_object¡£¼õÉÙ¿ìÕÕÌ«¾É´íÎó¡£±ÜÃ⻹ԭ±í¿Õ¼äÂúÍÆ¼öµÄ»¹Ô­±í¿Õ¼ä´óСÊÇ»ùÓÚϵͳÖеĻ¹Ô­Éú³ÉËÙÂʺÍ×²éѯ³ÖÐøÊ±¼ä¸ø³öµÄ¡£ÍƼöµÄ»¹Ô­±£ÁôÆÚÊÇ»ùÓÚϵͳÖеÄ×²éѯ³ÖÐøÊ±¼ä¸ø³öµÄ¡£ éPê¨ë¸ìÈíàîîï.ðpñ†ò£ó¹ôÏóÍÆ¼öµÄ»¹Ô­±£ÁôÆÚÊÇ¿ÉÄܵÄ×î¼Ñ»¹Ô­±£ÁôÆÚ, ÊÇ»ùÓÚ»¹Ô­Éú³ÉËÙÂʺ͵±Ç°µÄ»¹Ô­±í¿Õ¼ä´óС¸ø³öµÄ¡£»¹Ô­±í¿Õ¼äÕý³£¡£»¹Ô­±í¿Õ¼äÕý³£¡£¸ÄÉÆ»¹Ô­±í¿Õ¼äµÄʹÓÃÇé¿ö»¹Ô­±£ÁôÆÚÌ«´ó»¹Ô­±£ÁôÆÚÉèÖÃΪ¸ßÓÚ¿ÉÄܵÄ×î¼Ñ»¹Ô­±£ÁôÆÚµÄÖµ, ²¢ÇÒ»¹Ô­±í¿Õ¼ä½«ÂúÍÆ¼öµÄ»¹Ô­±í¿Õ¼ä´óСÊÇ»ùÓÚϵͳÖеĻ¹Ô­Éú³ÉËÙÂʺͻ¹Ô­±£ÁôÆÚ¸ø³öµÄ¡£ÊµÀýûÓÐÁª»ú»¹Ô­±í¿Õ¼ä´óСΪ %d MB µÄÁª»ú»¹Ô­±í¿Õ¼äʵÀý¾ßÓÐÁª»ú»¹Ô­±í¿Õ¼äʵÀý¾ßÓÐÁª»ú»¹Ô­±í¿Õ¼äûÓÐÁª»ú»¹Ô­±í¿Õ¼ä, Ðí¶à²Ù×÷½«»áʧ°Ü õP ¸¤ ¹» ¬Ë ­Ü ®ý ¯ °A ±i ²… ³¯ ´ÑøÍƼöµÄ»¹Ô­±í¿Õ¼ä´óСÊÇ»ùÓÚϵͳÖеĻ¹Ô­Éú³ÉËÙÂÊ, »¹Ô­±£ÁôÆÚºÍ×²éѯ³ÖÐøÊ±¼ä¸ø³öµÄ¡£±í¿Õ¼ä [%s] ÒÑÕ¼Óà [%s]¸ø±í¿Õ¼äÌí¼Ó¿Õ¼ä¶ÈÁ¿ "%s" λÓÚ %s¶ÈÁ¿ "%s" λÓÚ %s (¶ÔÓÚÎļþ "%s")¶ÈÁ¿ "%s" λÓÚ %s (¶ÔÓÚ·þÎñ "%s")¶ÈÁ¿ "%s" λÓÚ %s (¶ÔÓÚʼþÀà "%s")ÔËÐÐ ADDM ÒÔ»ñµÃϵͳµÄÏêϸÐÔÄÜ·ÖÎö×ÊÁÏ¡£»á»° %s ×èÈûÁËÆäËû %s ¸ö»á»°ÓйضÈÁ¿ "%s" µÄãÐÖµÒѸüР(¶ÔÓÚʵÀý "%s")²é¿´ DBA_THRESHOLDS ÊÓͼÒÔÑéÖ¤½á¹û"±í¿Õ¼äµÄ¿Õ¼äʹÓÃÇé¿ö" ¶ÈÁ¿µÄãÐÖµÒѸüРµ2 ¶P ·³ ¸ ¹m ºÊ »Üî±í¿Õ¼ä [%s] Ö»ÓÐ [%s] ¿ÕÏпռäÔËÐÐУ׼ʵÓóÌÐò²¢Ê¹Óý¨ÒéµÄ WRC ¿Í»§»ú (ÕâЩ¿Í»§»ú·Ö²¼ÔÚ¾ßÓбØÐèÈÝÁ¿µÄ¼ÆËã»úÖ®¼ä) ÊýÖØÐÂÆô¶¯ÖØ·Å¡£µ¥¸ö IO µÄƽ¾ùÏìӦʱ¼ä´ïµ½ÁËÏà¹ØÖµ %s ºÁÃë (Õë¶Ô WRC ¿Í»§»ú %s, ¸Ã¿Í»§»úÔÚ %s ÉÏ×÷Ϊ½ø³Ì %s ÔËÐÐ)¹ý¶àµÄÖØ·Å¿Í»§»úÁ¬½Ó (%s\\%) ÕýÔÚ WRC ¿Í»§»ú %s (ÔÚ %s ÉÏ×÷Ϊ½ø³Ì %s ÔËÐÐ) Öв¢ÐÐʹÓà CPU¹ý¶àµÄÖØ·Å¿Í»§»úÁ¬½Ó (%s\\%) ÕýÔÚ WRC ¿Í»§»ú %s (ÔÚ %s ÉÏ×÷Ϊ½ø³Ì %s ÔËÐÐ) ÖÐÖ´Ðв¢ÐÐ IO ²Ù×÷Êý¾Ý¿â´¦ÓÚ²¶»ñģʽÊý¾Ý¿â´¦ÓÚÖØ·Åģʽ,`trØš<Ä=Ôô%s ×Ö½Ú (¹² %s ×Ö½Ú) ÒÑʹÓà %s%%, ÉÐÓÐ %s ×Ö½Ú¿ÉÓá£ÊͷŻָ´Çø¿Õ¼äµÄÑ¡Ïî: 1. ¿¼ÂǸü¸Ä RMAN %s¡£Èç¹ûʹÓõÄÊÇ Data Guard, Ôò¿¼ÂǸü¸Ä RMAN %s¡£2. ʹÓà RMAN %s ÃüÁÎļþ±¸·Ýµ½´Å´ø¡£3. Ôö¼Ó´ÅÅ̿ռ䲢¼Ó´ó db_recovery_file_dest_size ²ÎÊý¡£4. ʹÓà RMAN %s ÃüÁîɾ³ý²»ÐèÒªµÄÎļþ¡£Èç¹ûʹÓÃÁ˲Ù×÷ϵͳÃüÁîÀ´É¾³ýÎļþ, ÔòʹÓà RMAN %s ÃüÁî¡£Èç¹û±íÒÑ´´½¨, ¹À¼ÆµÄ¿Õ¼äʹÓÃΪ %s ×Ö½Ú¡£Èç¹ûË÷ÒýÒÑ´´½¨, ¹À¼ÆµÄ¿Õ¼äʹÓÃΪ %s ×Ö½Ú¡£Ôö³¤Ç÷ÊÆ±íÊä³ö¡£Ã»ÓÐ×ã¹»µÄÐÅÏ¢, ÎÞ·¨Ìá³ö½¨Òé°¸¡£ >J?w@—AÄBìCDKEwF›G»HØþ´Ë¶ÔÏóµÄ¿ÕÏпռäСÓÚ 1%, ÒѾ­Ã»ÓÐѹËõµÄ¼ÛÖµ¡£½øÐÐѹËõ, ¹À¼Æ¿ÉÒÔ½ÚÊ¡ %s ×Ö½Ú¡£´Ë¶ÔÏóÓÐһЩ¿ÕÏпռä, µ«ÊÇÒòΪ %s, ²»ÄÜѹËõ¡£´Ë¶ÔÏóÖеĿÕÏпռäСÓÚ×îºóÒ»¸öÇøµÄ´óС¡£·ÖÅä¿Õ¼ä:%s: ÒÑÓÿռä:%s: ¿É»ØÊÕ¿Õ¼ä:%s:ÆôÓñí %s.%s µÄÐÐÒÆ¶¯²¢Ö´ÐÐÊÕËõ, ¹À¼Æ¿ÉÒÔ½ÚÊ¡ %s ×Ö½Ú¡£ÔÚ¶ÔÏó %s ÉÏÖ´ÐÐÖØ×é, ¹À¼Æ¿ÉÒÔ½ÚÊ¡ %s ×Ö½Ú¡£Í¨¹ýÖØ×é¿ÉÒÔɾ³ý°Ù·ÖÖ® %s µÄÁ´½ÓÐС£¶ÔÏó¾ßÓпÉͨ¹ýÖØ×éɾ³ýµÄÁ´½ÓÐС£´Ë¶ÔÏóÖеĿÕÏпռäСÓÚ 10MB¡£Ñ¹Ëõ¶ÔÏó %s.%s, ¹À¼Æ¿ÉÒÔ½ÚÊ¡ %s ×Ö½Ú¡£ I>JlKœLæM"Nh °¡ÓçõѹËõ¶ÔÏó %s.%s ·ÖÇø %s, ¹À¼Æ¿ÉÒÔ½ÚÊ¡ %s ×Ö½Ú¡£Ñ¹Ëõ¶ÔÏó %s.%s ×Ó·ÖÇø %s, ¹À¼Æ¿ÉÒÔ½ÚÊ¡ %s ×Ö½Ú¡£I/O ÇëÇó/·ÖÖÓ: %s, I/O µÈ´ý/·ÖÖÓ: %s, ¶Î´óС (MB): %s, I/O µÈ´ý/ÇëÇó: %s¡£½«¶ÔÏó %s.%s ÒÆ¶¯µ½¿ìËÙ´æ´¢, ¹À¼Æ I/O µÈ´ý¼õÉÙʱ¼äΪ %s ºÁÃ뽫¶ÔÏó %s.%s ·ÖÇø %s ÒÆ¶¯µ½¿ìËÙ´æ´¢, ¹À¼Æ I/O µÈ´ý¼õÉÙʱ¼äΪ %s ºÁÃë¡£½«¶ÔÏó %s.%s ×Ó·ÖÇø %s ÒÆ¶¯µ½¿ìËÙ´æ´¢, ¹À¼Æ I/O µÈ´ý¼õÉÙʱ¼äΪ %s ºÁÃë¡£´¦Àí Grid Director ²»ÐèÒªÈκβÙ×÷¡£ÊµÀýÕý´¦ÓÚ¾²Ä¬×´Ì¬¡£²»ÐèÒªÈκβÙ×÷ >`‘ÂíM‚½ø¸ù¾ÝÐèÒªÖØÐÂÆô¶¯, ²»»á×Ô¶¯ÖØÐÂÆô¶¯ÊµÀý %s ÔÚ½Úµã %s ÉÏÆô¶¯µÄʱ¼äΪ %s; Ô­Òò´úÂë: %sʵÀý %s ÔÚ½Úµã %s ÉϹرյÄʱ¼äΪ %s; Ô­Òò´úÂë: %s×éºÏ·þÎñ %s%s Æô¶¯µÄʱ¼äΪ %s; Ô­Òò´úÂë: %s×éºÏ·þÎñ %s%s ¹Ø±ÕµÄʱ¼äΪ %s; Ô­Òò´úÂë: %s·þÎñÔÚʵÀý %s ½Úµã %s ÉÏÆô¶¯µÄʱ¼äΪ %s; Ô­Òò´úÂë: %s·þÎñÔÚʵÀý %s ½Úµã %s ÉϹرյÄʱ¼äΪ %s; Ô­Òò´úÂë: %s·þÎñÔ¤Á¬½ÓÔÚʵÀý %s ½Úµã %s ÉÏÆô¶¯µÄʱ¼äΪ %s; Ô­Òò´úÂë: %s·þÎñÔ¤Á¬½ÓÔÚʵÀý %s ½Úµã %s ÉϹرյÄʱ¼äΪ %s; Ô­Òò´úÂë: %s 8!g"–#Ã$øÌ-ÍVÎÏøÊý¾Ý¿â %s (Óò %s) Æô¶¯µÄʱ¼äΪ %s; Ô­Òò´úÂë: %sÊý¾Ý¿â %s (Óò %s) ¹Ø±ÕµÄʱ¼äΪ %s; Ô­Òò´úÂë: %s½Úµã %s Ô­ÐÍ %s ¹Ø±ÕµÄʱ¼äΪ %s; Ô­Òò´úÂë: %sASM ʵÀý %s ÔÚ½Úµã %s ÉÏÆô¶¯µÄʱ¼äΪ %s; Ô­Òò´úÂë: %sASM ʵÀý %s ÔÚ½Úµã %s ÉϹرյÄʱ¼äΪ %s; Ô­Òò´úÂë: %sSTREAMS ²¶»ñ½ø³Ì "%s" ÒÑÖÐÖ¹, ³öÏÖ ORA-%s»ñÈ¡ dba_capture ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_capture_adm.start_capture ÖØÐÂÆô¶¯²¶»ñ½ø³Ì¡£STREAMS Ó¦Óýø³Ì "%s" ÒÑÖÐÖ¹, ³öÏÖ ORA-%sÏ ÐöÑ Ò©á»ñÈ¡ dba_apply ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_apply_adm.start_apply ÖØÐÂÆô¶¯Ó¦Óýø³Ì¡£Èç¹û´íÎóΪ ORA-26714, Ç뿼Âǽ« 'DISABLE_ON_ERROR' Ó¦ÓòÎÊýÉèÖÃΪ 'N' ÒÔ±ÜÃâÒÔºó³öÏÖÓû§´íÎóʱÖÐÖ¹¡£STREAMS ´«²¥½ø³Ì "%s" ÔÚ 16 ´Îʧ°ÜÖ®ºóÖÐÖ¹»ñÈ¡ dba_queue_schedules ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_propagation_adm.start_propagation ÖØÐÂÆô¶¯´«²¥½ø³Ì¡£Èç¹ûµ±Ç°ÕýÔÚÔËÐеŤ×÷Á¿ÎªµäÐÍÖµ, Ç뿼ÂÇÔö¼ÓÁ÷³ØµÄ´óС¡£Ó&ÔcÕÖj×ÏøÓ¦Óýø³Ì "%s" µÄ STREAMS ´íÎó¶ÓÁаüº¬´øÓÐ ORA-%s µÄÐÂÊÂÎñ´¦Àí²é¿´´íÎó¶ÓÁÐÒÔ¼° dba_apply_error µÄÄÚÈÝÒÔÈ·¶¨´íÎóµÄÆðÒò¡£Ò»µ©½â¾öÁË´íÎó, ÇëʹÓà dbms_apply_adm.execute_error »ò dbms_apply_adm.execute_all_errors ÖØÐÂÖ´ÐÐËüÃÇ¡£ÔÚԭʼ²¶»ñ½ø³Ì "%s", ԭʼÁ÷½ø³Ì "%s", ¿Ë¡µÄ²¶»ñ½ø³Ì "%s" ºÍ¿Ë¡µÄÁ÷½ø³Ì "%s" Öз¢ÉúÁË STREAMS ×Ô¶¯²ð·ÖÒ»µ©¿Ë¡µÄÁ÷½ø³ÌÕý³£¹¤×÷, STREAMS ×Ô¶¯ºÏ²¢¾Í»á×Ô¶¯Ö´ÐС£²é¿´ DBA_STREAMS_SPLIT_MERGE ÒÔÁ˽âÏêϸÐÅÏ¢¡£XStream ²¶»ñ½ø³Ì "%s" ÒÑÖÐÖ¹, ³öÏÖ ORA-%sØ Ù™ÚÂÛ˜»ñÈ¡ dba_capture ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_capture_adm.start_capture ÖØÐÂÆô¶¯²¶»ñ½ø³Ì¡£XStream Ó¦Óýø³Ì "%s" ÒÑÖÐÖ¹, ³öÏÖ ORA-%s»ñÈ¡ dba_apply ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_apply_adm.start_apply ÖØÐÂÆô¶¯Ó¦Óýø³Ì¡£Èç¹û´íÎóΪ ORA-26714, Ç뿼Âǽ« 'DISABLE_ON_ERROR' Ó¦ÓòÎÊýÉèÖÃΪ 'N' ÒÔ±ÜÃâÒÔºó³öÏÖÓû§´íÎóʱÖÐÖ¹¡£XStream ´«²¥½ø³Ì "%s" ÔÚ 16 ´Îʧ°ÜÖ®ºóÖÐÖ¹Ü Ý©Þæß†û»ñÈ¡ dba_queue_schedules ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_propagation_adm.start_propagation ÖØÐÂÆô¶¯´«²¥½ø³Ì¡£Ó¦Óýø³Ì "%s" µÄ XStream ´íÎó¶ÓÁаüº¬´øÓÐ ORA-%s µÄÐÂÊÂÎñ´¦Àí²é¿´´íÎó¶ÓÁÐÒÔ¼° dba_apply_error µÄÄÚÈÝÒÔÈ·¶¨´íÎóµÄÆðÒò¡£Ò»µ©½â¾öÁË´íÎó, ÇëʹÓà dbms_apply_adm.execute_error »ò dbms_apply_adm.execute_all_errors ÖØÐÂÖ´ÐÐËüÃÇ¡£ÔÚԭʼ²¶»ñ½ø³Ì "%s", ԭʼ XStream ½ø³Ì "%s", ¿Ë¡µÄ²¶»ñ½ø³Ì "%s" ºÍ¿Ë¡µÄ XStream ½ø³Ì "%s" Öз¢ÉúÁË XStream ×Ô¶¯²ð·Öà áŒâ¸ã1]Ò»µ©¿Ë¡µÄ XStream ½ø³ÌÕý³£¹¤×÷, XStream ×Ô¶¯ºÏ²¢¾Í»á×Ô¶¯Ö´ÐС£²é¿´ DBA_STREAMS_SPLIT_MERGE ÒÔÁ˽âÏêϸÐÅÏ¢¡£GoldenGate ²¶»ñ½ø³Ì "%s" ÒÑÖÐÖ¹, ³öÏÖ ORA-%s»ñÈ¡ dba_capture ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_capture_adm.start_capture ÖØÐÂÆô¶¯²¶»ñ½ø³Ì¡£GoldenGate Ó¦Óýø³Ì "%s" ÒÑÖÐÖ¹, ³öÏÖ ORA-%sä åöæ#ç¬ì»ñÈ¡ dba_apply ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_apply_adm.start_apply ÖØÐÂÆô¶¯Ó¦Óýø³Ì¡£Èç¹û´íÎóΪ ORA-26714, Ç뿼Âǽ« 'DISABLE_ON_ERROR' Ó¦ÓòÎÊýÉèÖÃΪ 'N' ÒÔ±ÜÃâÒÔºó³öÏÖÓû§´íÎóʱÖÐÖ¹¡£GoldenGate ´«²¥½ø³Ì "%s" ÔÚ 16 ´Îʧ°ÜÖ®ºóÖÐÖ¹»ñÈ¡ dba_queue_schedules ÖеÄ׼ȷ´íÎóÏûÏ¢, ²ÉÈ¡Êʵ±µÄ´ëÊ©ÒÔ¸üÕý¸Ã´íÎó, È»ºóʹÓà dbms_propagation_adm.start_propagation ÖØÐÂÆô¶¯´«²¥½ø³Ì¡£Ó¦Óýø³Ì "%s" µÄ GoldenGate ´íÎó¶ÓÁаüº¬´øÓÐ ORA-%s µÄÐÂÊÂÎñ´¦Àíè&éÆêD”¶•ëý²é¿´´íÎó¶ÓÁÐÒÔ¼° dba_apply_error µÄÄÚÈÝÒÔÈ·¶¨´íÎóµÄÆðÒò¡£Ò»µ©½â¾öÁË´íÎó, ÇëʹÓà dbms_apply_adm.execute_error »ò dbms_apply_adm.execute_all_errors ÖØÐÂÖ´ÐÐËüÃÇ¡£ÔÚԭʼ²¶»ñ½ø³Ì "%s", ԭʼ GoldenGate ½ø³Ì "%s", ¿Ë¡µÄ²¶»ñ½ø³Ì "%s" ºÍ¿Ë¡µÄ GoldenGate ½ø³Ì "%s" Öз¢ÉúÁË GoldenGate ×Ô¶¯²ð·ÖÒ»µ©¿Ë¡µÄ GoldenGate ½ø³ÌÕý³£¹¤×÷, GoldenGate ×Ô¶¯ºÏ²¢¾Í»á×Ô¶¯Ö´ÐС£²é¿´ DBA_STREAMS_SPLIT_MERGE ÒÔÁ˽âÏêϸÐÅÏ¢¡£±í %s µÄÅÅÐò (ÔÚÁÐ %s ÉÏ) - °´¿é¼ÆÊýͳ¼ÆµÄѹËõÂÊΪ %sѹËõÀàÐÍ %s ²»ÕýÈ·–h—‚˜—™§š¶›áœ�ž ŸA ]¡�ˆÁ‰ÎŠß‹ìù±í %s %s - ¹À¼ÆÑ¹ËõÂÊΪ %s±í %s (²ÉÑù°Ù·Ö±È %s)ѹËõÂʵÄÊý¾Ý²»×ã¹À¼ÆÑ¹ËõÂÊΪ %s¶ÔÏóºÅ %s: ±í %s ¿ÉѹËõ - δѹËõµÄ¿éÊýΪ %sSYSTEM ºÍ SYSAUX ±í¿Õ¼ä²»Ö§³Ö´Ë¹ý³Ì±í¿Õ¼ä %s ²»´æÔÚ±í %s ²»´æÔÚ±í·ÖÇø %s.%s %s - ¹À¼ÆÑ¹ËõÂÊΪ %s±í·ÖÇø %s.%s (²ÉÑù°Ù·Ö±È %s)±í·ÖÇø %s.%s µÄÅÅÐò (ÔÚÁÐ %s ÉÏ) - ¹À¼ÆÑ¹ËõÂÊΪ %s¶ÔÏóºÅ %s: ±í·ÖÇø %s.%s ¿ÉѹËõ - δѹËõµÄ¿éÊýΪ %s"¹ÜÀí" µÈ´ýÀà"Ó¦ÓóÌÐò" µÈ´ýÀà"¼¯Èº" µÈ´ýÀà"²¢ÐÐ" µÈ´ýÀàŒ€��Žš�§�¸‘ɒѓ㔕%–=—W˜t™~šˆ›šœ¬�¼žÌŸÖð"ÅäÖÃ" µÈ´ýÀà"ÍøÂç" µÈ´ýÀà"ÆäËû" µÈ´ýÀà"µ÷¶È³ÌÐò" µÈ´ýÀà"Óû§ I/O" µÈ´ýÀ໺³åÇøÃ¦»º³åÇø¸ßËÙ»º´æãÅËøÓÉÓÚ DROP »ò TRUNCATE ¶ø²úÉúµÄ¼ì²éµãÓÉÓÚÈÕÖ¾Îļþ´óС¶ø²úÉúµÄ¼ì²éµãÓÉÓÚ MTTR ¶ø²úÉúµÄ¼ì²éµãÓÉÓÚ²¢Ðвéѯ¶ø²úÉúµÄ¼ì²éµãÓÉÓÚ±í¿Õ¼ä DDL ¶ø²úÉúµÄ¼ì²éµãÌá½»ºÍ»ØÍËCPU Õ¼ÓÃÂÊDBMS_LOCK ʹÓÃÇé¿öDBMS_PIPE ʹÓÃÇé¿ö¶îÍâµÄÖØÐ°ó¶¨Êý¿ÕÏлº³åÇøµÈ´ýÊýÓ²Óï·¨·ÖÎöÓÉÓÚʧЧ¶ø²úÉúµÄÓ²Óï·¨·ÖÎö ’¡²¢Ô£ò¤þ¥¦§ ¨0©<ªP«d¬x­‚®‹¯™°§±²²½³Å´ÏµÛ¶éóÓÉÓÚʹÓÃÁËÎÄ×Ö¶ø²úÉúµÄÓ²Óï·¨·ÖÎöÓÉÓÚÓï·¨·ÖÎö´íÎó¶ø²úÉúµÄÓ²Óï·¨·ÖÎöÓÉÓÚ¹²Ïí±ê×¼¶ø²úÉúµÄÓ²Óï·¨·ÖÎö¸ßË®ÏߵȴýÊýI/O ÍÌÍÂÁ¿Ë÷Òý¿é·ÖÀëÈ«¾Ö¸ßËÙ»º´æÃ¦È«¾Ö¸ßËÙ»º´æÕùÓû¥Á¬µÈ´ýʱ¼äÈ«¾Ö¸ßËÙ»º´æ¶ªÊ§µÄ¿éÈ«¾Ö¸ßËÙ»º´æÏûÏ¢´«ËÍÈ«¾Ö¸ßËÙ»º´æ¶à¿éÇëÇóITL µÈ´ýÊýJava Ö´ÐÐãÅËøÊͷŵȴýÊýÈÕÖ¾ÎļþÇл»ÊýPL/SQL ±àÒëPL/SQL Ö´ÐÐRMAN I/OÐÐËøµÈ´ýÊýÐòÁÐʹÓÃÇé¿ö»á»°Á¬½ÓºÍ¶Ï¿ª»á»°²Ûµ÷¶È·Œ¸˜¹¢º¬»¾¼È½Î¾Ú¿íÀ Á#Â8ÃLÄVÅjÆtǀȊɒʨËÂÌØî¹²Ïí³ØãÅËøÊýÂý¹éµµ³ÌÐòÈíÓï·¨·ÖÎö¿Õ¼äÊÂÎñ´¦ÀíµÈ´ýÊýÁ÷µÄÁ÷¿ØÖƱíËøÊýÁÙʱ¿Õ¼äÕùÓð´ I/O ÅÅÐòµÄ¶¥¼¶¶Î°´ "¼¯Èº" µÈ´ýÅÅÐòµÄ¶¥¼¶ SQL°´Êý¾Ý¿âʱ¼äÅÅÐòµÄ¶¥¼¶ SQL°´ I/O ÅÅÐòµÄ¶¥¼¶ SQL»º³åÇø¸ßËÙ»º´æ²»¹»´óPGA ²»¹»´óÖØ×öÈÕÖ¾»º³åÇø²»¹»´óSGA ²»¹»´ó¹²Ïí³Ø²»¹»´óÁ÷³Ø²»¹»´ó»¹Ô­ I/OÌØÊâµÄ "¹ÜÀí" µÈ´ýʼþÌØÊâµÄ "Ó¦ÓóÌÐò" µÈ´ýʼþÌØÊâµÄ "¼¯Èº" µÈ´ýʼþÌØÊâµÄ "Ìá½»" µÈ´ýʼþÍžδÏÊÐàÑöÒÓ*Ô;ÕEÖM×PØXÙ`ÚdÛhÜlÝtނߌà–ášâ§ã½äËåØüÌØÊâµÄ "²¢ÐÐ" µÈ´ýʼþÌØÊâµÄ "ÅäÖÃ" µÈ´ýʼþÌØÊâµÄ "ÍøÂç" µÈ´ýʼþÌØÊâµÄ "ÆäËû" µÈ´ýʼþÌØÊâµÄ "µ÷¶È³ÌÐò" µÈ´ýʼþÌØÊâµÄ "Óû§ I/O" µÈ´ýʼþÐéÄâÄÚ´æÐ´Èë/д³ö×ÊÔ´¹ÜÀíÆ÷Óï·¨·ÖÎöCPUÊý¾Ý I/OÖØ×ö I/OÄڴ滥Á¬¿Õ¼äÄÚ²¿²¢ÐÐÓ¦ÓóÌÐòµÈ´ýÊý¶ÓÁвÙ×÷Êý¶¥¼¶Ê¹ÓÃÕ߯äËû"ÅŶÓ" µÈ´ýÀàÌØÊâµÄ "ÅŶÓ" µÈ´ýʼþʵÀýÄÚ´æ²»¹»´ó¶¥¼¶ SQL Óï¾ä°´ "Óû§ I/O" ºÍ "¼¯Èº" ͳ¼ÆµÄ¶¥¼¶¶Îæ8çGìXí�îÌï.ðfñžÓ»º³åÇøÃ¦ - Èȿ黺³åÇøÃ¦ - ÈȶÔÏ󲿷ÖʵÀýÖÐÓë¹²Ïí³ØÏà¹ØµÄãÅËøÕùÓÃÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£²¿·ÖʵÀýÖжԻº³åÇø¸ßËÙ»º´æãÅËøµÄÕùÓÃÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£²¿·ÖʵÀýÖеȴý¿ÕÏлº³åÇøÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£Êý¾Ý¿âдÈë½ø³Ì (DBWR) ÎÞ·¨Âú×ã¶Ô¿ÕÏлº³åÇøµÄÐèÒª¡£²¿·ÖʵÀýÖеȴýÖØ×öÈÕÖ¾»º³åÇø¿Õ¼äÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£²¿·ÖʵÀýÖÐÖ÷»ú CPU ÊÇÆ¿¾±¡£µÈ´ýʱ¼ä½«ÒòµÈ´ý CPU ¶øÑÓ³¤¡£²¿·ÖʵÀýµÄÖ÷»ú²Ù×÷ϵͳÖмì²âµ½´óÁ¿ÐéÄâÄÚ´æÐ´Èë/д³ö¡£ò,ójô¤õÚö÷d�²¿·ÖʵÀýÖÐ "ÆäËû" µÈ´ýÀàÖеÄÊý¾Ý¿âãÅËøÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£²¿·ÖʵÀýÖлº³åÇø¸ßËÙ»º´æ²»¹»´ó, ´Ó¶øµ¼Ö´óÁ¿µÄ¸½¼Ó¶Á I/O¡£²¿·ÖʵÀýÖÐ SGA ´óС²»ºÏÊÊ, µ¼Ö¸½¼Ó I/O »òÓ²Óï·¨·ÖÎö¡£²¿·ÖʵÀýÖÐÁ÷³Ø´óС²»ºÏÊÊ, µ¼Ö¸½¼Ó I/O ²¢×èÈûÁ÷Èë¶Ó²Ù×÷¡£²¿·ÖʵÀýÖÐ PGA ´óС²»ºÏÊʵ¼ÖÂÁ˶ÔÁÙʱ±í¿Õ¼äµÄ¸½¼Ó I/O, ´Ó¶øÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£²¿·ÖʵÀýÖÐ¶Ô SQL Óï¾äµÄÓ²Óï·¨·ÖÎöÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ø&ù™úßû(ü…êÓÉÓÚ²¿·ÖʵÀýÖÐÓα껷¾³²»Æ¥Åä, ²»Äܹ²Ïí¾ßÓÐÏàͬÎı¾µÄ SQL Óï¾ä¡£ÕâÑù»áµ¼Ö¸½¼ÓµÄÓ²Óï·¨·ÖÎö, Òò¶øÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚ²¿·ÖʵÀýÖй²Ïí³Ø´óС²»×ã¶ø²úÉúµÄÓ²Óï·¨·ÖÎöÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£²¿·ÖʵÀýÖгöÏÖÓï·¨·ÖÎö´íÎóµÄ SQL Óï¾äµÄÓ²Óï·¨·ÖÎöÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚ DDL ²Ù×÷, Óα꽫ʧЧ¡£ÔÚ²¿·ÖʵÀýÖÐÕâÑù»áµ¼Ö¸½¼ÓµÄÓ²Óï·¨·ÖÎö, Òò¶øÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÓÉÓÚʹÓÃÁËÎÄ×Ö, ²»ÔÙ¹²Ïí SQL Óï¾ä¡£ÔÚ²¿·ÖʵÀýÖÐÕâÑù»áµ¼Ö¸½¼ÓµÄÓ²Óï·¨·ÖÎö, Òò¶øÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ý8þqÿ¥ÞMk’Ù²¿·ÖʵÀýÖÐ¶Ô SQL Óï¾äµÄÈíÓï·¨·ÖÎöÕýÔÚÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÒÑ·ÖÎöʵÀýºÅµÄÁбí, ÔÚÈ«¾Ö ADDM ½ö·ÖÎö²¿·ÖʵÀýʱʹÓÃʵÀýÕýÔÚʹÓù«Óû¥Á¬É豸 "%s" (IP µØÖ·Îª %s, ԴΪ "%s")¡£ÊµÀýÕýÔÚʹÓÃרÓû¥Á¬É豸 "%s" (IP µØÖ·Îª %s, ԴΪ "%s")¡£ÔÚʵÀý¼¶µÄ ADDM ÈÎÎñÖвéÕÒÌØ¶¨ÊµÀýʹÓõĻ¥Á¬É豸ÁÐ±í¡£²¿·ÖʵÀýÕýÔÚʹÓù«Óû¥Á¬É豸¡£Oracle ʵÀýÄÚ´æ (SGA ºÍ PGA) ´óСºÏÊÊ¡£Oracle ʵÀýÄÚ´æ (SGA ºÍ PGA) ´óС²»ºÏÊÊ, µ¼Ö¸½¼ÓµÄ I/O ºÍ CPU Õ¼ÓÃÂÊ¡£,{°î y ËíÓÉÓÚÔÚ·ÖÎöʱ¶ÎÆÚ¼ä¸ü¸ÄÁË "memory_target" µÄÖµ, Òò´ËÎÞ·¨È·¶¨ÊµÀýµÄ×î¼ÑÄÚ´æÄ¿±ê¡£ÓÉÓÚ AWR ¿ìÕÕ²»ÍêÕû, Òò´ËÎÞ·¨È·¶¨ÊµÀýµÄ×î¼ÑÄÚ´æÄ¿±ê¡£Í¨¹ý½«²ÎÊý "memory_target" ÉèÖÃΪ %s M, Ôö¼Ó·ÖÅä¸øÊµÀýµÄÄÚ´æ¡£Oracle ʵÀýÄÚ´æ (SGA ºÍ PGA) ´óС²»ºÏÊÊ, µ¼Ö¸½¼ÓµÄ I/O ºÍ CPU Õ¼ÓÃÂÊ¡£»òÕß, ·ÇĬÈÏ´óСµÄ¿éµÄijЩ»º³åÇø¸ßËÙ»º´æ²»¹»´ó, µ¼Ö´óÁ¿¸½¼Ó¶Á I/O¡£²¿·ÖʵÀýÖÐ Oracle ʵÀýÄÚ´æ (SGA ºÍ PGA) ´óС²»ºÏÊÊ, µ¼Ö¸½¼ÓµÄ I/O ºÍ CPU Õ¼ÓÃÂÊ¡£Îª×Ô¶¯ÔËÐÐ ADDM ÆôÓÃÊý¾Ý¿â·ÖÎöģʽ & ¬ 7‰ÄüÖÁÉÙ·¢ÏÖ %s Ìõ FORCE_MATCHING_SIGNATURE Ϊ %s ²¢ÇÒ PLAN_HASH_VALUE Ϊ %s µÄ SQL Óï¾äÕýÔÚʹÓÃ×ÖÃæÖµ¡£Çë²ÎÔÄ V$SQL Öиà SQL Óï¾äµÄʾÀý¡£ÖÁÉÙ·¢ÏÖ %s Ìõ FORCE_MATCHING_SIGNATURE Ϊ %s ²¢ÇÒ PLAN_HASH_VALUE Ϊ %s µÄ SQL Óï¾äÕýÔÚʹÓÃ×ÖÃæÖµ¡£Çë²ÎÔÄ SQL_ID Ϊ "%s" µÄ SQL Óï¾äʾÀý¡£ÓÅ»¯Èë¿Úµã PL/SQL "%s" (ÀàÐÍΪ "%s", ID Ϊ %s)¡£Óйظ½¼ÓÐÅÏ¢, Çë²ÎÔÄ PL/SQL Îĵµ¡£ÓÅ»¯Èë¿Úµã PL/SQL ID %s¡£Óйظ½¼ÓÐÅÏ¢, Çë²ÎÔÄ PL/SQL Îĵµ¡£»¨·ÑÁË %s ÃëÀ´Ö´ÐÐ PL/SQL "%s" (ÀàÐÍΪ "%s", ID Ϊ %s)¡£2YÁ;�¹Ùý»¨·ÑÁË %s ÃëÀ´Ö´ÐÐ ID Ϊ %s µÄ PL/SQL¡£ÔÚÒÔÏÂÇé¿öϹýÂË "%s" ÀàÐ͵IJéÕÒ½á¹û: ·ÖÎöʱ¶ÎÖÐÊÜÓ°ÏìµÄ»î¶¯»á»°ÉÙÓÚ %s, »òÕßÊÜÓ°ÏìµÄÊý¾Ý¿âʱ¼äÉÙÓÚ %s¡£ÔÚÒÔÏÂÇé¿öϹýÂËÓë SQL Óï¾ä (SQL_ID Ϊ "%s") ÓйصĽ¨Òé°¸: ÊÜ SQL Ó°ÏìµÄ»î¶¯»á»°ÉÙÓÚ %s, »òÕß SQL µÄÏìӦʱ¼äСÓÚ %s ΢Ãë¡£¹ýÂËÓëÒÔ϶ÎÓйصĽ¨Òé°¸: ÕâЩ¶ÎÊôÓÚËùÓÐÕß "%s", Ãû³ÆÎª "%s" ²¢ÇÒ×Ó¶ÔÏóÃû³ÆÎª "%s"¡£¹ýÂËÓëÊý¾Ý¶ÔÏó±àºÅΪ %s µÄ¶ÎÓйصĽ¨Òé°¸¡£¹ýÂ˽¨Òé°¸ÒÔ¸ü¸Ä²ÎÊý "%s" µÄÖµ¡£ÊµÀý¼äÏûÏ¢´«ËÍÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£2X˜Êì,˜âʵÀý¼äÏûÏ¢´«ËͲ¢Î´ÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼ä¡£µÈ´ýʱ¼äÔ¶¸ßÓÚÔ¤ÆÚµÄ¼¯Èº»¥Á¬µÈ´ýʱ¼äÊÇÏûºÄ´óÁ¿Êý¾Ý¿âʱ¼äµÄÔ­Òò¡£È«¾Ö¸ßËÙ»º´æ·þÎñ½ø³Ì (LMSn) ´¦ÀíÇëÇóµÄËٶȲ»¹»¿ì¡£Êý¾Ý¿âÏûºÄµÄ»¥Á¬´ø¿íΪÿÃë %s kb¡£È«¾Ö¸ßËÙ»º´æ·þÎñ½ø³Ì (LMSn) µÄÖ´ÐÐʱ¼äÔڿɽÓÊÜµÄ %s ºÁÃëÏÞÖÆÄÚ¡£Ñо¿¶Ô´ÓÔ¶³ÌʵÀý "%s" ½ÓÊÕµ½µÄ¿éµÄÕùÓÃÔ­Òò¡£´ËÎÊÌâͨ³£Ó볤ʱ¼äµÈ´ýÔ¶³ÌʵÀýÖÐµÄ "gcs ÈÕ־ˢÐÂͬ²½" ʼþÏà¹Ø¡£µÈ´ýÒ»¸öʵÀýÖÐµÄ "ÈÕÖ¾Îļþͬ²½" ʼþ¿ÉÄܵ¼ÖÂ¶ÔÆäËûʵÀýµÄÈ«¾Ö¸ßËÙ»º´æÕùÓá£,d –!å".#\°Ñо¿ÔÚ´ËʵÀý´ÓÔ¶³ÌʵÀý "%s" ½ÓÊÕµ½µÄ¿éÉÏ´æÔÚÕùÓõÄÔ­Òò¡£Ñо¿ÔÚ´ÓÔ¶³ÌʵÀý "%s" ½ÓÊÕµ½µÄ¿éÉÏ´æÔÚÕùÓõÄÔ­Òò¡£´ËÎÊÌâͨ³£ÓëÔ¶³ÌʵÀýÖÐµÄ CPU Æ¿¾±, ÐéÄâÄÚ´æ·ÖÒ³»ò²»Êʵ±µÄ LMSn ½ø³ÌÓÅÏȼ¶Óйء£É豸 "%s" ÒÑÓÃÓÚ %s\\% µÄ»¥Á¬Í¨ÐÅ, ²¢ÔÚ·ÖÎöÆÚ¼äÓöµ½ %s ¸ö·¢ËÍ»ò½ÓÊÕ´íÎó¡£É豸 "%s" ÔÚ·ÖÎöÆÚ¼äÓöµ½ %s ¸ö·¢ËÍ»ò½ÓÊÕ´íÎó¡£¶ÔÓÚÈ«¾Ö¸ßËÙ»º´æÏûÏ¢, ʵÀýÏûºÄµÄ»¥Á¬´ø¿íΪÿÃë %s kb¡£Òò´ËÆäËû»¥Á¬Í¨ÐŵÄÐÅÏ¢²»¿ÉÓá£$&%|&ä'(S¿¶ÔÓÚÈ«¾Ö¸ßËÙ»º´æÏûÏ¢, Êý¾Ý¿âÏûºÄµÄ»¥Á¬´ø¿íΪÿÃë %s kb¡£Òò´ËÆäËû»¥Á¬Í¨ÐŵÄÐÅÏ¢²»¿ÉÓᣴ˻¥Á¬´ø¿íµÄ %s\\% ÒÑÓÃÓÚÈ«¾Ö¸ßËÙ»º´æÏûÏ¢´«ËÍ, %s\\% ÓÃÓÚ²¢ÐвéѯÏûÏ¢´«ËÍ, ²¢ÇÒ %s\\% ÓÃÓÚÊý¾Ý¿âËø¹ÜÀí¡£8K ´óСµÄ»¥Á¬ÏûÏ¢µÄƽ¾ùµÈ´ýʱ¼äΪ %s ΢Ãë¡£¿¼ÂǽµµÍ RMAN »òÊý¾Ý±Ã»î¶¯µÄËÙ¶È, »òÕßÔÚÓû§»î¶¯½ÏÉÙʱµ÷¶ÈÕâЩ×÷Òµ¡£Êý¾ÝºÍÁÙʱÎļþÉ쵀 I/O ÍÌÍÂÁ¿ÓÉÒÔϲ¿·Ö¹¹³É: RMAN Õ¼ %s%%, Êý¾Ý±ÃÕ¼ %s%%, »Ö¸´Õ¼ %s%%, ËùÓÐÆäËû»î¶¯Õ¼ %s%%¡£)&*¦+ô,+-„ÅijЩÊý¾ÝºÍÁÙʱÎļþµÄÐÔÄÜ±ÈÆäËûÊý¾ÝºÍÁÙʱÎļþµÍµÃ¶à¡£Èç¹û²»ÄÜʹÓà SAME ·½·¨½«ËùÓеÄÎļþÌõ´ø»¯, ¿É¿¼Âǽ«ÕâЩÎļþÌõ´ø»¯ÖÁ¶à¸ö´ÅÅÌ¡£¶ÔÓÚÎļþ %s, µ¥¸ö¿é¶ÁÈ¡µÄƽ¾ùÏìӦʱ¼äΪ %s ºÁÃë, ¶îÍâ I/O µÈ´ý×Üʱ¼äΪ %s Ãë¡£Ñо¿¹éµµ³ÌÐò½ø³ÌµÄÎļþ I/O ÍÌÍÂÁ¿ÒÔÈ·±£ÆäÊʺϻù´¡Ó²¼þ¡£¹éµµ³ÌÐòÔÚÖØ×öÈÕÖ¾ÎļþÉ쵀 I/O ÍÌÍÂÁ¿ÎªÃ¿Ãë %s, ¶øÔÚµµ°¸ºÍµµ°¸±¸·ÝÈÕÖ¾ÎļþÉÏÔòΪÿÃë %s¡£ÖØ×öÈÕÖ¾ÎļþÉϵÄ×Ü I/O ÍÌÍÂÁ¿ÎªÃ¿Ãë %s, ¶ø¹éµµ³ÌÐòÕ¼ÆäÖÐµÄ %s%%¡£. /]PÜQDÎÖØ×öÈÕÖ¾ÎļþÉϵÄ×Ü I/O ÍÌÍÂÁ¿µÄ¶ÁȡΪÿÃë %s, дÈëΪÿÃë %s¡£ÖØ×öÈÕÖ¾ I/O ÍÌÍÂÁ¿ÓÉÒÔϲ¿·Ö¹¹³É: RMAN ºÍ»Ö¸´Õ¼ %s%%, ÈÕ־д½ø³ÌÕ¼ %s%%, ¹éµµ³ÌÐòÕ¼ %s%%, Á÷ AQ Õ¼ %s%%, ËùÓÐÆäËû»î¶¯Õ¼ %s%%¡£Ñо¿ %s Óï¾ä (SQL_ID Ϊ "%s"), È·¶¨ÊÇ·ñ¿ÉÒÔ¸ÄÉÆÐÔÄÜ¡£¿ÉÒÔÀûÓÃ´Ë SQL_ID µÄ ASH ±¨¸æÀ´²¹³ä´Ë´¦¸ø³öµÄÐÅÏ¢¡£¶Ô %s Óï¾ä (SQL_ID Ϊ "%s") ÔËÐÐ SQL ÓÅ»¯Ö¸µ¼¡£´ËÍâ, Ñо¿´ËÓï¾ä, È·¶¨ÊÇ·ñ¿ÉÒÔ¸ÄÉÆÐÔÄÜ¡£¿ÉÒÔÀûÓÃ´Ë SQL_ID µÄ ASH ±¨¸æÀ´²¹³ä´Ë´¦¸ø³öµÄÐÅÏ¢¡£R SOT¹UGâ¶Ô %s Óï¾ä (SQL_ID Ϊ "%s") ÔËÐÐ SQL ÓÅ»¯Ö¸µ¼¡£SQL ÔÚ CPU, I/O ºÍ¼¯ÈºµÈ´ýÉÏ»¨·ÑµÄʱ¼äÕ¼ÆäÊý¾Ý¿âʱ¼äµÄ %s%%¡£Õⲿ·ÖÊý¾Ý¿âʱ¼ä¿Éͨ¹ý SQL ÓÅ»¯Ö¸µ¼½øÐиÄÉÆ¡£SQL ÔÚ CPU, I/O ºÍ¼¯ÈºµÈ´ýÉÏ»¨·ÑµÄʱ¼äÖ»Õ¼ÆäÊý¾Ý¿âʱ¼äµÄ %s%%¡£Òò´Ë, SQL ÓÅ»¯Ö¸µ¼²»ÊÊÓÃÓÚÕâÖÖÇé¿ö¡£Çë²é¿´ SQL µÄÐÔÄÜÊý¾ÝÒÔÕÒ³ö¿ÉÄܵĸĽø·½·¨¡£SQL ÔÚ CPU, I/O ºÍ¼¯ÈºµÈ´ýÉÏ»¨·ÑµÄʱ¼äÕ¼ÆäÊý¾Ý¿âʱ¼äµÄ %s%%¡£Õⲿ·ÖÊý¾Ý¿âʱ¼ä¿Éͨ¹ý SQL ÓÅ»¯Ö¸µ¼½øÐиÄÉÆ¡£Çë²é¿´ÏÂÃæ¸ø³öµÄÊý¾ÝºÍ ASH ±¨¸æÒÔ½øÒ»²½¸ÄÉÆÐÔÄÜ¡£V,WPX»YòZg[¬ÍÎÞ·¨¶Ô´Ë SQL Óï¾äÔËÐÐ SQL ÓÅ»¯Ö¸µ¼¡£´Ë SQL µÄÊý¾Ý¿âʱ¼äÓÉÒÔϲ¿·Ö¹¹³É: SQL Ö´ÐÐÕ¼ %s%%, Óï·¨·ÖÎöÕ¼ %s%%, PL/SQL Ö´ÐÐÕ¼ %s%%, Java Ö´ÐÐÕ¼ %s%%¡£ÔÚ·ÖÎöÆÚ¼ä, ´Ë SQL Óï¾äÖÁÉÙÀûÓÃÁË %s ¸ö²»Í¬µÄÖ´Ðмƻ®¡£Ö´ÐÐ %s Óï¾ä (SQL_ID Ϊ "%s") µÄ¶¥¼¶µ÷ÓÃÕ¼Êý¾Ý¿âʱ¼äµÄ %s%%, ¸ÃÊý¾Ý¿âʱ¼äÊÇ»¨·ÑÔÚ %s Óï¾ä (SQL_ID Ϊ "%s") ÉϵÄʱ¼ä¡£·¢ÏÖ SQL Óï¾äÏûºÄÁË´óÁ¿Êý¾Ý¿âʱ¼ä¡£ÕâЩÓï¾äÌṩÁ˸ÄÉÆÐÔÄܵľø¼Ñ»ú»á¡£ÎÞ·¨¶Ô %s Óï¾äÔËÐÐ SQL ÓÅ»¯Ö¸µ¼¡£\&]|^É_#`u­¶Ô %s "%s.%s" (¶ÔÏó ID Ϊ %s) µÄÍêȫɨÃèÏûºÄÁËÔÚ´Ë SQL Óï¾äÉÏ»¨·ÑµÄÊý¾Ý¿âʱ¼äµÄ %s%%¡£¶Ô¶Î (¶ÔÏó ID Ϊ %s) µÄÍêȫɨÃèÏûºÄÁËÔÚ´Ë SQL Óï¾äÉÏ»¨·ÑµÄÊý¾Ý¿âʱ¼äµÄ %s%%¡£%s "%s.%s" (¶ÔÏó ID Ϊ %s) µÄ I/O ºÍ¼¯ÈºµÈ´ýÏûºÄÁËÔÚ´Ë SQL Óï¾äÉÏ»¨·ÑµÄÊý¾Ý¿âʱ¼äµÄ %s%%¡£¶Î (¶ÔÏó ID Ϊ %s) µÄ I/O ºÍ¼¯ÈºµÈ´ýÏûºÄÁËÔÚ´Ë SQL Óï¾äÉÏ»¨·ÑµÄÊý¾Ý¿âʱ¼äµÄ %s%%¡£·¢ÏÖ¸ö±ðÊý¾Ý¿â¶ÎÔì³ÉÁË´óÁ¿µÄ "Óû§ I/O" ºÍ "¼¯Èº" µÈ´ý¡£ab¡c'¡²é¿´ "¶¥¼¶ SQL Óï¾ä" ÒÔÕÒ³ö´Ë¶ÎÉÏÏûºÄ´óÁ¿ I/O µÄ SQL Óï¾ä¡£ÀýÈç, %s Óï¾ä (SQL_ID Ϊ "%s") Õ¼´Ë¶ÎÉ쵀 "Óû§ I/O" ºÍ "¼¯Èº" µÈ´ýµÄ %s%%¡£²é¿´ "¶¥¼¶ SQL Óï¾ä" ÒÔÕÒ³öÔÚÖ´ÐÐ Java ʱÏûºÄ´óÁ¿Ê±¼äµÄ SQL Óï¾ä¡£ÀýÈç, ÔÚ·ÖÎöÆÚ¼ä, %s Óï¾ä (SQL_ID Ϊ "%s") Õ¼ Java Ö´ÐÐʱ¼äµÄ %s%%¡£²é¿´ "¶¥¼¶ SQL Óï¾ä" ÒÔÕÒ³öÏûºÄ´óÁ¿ CPU ʱ¼äµÄ SQL Óï¾ä¡£ÀýÈç, ÔÚ·ÖÎöÆÚ¼ä, %s Óï¾ä (SQL_ID Ϊ "%s") Õ¼ CPU Õ¼ÓÃÂ浀 %s%%¡£d ežfg\ª²é¿´ "¶¥¼¶ SQL Óï¾ä" ÒÔÕÒ³öÔÚ¼¯ÈºµÈ´ýÉÏÏûºÄ´óÁ¿Ê±¼äµÄ SQL Óï¾ä¡£ÀýÈç, ÔÚ·ÖÎöÆÚ¼ä, %s Óï¾ä (SQL_ID Ϊ "%s") Õ¼¼¯ÈºµÈ´ýµÄ %s%%¡£²é¿´ "¶¥¼¶ SQL Óï¾ä" ÒÔÕÒ³öÔÚ "%s" µÈ´ýʼþÉÏÏûºÄ´óÁ¿Ê±¼äµÄ SQL Óï¾ä¡£ÀýÈç, %s Óï¾ä (SQL_ID Ϊ "%s") Õ¼ÕâЩµÈ´ýµÄ %s%%¡£ÔÚÊý¾Ý¿â¼¶±ðûÓпÉÓõĽ¨Òé°¸¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÌṩ½¨Òé°¸¡£Ôö¼ÓÊÜÓ°ÏìʵÀýµÄ»º³åÇø¸ßËÙ»º´æ´óС¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£h i{jÁkK¯¿¼ÂÇÌí¼Ó¸ü¶à CPU »ò¸ü¶àΪÊý¾Ý¿âÌṩ·þÎñµÄʵÀý¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÌṩÆäËû½¨Òé°¸¡£Ôö¼ÓÊÜÓ°ÏìʵÀýµÄ¹²Ïí³Ø´óС¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£Ñо¿ I/O ×ÓϵͳµÄдÐÔÄÜ¡£¿¼ÂÇÔö¼ÓÊý¾Ý¿âдÈë½ø³ÌÊý, ²¢¿¼ÂÇÒì²½ I/O µÄÊʺÏÐÔÒÔ¼°Ê¹ÓÃÖ±½Ó·¾¶²åÈë¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£Ñо¿Ó¦ÓóÌÐòÂß¼­, ̽ÌÖʹÓð󶨱äÁ¿´úÌæÎÄ×ֵĿÉÄÜÐÔ¡£»òÕß, ¿É½«²ÎÊý "cursor_sharing" ÉèÖÃΪ "force"¡£l&m•nÛo=p‚ÆÔö¼ÓÊÜÓ°ÏìʵÀýµÄÖØ×öÈÕÖ¾»º³åÇø´óС¡£Ñо¿Áª»úÖØ×öÈÕÖ¾ÎļþµÄ I/O ÐÔÄÜ¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£Ôö¼Ó·ÖÅ䏸ÊÜÓ°ÏìʵÀýµÄÄÚ´æ¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£Ñо¿ÊÜÓ°ÏìÖ÷»úÉ쵀 Oracle ʵÀýºÍÆäËûÓ¦ÓóÌÐòµÄÄÚ´æ·ÖÅä¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£Ôö¼ÓÊÜÓ°ÏìʵÀýµÄ SGA ´óС¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£Ôö¼ÓÊÜÓ°ÏìʵÀýµÄÁ÷³Ø´óС¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£ q>rƒs¬t×u3peqˆr¯sÌíÔö¼ÓÊÜÓ°ÏìʵÀýµÄ PGA ´óС¡£¼ì²éÊÜÓ°ÏìʵÀýµÄ ADDM ·ÖÎöÒÔÁ˽âÏêϸÐÅÏ¢¡£ÔÚ·ÖÎöÆÚ¼ä, "»º³åÇøÃ¦" µÈ´ýʼþûÓÐÈȿ顣ÔÚ·ÖÎöÆÚ¼ä, "»º³åÇøÃ¦" µÈ´ýʼþûÓÐÈȶÔÏó¡£¾ßÓÐ ID %s ºÍÐòÁкŠ%s (ÔÚʵÀýºÅ %s ÖÐ) µÄ»á»°Êǹ¹³É´Ë½¨Òé°¸ÖеÄÓÅ»¯½¨ÒéµÄ %s%% µÄ×èÈû»á»°¡£×Ó³ÌÐò ID %s (PL/SQL ID %s) ÔÚÖ´ÐÐÉÏ»¨·ÑÁË %s Ãë¡£%s ÒÑÊ×ÏÈÖ´ÐÐÒÔÔ¤ÈÈ»º³åÇø¸ßËÙ»º´æ¡£%s µÄͳ¼ÆÐÅÏ¢ÊǺóÃæµÄ %s Ö´ÐÐµÄÆ½¾ùÖµ¡£%s µÄͳ¼ÆÐÅÏ¢À´×ÔµÚ¶þ´ÎÖ´ÐС£%s µÄͳ¼ÆÐÅÏ¢ÊÇ %s Ö´ÐÐµÄÆ½¾ùÖµ¡£ÿÿÿÿ