!  sD  s  +2:CJQYahlt-6>FMU\biqx{~Zfr&.4;?BHNS[ckpw| >H #(.RV\adimss2x~Ҽ{sWh CPU ܥD, ηsWѪAȵLDWƮwBz.CPU OBz~V.b SQL_ID "%s" SQL ԭzyuSQL վij{v.D CPU O~VҦb, Bzϥ %s\\% D CPU. Ҧݮɶ|] CPU Xj.㦳æŪgʪ@ΰ϶ ( "%s"). ϶ݩϬq "%s.%s", ӥBO϶ %s (bɮ %s ).Ʈw϶ŪgvϥΤjqƮwɶ. O, S@OyovDn].w֪Ʈwɶ (ʸU@).& c ۽լdε{޿ӧXy϶ƤæŪgʪ].ݡuwİϦLvƥåϥΤjqƮwɶ.ܤֵo{ %s Ө PLAN_HASH_VALUE %s SQL ԭzynϥΤr. Ьd V$SQL, o SQL ԭzyd.Ʈw϶ŪgvϥΤjqƮwɶ.Ҽ{bŶ "%s" (]t %s "%s.%s" B ID %s) ޲zŶϥ ORACLE ij۰ʰϬqŶ޲zѨM. Ϊ, ziHN󲾦ܨϥΦ۰ʰϬqŶ޲zi楻޲z䥦Ŷ. &y:Ҽ{ϥΦbhӤΰϥtæ DML 覡, %s "%s.%s" ( ID %s).Ҽ{ϥθj PCTFREE ȭsإ %s "%s.%s" ( ID %s).SQL_ID "%s" UPDATE ԭzyYuwİϦLvݪvT.SQL_ID "%s" INSERT ԭzyYu֨wİϦLvvT.BzϥΤjq CPU ɶ. O, SDn SQL ԭzyOy CPU t]., Tɦb "%s" Ʈw϶vϥΤjqƮwɶ. ϶ݩϬq "%s.%s", ӥBOѰ϶s %s (bɮ׽s %s ) ѧO.Ҽ{ϥΦbhӤΰϥtæ DML 覡, Ӥ %s "%s.%s" ( ID %s).wİϧ֨ꪺvϥΤjqƮwɶ.Ҽ{b SQL _ID "%s" INSERT ԭzyϥΰ}C.SQL_ID "%s" UPDATE ԭzyYu֨wİϦLvvT.DBMS_PIPE.PUT IsݥϥΤjqƮwɶ. >Qx SQL_ID "%s" DELETE ԭzyYu֨wİϦLvvT.Ҽ{sWL޸ŪBz@~Υ[tŪ.Ҽ{ϥ DBMS_PIPE M˵{ӼW[إߪ޸jp.lܪv], Oѩε{ SELECT ԭzyϥοJT.DBMS_PIPE.PUT IsݶبϥΤjqƮwɶ.OuævϥΤjqƮwɶ.OuævϥΤjqƮwɶ.ݨƥ "%s" (O "%s") ϥΤjqƮwɶ.Ou޲zvϥΤjqƮwɶ. !J"u#$%&':(c)*+Ouε{vϥΤjqƮwɶ.OuOvϥΤjqƮwɶ.OuT{vϥΤjqƮwɶ.OuպAvϥΤjqƮwɶ.OuvϥΤjqƮwɶ.OuƵ{vϥΤjqƮwɶ.Ouε{vϥΤjqƮwɶ.Ou޲zvϥΤjqƮwɶ.OuOvϥΤjqƮwɶ.OuT{vϥΤjqƮwɶ.OuպAvϥΤjqƮwɶ.,2-W.~/0'1f2OuvϥΤjqƮwɶ.OuƵ{vϥΤjqƮwɶ.b %s "%s.%s" ( ID %s) YƦCv. ШϥΫwj SQL lε{޿褤o͸ƦCv].O %s "%s.%s" ( ID %s) YŪgv.ϥ "DBMS_LOCK" ɵo{ SQL_ID "%s" SQL ԭzybw.SQL_ID "%s" SQL ԭzyQƦCwj.%s "%s.%s" ( ID "%s") wQw@qɶ.384v5678Q9p:ߨϥ "DBMS_LOCK" M˵{owݨϥΤjqƮwɶ.ǧ֨|ϥΤjqƮwɶ.϶ݪvϥΤjqƮwɶ.Ҽ{ǥѳ]wѼ "log_archive_max_processes" ȨӷsWLsɾBz@~.wgFæקۦPƮw϶ƥخ, ITL ԭnD.ҼWqǰeO_ΩݩRƮw.bƥҦŶ %s. ҥO_A.ǥѼW[jpӽլdε{޿, X֪ COMMIT @~ƥ. ;><=>?@AArBCҼ{ǥѳ]wѼ "db_writer_processes" ӼW[ƮwgJƥ (DBWR).NxɤjpW[ %s M, Odܤ %s T.@γƥҦŶ DML yͨL.Ʈw϶ŪgvϥOjqƮwɶ.iνwİϪݥϥΤjqƮwɶ.Wз (HW) ԭnDݥϥΤjqƮwɶ.ITL ԭnDݥϥΤjqƮwɶ.sɾBz@~ݥϥΤjqƮwɶ.xɤ@~bˬdIɥϥΤjqƮwɶ.D2E[FGHI&J`xwİϪŶݥϥΤjqƮwɶ. COMMIT M ROLLBACK @~, ƥuxɦPBvݥϥΤjqƮwɶ.ƦCwݥϥΤjqƮwɶ.uŶ (ST)vԭnDݥϥΤjqƮwɶ.wݥϥΤjqƮwɶ.ϥ "DBMS_LOCK" M˵{owϥΤjqƮwɶ.o{ SQL_ID "%s" SQL ԭzyb %s "%s.%s" ( ID %s) Wз (HW).K2LMNO`PQo{ SQL_ID "%s" SQL ԭzyb %s "%s.%s" ( ID %s) uP쪺M (ITL)vԭnD.Ҽ{bŶ "%s" ޲zŶϥ ORACLE ij۰ʰϬqŶ޲zѨM.o{ SQL ԭzybݸƦCw. COMMIT M ROLLBACK @~, ƥuxɦPBvݨϥΤjqƮwɶ.ε{b %s , CC@jp %s 줸.ƮwgJ (DBWR) LktXiνwİϪݨD.ǧ֨|ϥΤjqƮwɶ.R8SWTUVWHXYsɾBz@~LktX.@γƥҦŶ DML yͨL, ]мW[sɾBz@~u@.xɤ@~bˬdIɨϥΤjqƮwɶ.NѼ "log_buffer" ȳ] %s ӼW[xwİϪjp.Wз (HW) ԭnDvϥΤjqƮwɶ.uŶ (ST)vԭnDݪvϥΤjqƮwɶ.ITL ԭnDݨϥΤjqƮwɶ.SQL_ID "%s" INSERT ԭzyYuwİϦLvݪvT.Z8[R\w]^&_O`~aD CPU ϥΪA %s\\%.iνwİϪݨϥΤjqƮwɶ.SQL_ID "%s" DELETE ԭzyYuwİϦLvݪvT.ˬdε{άdݱ` SQL ӧXI. boǶǨϥθj֨jp. pG RAC, קKϥ ORDER ]w.wİϧ֨ꪺvϥΤjqƮwɶ. ID "%s" ƮwwgQw@qɶ.q@~suM_suIsϥΤjqƮwɶ.q SQL_ID "%s" SELECT ԭzy^G, Шϥθj^}C. b2cdef8gihORACLE jPijznNε{μȮɸxsb SYSTEM Ŷ. ЦҼ{NƲܨLŶ.SQL_ID "%s" SELECT ԭzyYuwİϦLvݪvT.SQL_ID "%s" SELECT ԭzyYu֨wİϦLvvT.Ʈwɶ (ʸU@).椬BzTbBzϥΤjqƮwɶ.yƤJC@~]qt׽wCӥBϥΤjqƮwɶ, ӳQ_byq.椬BzTbBzϥΤjqƮwɶ.i jYklyƤJC@~å]qt׽wCӳQ_byq.ˬdε{, HְϬq %s.%s (SEGMENT_ID %s) 椬BzT .լdƮwBz׺ۤsu]. Oracle ijѨMkOϥΰtMκ.W[u֨A (LMSn)vBz@~t. ziHW[ "gcs_server_processes" ѼƭȨӼW[u֨AȡvBz@~ƥ. Ϊ, pGD CPU, ЦҼ{W[u֨AȡvBz@~@~tu.m2n{opq rLtY^ɶO, ˬdε{ΨӳsuܸƮwAȶO_w̨ΤƤ.լd %s "%s.%s" t׽wCq.o{yjq椬BzT SQL ԭzy.WXwOۤsuOyBzjqƮwɶDn].LBzu֨AȳBz@~ (LMSn) Lkܧ֪BznD.L RAC BzƪvϥΦBzjqƮwɶ.O㦳æŪgʪ@ΰ϶ ( "%s"). ϶ݩϬq "%s.%s", BO϶ %s (bɮ %s ).u,z{Yb "%s" Ʈw϶vϥOjqƮwɶ. ϶ݩϬq "%s.%s", ӥBO϶ %s (bɮ %s ).bOo{ "%s" B㦳æŪgʪ@ΰ϶. ϶OѰ϶s %s (bɮ׽s %s ) ѧO.bOo{㦳æŪgʪ@θư϶. ϶ݩϬq "%s.%s" BO϶ %s (bɮ %s ).OuϥΪ I/OvϥΤjqƮwɶ.լdWiuWxɤ I/O į઺i.gJuWxɪjpO %s K, ӥBC@gJɶ %s @.,BiPGA jpA, yȮɪŶL I/O ϥΤjqƮwɶ. Ѽ "pga_aggregate_target" ȦbRoܧ, ]Lki@BR.o{yjqϥΪ I/O ݪӧO SQL ԭzy.ɮ %s įLɮ׮t. pGLkϥ SAME kΩҦɮ, ЦҼ{bhӺϺФΦɮ.I/O ltΪBzOYCwį.wİϧ֨jp, yjqLŪ I/O.Dw]jpϰwİϧ֨jp, yjqLŪ I/O.&i4kPGA jpA, yȮɪŶL I/O, ϥΤjqƮwɶ.]]wAϥΪѼ "fast_start_io_target", "log_checkpoint_interval" M "log_checkpoint_timeout" ӳywİϧ֨gJ, ϥΤjqƮwɶ.]C MTTR ]wywİϧ֨gJϥΤjqƮwɶ.]pxɳywİϧ֨gJϥΤjqƮwɶ.bۦP󪺨æ DML Mdߩҳywİϧ֨gJ, I/O ltΪBzOYvT.,w] DROP M TRUNCATE @~ywİϧ֨gJ, I/O ltΪBzOYvT.] ALTER TABLESPACE @~ywİϧ֨gJ, I/O ltΪBzOYvT.OuϥΪ I/OvϥΤjqƮwɶ.ݳ@xɼgJƥج %s, WLD CPU %s ƥ. ], COMMIT @~e, bݥiΪ CPU.SQL_ID "%s" SQL ԭzyϥΤjqɶbI϶uwİϦLv.S@ SQL θƮwԭzyOyjq I/O ݪ].2YrsI/O ltΪBzOYCwį.wİϧ֨jpå.ȮɪŶ I/O ݥϥΤjqƮwɶ.ѩxɤjpMѼƳ]wȳywħ֨gJ, ϥΤjqƮw I/O.٭ I/O I/O ltΪBzOSYvT.]bۦP󪺨æ DML Md߳ywİϧ֨gJ, I/O ltΪBzOSYvT.] DROP M TRUNCATE @~ywİϧ֨gJ, I/O ltΪBzOSYvT.&|C¦] ALTER TABLESPACE @~ywİϧ֨gJ, I/O ltΪBzOSYvT.Cε{ͪjp|CuxɦPBvƥ󪺵ݮɶ.SQL_ID "%s" SQL ԭzyϥΤjqƮwɶbݼI϶u֨wİϦLv.b %s "%s.%s" ( ID %s) WuϬqij{v.Ҽ{W[ I/O ltΪBzO. Oracle ijѨM׬OϥάۦPkӤΩҦ. zi]ݭnW[Ϻмƥ, HoΪį.&dǥѱNѼ "db_cache_size" ȳ] %s M ӼW[wİϧ֨jp.ǥѱNѼ "pga_aggregate_target" ȳ] %s M ӼW[ PGA jp.Oracle ijѨM׬Oҥ PGA ۰ʰO޲z\. zunNѼ "pga_aggregate_target" ȳ] 0, Yiҥγo\.Oracle ijѨM׬Oϥ "fast_start_mttr_target" ѼƨN "fast_start_io_target", "log_checkpoint_interval" H "log_checkpoint_timeout" Ѽƨӱ MTTR ]w.Ҽ{W[Ѽ "fast_start_mttr_target" ȨӼW[ MTTR ]w.8rQzOracle ijѨM׬OϥΡu۰٭޲zvӭC٭v.ַ %s M %s ƲMݮ %s , oORɶ %s\\%. oi|C ADDM Ria.SjƮwʨӰ ADDM.lε{v %s "%s.%s" ( ID %s) ].լdP ID %s Ʈw I/O ε{޿.ް϶ζتvϥΤjqƮwɶ.ް϶ζتvϥΤjqƮwɶ.ް϶ζتvϥΤjqƮwɶ. O, oväOѳ@޳y.,nH{SQL_ID "%s" SQL ԭzyOjqɶݼ󪺡uϥΪ I/Ov.|R %s\\% έp, u@t %s\\%. oi|Co ADDM RiH.Oh϶nDϥΤjqƮwɶ.b SQL_ID "%s" SQL ԭzyuSQL վij{v. дM䤣ϥΪ󱽴yNp.]򥢪϶ӭժOqTϥΤjqƮwɶ.]򥢪϶ӭժOqTϥΤjqƮwɶ.&CvˬdOۤsuպA. ˬd@~tγ]w, Ҧp౵]w, MXʵ{. ˬd@~tΪqT𱵦wİϬO_HxsӦh϶Ū. iHCѼ "db_file_multiblock_read_count" ȷ@ѨMk.Bzϥθ˸m "%s" P IP } "%s" su.BzCϥ %s KB ۤsuWe.Oۤsubi %s @d.LBzu֨AȳBz@~ (LMSn)vbi %s @d򤺰.2g?pƮw϶ŪgJvϥOjqƮwɶ.լd SQL_ID "%s" SQL ԭzy, Xi઺įi. дM䤣ϥΪ󱽴yNp.Ʈw@bR %s%% ɱҰ.ݨƥ "%s" (O "%s"), bBz SQL_ID "%s" SQL ԭzyƮwɶ %s%%.A "%s" MҲ "%s" Oijįq %s%% ].ID "%s" q@~, ϥΪ ID "%s", { "%s" MҲ "%s" Oijįq %s%% ].ˬdvε{޿., o  ,v-A "%s" MҲ "%s" q@~Oijįq %s%% jq@~.ID "%s", ϥΪ ID "%s", { "%s" MҲլ "%s" q@~Oijįq %s%% jq@~.ϥΫwjq@~μҲսլdoͭv].Ҽ{ǥѳ]wѼ "db_writer_processes" ӼW[ƮwgJ (DBWR) ƥ . tЦҼ{DPB I/O O_AXz[c.լdjq "%s" ݪ]. аѦ Oracle "Database Reference", ooݨƥ󪺴yz. wR SQL ԭzyϥΤjqƮwɶ. .>/d01234f56nR SQL ԭzyϥΤjqƮwɶ.o{ϥΤjqƮwɶ SQL ԭzy. PL/SQL ϥΤjqƮwɶ.sĶ PL/SQL ϥΤjqƮwɶ. JAVA ϥΤjqƮwɶ.լdjq "%s" ݪ]. аѦ Oracle "Database Reference", ooݨƥ󪺴yz. ШϥΫw SQL Ӷii@Bլd.q@~suM_suIsϥΤjqƮwɶ.o{ SQL_ID "%s" SQL ԭzyb "%s" ݨƥ.R SQL ԭzyϥΤjqƮwɶ.7889:9;_<=>]@ΰϪjpTӵoͪR~ϥΤjqƮwɶ. Ъ`N, pGzN "cursor_space_for_time" ѼƳ] "TRUE", z@ΰϵLkPɮeǩҦ}ҪЮ, ]|oͭR~.wR SQL ԭzyϥΤjqƮwɶ.nR SQL ԭzyϥΤjqƮwɶ.䤣ϥΤjqƮwɶ SQL ԭzy. PL/SQL ϥΤjqƮwɶ.sĶ PL/SQL ϥΤjqƮwɶ. JAVA ϥΤjqƮwɶ.BzΩ CPU ɶjƮwɶ.?8@cABCD EBFﵥݭxwİϪŶϥΤjqƮwɶ.d V$SQL_SHARED_CURSOR Ҥ۲ŪDn].]@ΰϪjpTӵoͪR~ϥΤjqƮwɶ.լd DDL @~A.լdε{޿, HhR~.լdε{޿, XϥγsܼƨӨNrik.լdε{޿, Ng`ϥΪЫO}. `N, ЬOѴIsPq@~_su.LkqD@~tΨo CPU Cέp. o ADDM Lkwoo{vT.G2HIJKMLMҤ۲, ]@Ψ㦳ۦPr SQL ԭzy. oLwRϥΤjqƮwɶ.yҤ۲Ū@]Oq@~ NLS ]w, SQLlܳ]w, M̨ΤƳBz{Ѽ.DDL @~yеL. oLwRϥΤjqƮwɶ.]@ΰϤjpTӳywRϥΤjqƮwɶ.oͭR~wR SQL ԭzyϥΤjqƮwɶ.]ϥΤry@ SQL ԭzy. oLwRϥΤjqƮwɶ.]Ҥ۲ųywRϥΤjqƮwɶ.N8OgPQR SDTUլdyjq "%s" (bҲ "%s" ) ].լdyjq "%s" (bA "%s" ) ].]@ΰϪгv¦ӳywRϥΤjqƮwɶ.oͭR~wR SQL ԭzyϥΤjqƮwɶ.]ϥΤrHδеLĤƳywRϥΤjqƮwɶ.լdε{޿AѴֳsuM_suIsik. Ҧp, ziHbhϥγsuϺn.P@ΰϦvϥΤjqƮwɶ.P@ΰϦvϥΤjqƮwɶ.V2WXYZV[\ȮɪŶ "%s" (]t %s "%s.%s" B ID %s) Ob޲z. Oracle ijѨM׬Oϥ CREATE TEMPORARY TABLESPACE ԭzyӫإ߼ȮɪŶ.OuLvϥΤjqƮwɶ.OuLvϥΤjqƮwɶ. "%s" ( ID %s) OcuXvݪeXӭꤧ@.uLvOƮwꥼϥΤjqƮwɶ.uLvOƮwϥΤjqƮwɶ.ˬd SQL_ID "%s" SQL ԭzy, HXi઺įik.],^_`aRb{bF SYSTEM ŶH~ҦŶ޲zŶϥ ORACLE ij۰ʰϬqŶ޲zѨM."%s" ݨϥ %s\\% Ʈwɶ.ID %s wݨϥΤjqƮwɶ.լdϥ "DBMS_LOCK" M˵{ε{޿. Ҽ{ε{Osowɶ, Ϊ̦Ҽ{ϥΧΪwI.լdPѤj DDL M DML ε{޿.o{ "%s" B㦳æŪgʪ@ΰ϶. ϶OѰ϶s %s (bɮ׽s %s ) ѧO.c2defg6hwio{㦳æŪg@~@θư϶. ϶ݩϬq "%s.%s" BO϶ %s (bɮ %s ).iHǥѼW[Ϭq "%s.%s" iβMƥبӹFȮɪѨM.iHǥѼW[Ϭq "%s.%s" iβMsռƥبӹFȮɪѨM.%s "%s.%s" ( ID %s) oYŪgv.Ҽ{W[ %s "%s.%s" ( ID %s) INITRANS , Ӥsإ.Ҽ{W[ %s "%s.%s" ( ID %s) PCTFREE .Ҽ{ϥθ INITRANS Ȩӭsإ %s "%s.%s" ( ID %s).j8kRlmnoVpqլd I/O ltΪgJį.լdε{޿AѨϥΪ|Jh INSERT @~Nki.DiO]bŶϥΧ@γƥҦҳy.Ҽ{W[ "open_cursors" Ѽƭ, HW[q@~}ҴФWƥ.Ҽ{W[ "session_cached_cursors" Ѽƭ, HW[q@~Ч֨jp.լd PL/SQL sĶA. PL/SQL sĶ|]̪ۨ DLL Ӳ.լdyҲ "%s" OjqƮwɶ].լdyA "%s" OjqƮwɶ].r2situvw2x|hvȮɪŶŶBzϥΤjqƮwɶ.Ҽ{W[ȮɪŶ "%s" jp.Ҽ{W[jۤBzvȮɪŶjp.լdy "%s" ݪ] - P1 ("%s") "%s".լdy "%s" ݪ] - P1 ("%s") "%s" H P2 ("%s") "%s".լdy "%s" ݪ] - P1,P2,P3 ("%s"), ȤO "%s", "%s" M "%s".Lh (sܼƤwg) sIsƥبϥΤjqƮwɶ.yz{ڽլdε{޿ӭCoXsIsƥ. Ҽ{έȩIs, @s, ѷөΰ}CsӨNƪs. `N, Yϫѷܧsܳsyz, ҦpsפWθ, |yLsIs.bD@~tΰ쭫jO.BzϥΪ`OWLDiιO. ЦҼ{sWhOD, Ϊ̧A INIT.ORA Ѽ, Ҧp "sga_target" , "shared_pool_size", "db_cache_size" M "pga_aggregate_target", ӴְBzϥΪO.|}~zD@~tΦj, OLkXSwڥ]. нլdbDW, ϥΤjqO, ݩ󦹰BzBz@~. P, ЦҼ{sWhOD.Ҽ{]w "sga_target" ѼƨӱҥΡu۰ʦ@ΰO޲zv, HBzҨϥΪ SGA jp.Ҽ{]w "pga_aggregate_target" ѼƨӱҥΡu۰ PGA O޲zv, HBzҨϥΪ PGA jp.&e`@ϥΪ PGA OWLɬ %s%% w "pga_aggregate_target" . ЦҼ{W[zثe "pga_aggregate_target". `N, "pga_aggregate_target" M SGA jp`MpDiιO.լd "%s" Bz@~ϥ %s%% D CPU ].Bzϥ %s M SGA OH %s M PGA O, ӥDiιO鬰 %s M.P, ЦҼ{ϥΡuOracle Ʈw귽޲z{vӳ]wPΤsդu@tu.SQL_ID "%s" SQL ԭzyw %s , åBCBz %s ӸƦC.8{FxSQL_ID "%s" SQL ԭzyw %s , ӥBgɶ %s .Ω PL/SQL 檺ɶ %s .Ω Java 檺ɶ %s .CΩuOvݨƥ󪺥ɶ %s .CϥΪ CPU %s .A "%s" MҲ "%s" y %s% ƦCwv.CΩϥΪ I/O ݨƥ󪺥ɶ %s .o{Ʈwq@~b Oracle Resource Manager @Τq@~.,%}ӵo{q@~bݧ@Τq@~. ЦҼ{W[o Oracle Resource Manager Τsժ@Τq@~.uq@~ CPUvϥΥ Oracle Resource Manager . ЦҼ{׭qbR@Τ귽W.Ϊ, ziHNѼ "cursor_sharing" ] "force".R SQL ԭzyϥΤjq CPU. аѦҦu@RLo{, HAѶi@BԲӸT.٭ I/O O`Ʈw I/O Dn (%s\\%).Ҽ{NѼ "undo_retention" ȭ %s .,$y"undo_retention" ȬO %s , ӳ̪d߶ȫ %s . B~Odyn I/O.Cε{ͪjpi֡uxwİϪŶvƥ󪺵ݮɶ.RѼ "%s" Ȭ "%s".zLNѼ "shared_pool_size" ȳ] %s M ӼW[@ΰϤjp. I/O ϥΪAέp: %s 㪫󱽴y, %s Ū, %s gJM %s Ū.ǥѱNѼ "sga_target" ȼW[ %s M ӼW[ SGA ؼФjp.2:`վ SQL_ID "%s" PL/SQL ϶. аѦ Oracle "PL/SQL User\\'s Guide and Reference" "Tuning PL/SQL Applications" `.S@ SQL θƮwԭzyOyjq I/O ].o{yjqϥΪ I/O ݪӧOƮwϬq.o{yjq I/O ӧO SQL ԭzy.o{yjq I/O ӧOƮwϬq.լdP %s "%s.%s" ( ID %s) I/O ε{޿.ǥѱN "db_%sk_cache_size" Ѽƪȳ] %s M, ӼW[Dw]jp %s K ϶wİϧ֨jp.2CW[Dw]wİϧ֨jp, |qw]wİϧ֨oO. ]w "sga_target" 󪺫ijʧ@OjTW[w]wİϧ֨jp.LkE_٭ I/O D, ]wN۰٭޲z.@ΰϤjpwܧ, ]LkP_й@ΰϥĪvT.AWR ַӤ, ]LkP_й@ΰϥĪvT.AWR ַӤ, ]LkP_еLҥHΤrΪkwRvT.AWR ַӤ, ]LkE_ I/O eqD.wİϧ֨jpwܧ, ] ADDM LkP_wİϧ֨O_Lp.8mM~AWR ַӤ, ] ADDM LkP_wİϧ֨O_Lp.AWR ַӤ, ]LkP_ MTTR ]wˬdIʪvT.AWR ַӤ, ]LkP_dߩMŶ DLL ˬdIʪvT.AWR ַӤ, ]LkP_٭ I/O ʪvT.AWR ַӤ, ]LkP_ RMAN I/O ʪvT.RMAN I/O ʹ I/O ltΪBzOSjvT.RMAN I/O ʹ I/O ltΪBzOjvT.Ҽ{w RMAN , ΦbϥΪ̬ʸWcɤ~Ʃw RMAN u@.2:j֦Ҽ{nb RMAN u@ϥYﶵ. Ϊ, Ҽ{w RMAN , ΦbϥΪ̬ʸWcɤ~Ʃw RMAN u@.SGA jpA.SGA jpA, yB~ I/O εwR."sga_target" ȦbRoܧ, ]LkP_̨Τ SGA jp.AWR ַӤ, ]LkP_̨Τ SGA jp.NѼ "sga_target" ] %s M ӼW[ SGA jp.SGA jpA, yB~ I/O εwR. ~, Dw]jp϶wİϧ֨Lp, yjqB~Ū I/O.2o EAWR ַӤ, ]LkP_RMI_@~ˬdIʪvT.yϤjpA, yB~ I/O.yϤjpA.AWR ַӤ, ]LkP_̨ΤƦyϤjp.NѼ "streams_pool_size" ] %s M ӼW[yϪjp.yϤjpwgsվ, ]LkP_̨ΤƦyϤjp.լdyvBzqݰBz "%s" 줧϶]. Dq`PɶݻݰBz "gcs log flush sync" ƥ.&.[Xư϶, "log file sync" ƥOyƮw "gc buffer busy release" ].ݦBz "log file sync" ƥ|yݰBz֨v.biR, ɪ I/O ǿq %s Ū/H %s gJ/. @϶Ū^ɶ %s @.ɮפ@϶Ū^ɶ %s @.o{㦳 PLAN_HASH_VALUE %s SQL ԭzyϥΤr. Ьd V$SQL, o SQL ԭzyd.&ΰlܳyε{޿褤ƦCv]. ϥΫwj SQL ѧOƮw. լdPoǪ DML ε{޿.Ҽ{b޲zŶϥ ORACLE ij۰ʰϬqŶ޲zѨM.S@ SQL ԭzyOyjq椬BzT].Ʈw϶椬BzŪPgJvϥΦBzjqƮwɶ. O, SyvDn@ΰ϶Ϊ.DзǤjp %s K ϶wİϧ֨jp, yjqLŪ I/O. D|VyXYZNѼ "sga_target" ȼW[ %s M, OѦ@ΰϨϥ.yƤJC@~Q_, ]yϪO餣BϥΤjqƮwɶ.yƤJC@~Q_, ]yϪO餣.ܤֵo{ %s Ӧ PLAN_HASH_VALUE %s SQL ԭzyϥΤr. SQL_ID "%s" SQL ԭzyY@ӨҤl.ܤ֦@ӥ檺ԭzy涵.OuCvϥΤjqƮwɶ.OuCvϥΤjqƮwɶ.u@ '%s' ADDM iRAWR ַӽdq %s %s. [P\a]r^z_`abcd6e`fԮɶ}l %sɶ %sRؼиƮw '%s', Ʈw ID %s.Ʈw %s.RƮw %s. ADDM ɪƮw %s.ADDM ͪҦijAΩ ADDM Ʈw %s.ADDM wgҦBziLR.ADDM wgs %s BziLR.ADDM wgBz %s (s %s, ˸b %s) iLR.nDҦBziR, O ADDM uRY@հBz. gPhij#k1lJmhnopqrnDҦBziR, O ADDM uRBz %s (s %s, ˸b %s).nDY@հBziR, O ADDM uRBz %s (s %s, ˸b %s).pݭnDBzԲӸT, аѾ\uLTv@`.R`@Ʈwɶ %s .@Τq@~ƥج %s.ADDM wR %s ӭnDBz (`@ %s ).Siio{.Ʈw ID %s.ADDM wgRLBzs %s.LTwgRLBz:stuvwxyz{|}~.2:P}wgnDRBz:sW٥DW٧@Τq@~ʦʤBzQư]RҰʩַӿ|ο~|DnέpƧ䤣Bz AWR ַĵiLT]tDw]Ȫu@ѼƼvT %s ӧ@Τq@~, `ʪ %s\\%.Y즹o{ؼvTBz:vTʤADDM u@Wˬd ADDM RXvTBz, HXij.ε{RƮwպADպA IdzSQL վϬqվnܧ󤣩ijSij.iĥΪij]tHU:ij˼ƥعwf %s ӧ@Τq@~, `ʪ %s\\%.ʧ@zSQL_ID %s B PLAN_HASH %s SQL ԭzy.SQL_ID %s SQL ԭzy.ID %s Ʈw.s %s, ɮ׽s %s B϶s %s Ʈw϶.ƮwɮתŶ %s (ID %s).Ʈw %s.ƮwƤJC %s. (,0>MzƮwԭnD %s (ID1 %s).ƮwԭnD %s (ID1 %s, ID2 %s). %s .ATTR1 O %s.ATTR2 O %s.ATTR3 O %s.ATTR4 O %s.ij %s:M %s:o{غKnyzijo{ةMijɭPGg:vT %s ӧ@Τq@~, `ʪ %s\\%.ivTO:ˬdBz ADDMwϥΪѼӰ檺R ADDM qŪ@Ӹư϶w^ɶ (@) Vw,MnR֭pƮwɶ (@)RƮw IDR̫@ӧַ IDRBzsRĤ@ӧַ IDz SQL վ㶰 SQL SQL zP@ӱԭzyhӬp (plan_hash_value) ɾAΪpz SQL Ĥ@ ORDER BY ly SQL ĤG ORDER BY ly SQL ĤT ORDER BY lygLzñƦCŤ SQL վ㶰 SQL ƥصŭpq`Mʤnվ SQL ԭzyϥΪ̦W JlFhR}lɶثeɶƤRɶثeɶƥѦ۰ʱҰʤij{Ҳͪߤ@u@ IDu@pGO۰ʫإ߫h TRUE, pGOʫإ߫h FALSEpGGӥ]Aijo{ثh TRUE, _h FALSET{ SQL վ㶰վ㵲G᪺ԭzyƥSQL վ㶰C@ԭzyɶ~վu@, z SQL վ㶰 SQL SQL zwu@檺w]ʧ@.վ SQL ԭzyįpG SQL ]wӥѤu@ӫإ, h TRUE, _h FALSE P+@`{֦pGϥΪ̫إߪ SQL ]wӨN, h TRUE, _h FALSEtΤ@ɥiHإߪ SQL ]wɼƥؤWi\إߪt SQL ]wɼƥؤW SQL ԭzy沣 SQL ԭzypwثeu@ӧO檺ɶ ()R SQL ԭzyįSQL ԭzyu@tvT{ɭܧ SQL ԭzyvTWwnΩįέpƪܦ.Ĥ@ӭnRu@WٲĤGӭnRu@W&aqpG SQL ԭzyӴհӴqnB, h YES; _h NO.ܫij{O_ϥ SQL ԭzy^sĶҦpGӦbӥɶհ SQL ԭzyHqįq, h FULL; Y۰ʿܪpɶ, h AUTO; իh NOTRUE Nons, ~iiհ; FALSE N|b|saw˥y NULL sݩʷ|NѼ OPTIMIZER_FEATURES_ENABLE ]ԭzyw], ӤO %s. pNiϥγ̷s̨ΤƳBz{\.&Uݩʷ|NѼ OPTIMIZER_FEATURES_ENABLE ]w], ]ܤ֦@ӳ̨ΤƳBz{̰ۨѼƬO]Dw]. pNiϥγ̷s̨ΤƳBz{\.ݩʷ|NѼ OPTIMIZER_FEATURES_ENABLE ]ԭzyw]. pNiϥγ̷s̨ΤƳBz{\.ݩʷ|̨ΤƳBz{w惡ԭzyշP쪺Np.ݩʷ|N̨ΤƳBz{Ҧq %s ܧ %s. ̨ΤƳBz{ҦwbˬdԭzyέpƤܧ.ݩʱN̨ΤƳBz{ҦOdbdߪϥΪ̫wܤ. Js(Xݩʷ|ҥΥH¦̨ΤƳBz{.ݩʷ|վ̨ΤƳBz{w.ݩʷ|ҥΡunƦCv̨ΤƳBz{Ҧ.ݩʷ|γ̨ΤƳBz{.R "%s"."%s".R "%s"."%s" Ψ.R "%s"."%s". "%s"."%s" ̨ΤƳBz{έpƤwgL. "%s"."%s" Ψު̨ΤƳBz{έpƤwgL. "%s"."%s" ̨ΤƳBz{έpƤwgL.̨ΤƳBz{ݭn檺̷sέp, ~AXp.,qH̨ΤƳBz{ݭnΨު̷sέp, ~AXp.̨ΤƳBz{ݭnު̷sέp, ~AXp.]|檺έp, ҥHݩʴѰ򥻪έpƵ̨ΤƳBz{.]檺έpƹL, ҥHݩʴѰ򥻪έpƵ̨ΤƳBz{.|έp, ]ݩʴѰ¦έpƵ̨ΤƳBz{.]檺έpƹL, ҥHݩʴѰ򥻸έpƵ̨ΤƳBz{. 2 y    0޿|޲έp, ]ݩʴѰ¦޲έpƵ̨ΤƳBz{.ު޲έpƤwgL, ]ݩʴѰ¦޲έpƵ̨ΤƳBz{.ЦҼ{ij SQL ]w.Ҽ{檺̨ΤƳBz{έp.Ҽ{ު̨ΤƳBz{έp.ԭzyxsj "%s", bվBz@~ɳQ. ЦҼ{ϥ dbms_spm.migrate_stored_outline API Nxsj SQL p.ԭzy SQL ]w "%s" wsb, wbվBz@~L. >Y즹ԭzyΰp.Ҽ{Ψު̨ΤƳBz{έp.䴩 SQL ԭzy.ԭzyTw SQL p "%s", biվɤwH.tΤW@Ӧ۰ʫإߪ %s.tΤW@Ӥʫإߪ %s.wzL %s pMlpi, äOqέp. pGLpɶu, iNu|p@.ԭzy̪wվL, ]L. аѾ\u@ "%s", Aѳ̷sվ㵲G.%s wbtΤW.2g IԭzywѨϥΪ̶¦Wz "%s" ХܥX, ]L.ҪįqӧC, ]۰ʫإ %s.Lk %s įq, ]۰ʫإ.wΦ۰ʫإ, ]۰ʫإ %s. бNu@Ѽ ACCEPT_SQL_PROFILES ] TRUE, HҥΦ۰ʫإ.۰ʫإ %s, ] SQL t@өTw SQL pǩιwsj.̨ΤƳBz{έpƹLɩο|, ]۰ʫإ SQL ]w. ХѨM򥻳̨ΤƳBz{έpƪD, Aإ SQL ]w.wF SQL ]wɭ, ]۰ʫإ SQL ]w. 2!"#'$R%}&֤wΨNϥΪ SQL ]w, ]۰ʫإ SQL ]w. бNu@Ѽ REPLACE_USER_SQL_PROFILES ] TRUE, HҥΨNϥΪ SQL ]w.wδհ, ]۰ʫإ %s. бNu@Ѽ TEST_EXECUTE ] FULL AUTO, Hҥδհ.۰ʫإ %s.oͿ~, LkzLհ %s įq.@~O, LkzLհ %s įq.dߤ䴩հ, Lk %s įq.DML DDL 䴩հ, Lk %s įq.'8(g)*+,-Z.xȦԭzy䴩հ, Lk %s įq.LkzLհ %s įq.w۰ʬԭzyإ %s "%s".w۰ʬԭzyإ SQL ]w "%s" M SQL p "%s".wFij, u@Rեؼ SQL.ЦҼ{ij SQL ]w. N|@֫إ߻P㦳 SQL ]wɤp SQL p.ЦҼ{ij SQL p.u@wפ, AuY~v, OwboͿ~e۰ʹ SQL]w "%s"./,0123p4ЦҼ{ij SQL ]w. N|P㦳 SQL ]wɤp SQL pǤ@֧sp.ЦҼ{ij SQL ץ{.ЦҼ{ij SQL ץ{. N|@֫إ߻P㦳 SQL ץ{p SQL p.ЦҼ{ij SQL ץ{. N|P㦳 SQL ץ{p SQL pǤ@֧sp. SQL ԭzyܤֿ|@ӭns. ij{RTʥѩҦѪnsȦөw.۰ʫإ %s, ]o|jTvT I/O ɶ.526Q7x89:;wԭzyӷdzƽwİϧ֨.ܪέpƬOU %s 檺.ܪέpƨӦ۲ĤG.ݩʷ|ҥΥ.즹ԭzyΥp.ϥ DOP %s 榹dߥiﵽ SQL ]wɭp^ɶ %s%%. L, ҥΥ]|W[@Ǧ. wN|W[ %s%% ԭzy귽ζq, ytζǿqC. ~, ]oǸ귽ϥήɶܵu, pGSweq, æԭzy^ɶi|ܪ.ЦҼ{ij SQL ]w, HK榹ԭzy.< =i>[?즹ԭzy %s ӧΰpe. пܤUC䤤@ӭn檺 SQL ]w.ϥ DOP %s 榹dߥiﵽlp^ɶ %s%%. L, ҥΥ]|W[@Ǧ. wN|W[ %s%% ԭzy귽ζq, ytζǿqC. ~, ]oǸ귽ϥήɶܵu, pGSweq, æԭzy^ɶi|ܪ.ԭzyNpOzLjMtΪYɩMvįƧ쪺.gɶ̨Ϊpإߤ@ӭp, Yi Oracle ̨ΤƳBz{į̮tp.@ANBЦҼ{gɶ̨Ϊpإߤ@ SQL p.ھڨC@檺gɶӬ,ulpvį̨. L, pGzDulpvnNp, ziHإߤ@ SQL p. o Oracle ̨ΤƳBz{HN|uܸӴNp.䤣ulpvvO, ]uSQL վij{vLkP_oǰpO_uulpv. L, pGzDulpvnNp, ziHإߤ@ SQL p. o Oracle ̨ΤƳBz{HN|uܸӴNp. C,D5EFFxGH\ο|.iwQR.ھڨC@檺gɶӬ,ulpvį̨.Lks ID %s p, ]| %s. ], Lkإ SQL pǨӫ Oracle ̨ΤƳBz{Hܦp.Lks ID %s p, ]| %s. ], Lkإ SQL pǨӫ Oracle ̨ΤƳBz{Hܦp.LkbثeҤs ID %s p. ], Lkإ SQL pǨӫ Oracle ̨ΤƳBz{Hܦp.I,JeKLMNLkbثeҤs͡ulpvH~ҦLp.Lksͦp, ]| %s.Lksͦp, ]| %s.LkbثeҤsͦp.pG\ƶةΫOҰߤ@, ЦҼ{ϥ "UNION ALL" N "UNION"."UNION" ݭnưƪƦC, ]ӮɨåB|j@~. "UNION ALL" ]\ƪةΫOҰߤ@, ]OΪNﶵ .OPS{ĦҼ{ϥ "NOT EXISTS" ӨN "NOT IN", ǥѷsW "NOT NULL" "IS NOT NULL" zӽTO "NOT IN" BlݩҨϥΪŧi "NOT NULL"."FILTER" @~|dߤCӸƦCld, ]|۷Ӯ. Ѱldߪ_cNijTְɶ, ] "FILTER" @~|ഫX. Ъ`N, "NOT IN" M "NOT EXISTS" i|ͤP "NULL" ȵG.Ҽ{N_suε[ۦԭzy, Ϊ̷sWѦұԭzyX.T,UqVYZ~[кɥiקKåd୼n, ]OӮɪ@~, ӥBi|ͤjq.Ҽ{ "ORDERED" ."ORDERED" ܥi|j̨ΤƳBz{Ͳåd୼n. кɥiקKåd୼n, ]OӮɪ@~, ӥBi|ͤjq.̨ΤƳBz{LkX֤t "ORDER BY" ly[, Dԭzy "DELETE" "UPDATE", ӥBd߬Oԭzy̤Whd.̨ΤƳBz{LkX֤t "ROWNUM" 檺[.̨ΤƳBz{LkX֤tXBl[.\8]e^_` a6bc̨ΤƳBz{LkX֤tƨƪ[.̨ΤƳBz{LkX֤t "SPREADSHEET" ly[.̨ΤƳBz{LkX֤t_E`ƪ[.̨ΤƳBz{LkX֤tS "GROUP BY" lyE`ƪ[.̨ΤƳBz{LkX֤tsըƪ[.̨ΤƳBz{LkX֤t "GROUP BY" ly[W "ROLLUP", "CUBE" "GROUPING SETS" ﶵ[.̨ΤƳBz{LkX֤t "START WITH" ly[.̨ΤƳBz{LkX֤t NO_MERGE ܪ[.d,g_hijk̨ΤƳBz{LkX֤t "CURSOR" ܦ[.̨ΤƳBz{LkX֤t "WITH" ly[.̨ΤƳBz{LkN[Pt_ (P~X) zX.̨ΤƳBz{LkXְp ID %s [.Xֵ[iH͸Ϊp, ]Yuɶ. pGN OPTIMIZER_FEATURES_ENABLE ѼƳ]C 9.0.1 , ̨ΤƳBz{NLkXֽ[.pG[dߥ]t "START WITH" ly, ̨ΤƳBz{NLkXֽ[.l&myno"pxΦpG[d߬ "SELECT FOR UPDATE", ̨ΤƳBz{NLkXֽ[.~Xk誺[ub]t㦳@² "WHERE" ly@ɤ~QX.pG[dߥ]t "ROWNUM" ѷ, ̨ΤƳBz{NLkXֽ[.pG[dߥ]t "GROUP BY CUBE" ly, ̨ΤƳBz{NLkXֽ[.pG[dߥ]t "GROUPING SETS" ly, ̨ΤƳBz{NLkXֽ[.q2rstuRvwpG[dߪ "SELECT" M]t "SEQUENCE" , ̨ΤƳBz{NLkXֽ[.̨ΤƳBz{LkX֥]tsե~X[.̨ΤƳBz{LkX֯Aθsե~X[.Ҽ{ϥ "MERGE" ܩαNѼ OPTIMIZER_FEATURES_ENABLE ]̤֬ 9.0.1, HҥΦXֽ[.bp ID %s o{Ӯɪåd୼n@~.̨ΤƳBz{LkѰp ID %s _ld.̨ΤƳBz{LkXְp ID %s [.x&ySz{|>æbp ID %s o{Ӯɪ "UNION" @~.ԭzypiHǥѫإߤ@Φhӯިӧi.Ҽ{usij{vӧin]p, Ϋإ߫ij.pz %s (b ID %s) ]twssޤ "%s" ܦ. ܦ̨ΤƳBz{Lk "%s"."%s" .pz %s (b ID %s) ]twssޤ "%s" ܦ. ܦ̨ΤƳBz{LkIJvϥΪ "%s"."%s" .} ~Jpz %s (b ID %s) ]twssޤ "%s" tഫ. tഫ̨ΤƳBz{Lk "%s"."%s" .pz %s (b ID %s) ]twssޤ "%s" tഫ. tഫ̨ΤƳBz{LkIJvϥΪ "%s"."%s" .pGzO۵Τwssޤ榳ܦtഫ, ̨ΤƳBz{NLkϥί.NzgJ۵iQίުuI. Ϊ, bܦإߨƦ.?MNzgJ۵iQίުuI.pz %s (b ID %s) Owssޤ "%s" ۵. ۵̨ΤƳBz{Lk "%s"."%s" .pz %s (b ID %s) Owssޤ "%s" ۵. ۵̨ΤƳBz{LkIJvϥΪ "%s"."%s" .=إ߫ijޥijTiԭzyp. M, ̦nOϥΥNʪ SQL u@t (۹@ԭzy) Ӱusij{v. oNiosxޫij (N޺@MLŶϥίǤJҶq).ijԭzyϥίީM SQL ]w. إ SQL ]wɤ, ̨ΤƳBz{~ϥέpPij.JpPij޷@ SQL p, ̨ΤƳBz{~ϥΨǯ. ЦҼ{usij{vӧﵽn]p, άOإ߫ij. pGܫإ߫ij, ЦҼ{N "%s"."%s" R, ]OijުemX.wgi঳Uަsb, OثeаOLkϥ. ЦҼ{sإ߯, Hѳ̨ΤƳBz{ϥ.ЦҼ{usij{vӧﵽn]p, άOإ߫ij. Ъ`N, tΤwghӫijުemX. pGܫإ߫ij, ЦҼ{Nǥj󭭨󪺦hlemXާR.wgi SQL į. J`D\wg^k SQL į. SQL ԭzy|Rɥnp@. SQL ԭzyǦ^ 0 ӸƦC.SQL pcwgܧ.'%s' 椤 SQL pcPxsbuSQL վ㶰vpP.'%s' 椤 SQL pcPxsbuSQL վ㶰vpۦ. '%s' ɵoͿ~: %s '%s' ҶǦ^ƦCƥػP '%s' ҶǦ^ƦCƥؤP.%sBz SQL ԭzyɵoͿ~, yu@楢. u@Ѥ, wQA~u@.ϥΪ\: %s8c{ qᵦ %s p]t %s Hέp %swg\ %s, ] %s %s , ~X %s, ~T %s]t %s NpƦCƥج %s, `M笰 %s, ɶ %s, HΧt %s ӽwİϨoإ]t %s ijpƦCƥج %s, `M笰 %s, ɶ %s, HΧt %s ӽwİϨo%s CR Diff'ing: \ %s [¦ %s, ؼ %s]%s CR Diff'ing: ¦غc %s OؼФ %s [Wh: %s, A: %s] > !" }򵦲 %s (]tp () %s) p]t %s Mp %sLĪDȵLĪwƥ ID ȥ]t %s lpƦCƥج %s, `M笰 %s, ɶ %s, HΧt %s ӽwİϨo%s P1: %s P2: %suַӤ¿~v: SQL ID %s, ַ SCN %s, ̪ SCN %s, ٭OŶ %s, ثe٭Od %s.uַӤ¿~v: SQL ID %s, ַ SCN %s, ̪ SCN %s, ˦^Ϭq %s.а٭ij{.ˬd˦^ϬqϥΪA.,Jbi~򪺶q@~ %s (q@~ id %s) @~wgȰ, ]Ŷ %s oͿ~. ~T %s.bi~򪺶q@~ %s (q@~ id %s) @~wgȰ, ]˦^Ϭq %s oͿ~. ~T %s.bi~򪺶q@~ %s (q@~ id %s) @~wgȰ, ] %s oͿ~. ~T %s.bi~򪺶q@~ %s (q@~ id %s) @~wgȰ, ]ϥΪ̰tBoͿ~. ~T %s.ˬd[ dba_resumable.NlưѼ undo_retention ] %d. Pn5bN٭Ŷjp]w %d MB̪d߫ɶ٭Od]w.oַͧӤª~, dߥi|.u٭ŶvO.]٭Ŷ, ҥH@~i|.N٭Od]̪d߫ɶ, HקKַӤª~.ھ٭첣ͲvM٭Od]w٭Ŷjp.tΥH٭޲z, Lku٭vij{.tάO۰ʽվ٭Od.AWR Ƥ.S target_object.֡uַӤ¡v~. DY3HcoקK٭ŶO.ij٭ŶjpOھڨtΤ٭첣ͲvM̪d߫ɶ¦.ij٭OdOھڨtΤ̪d߫ɶөw.ij٭OdOھ٭첣ͲvMثe٭Ŷjpӱo̥i٭Od.٭ŶSD.٭ŶSD.ﵽ٭ŶϥΪA.٭OdӰN٭Od]j̥i઺Od, ٭ŶN|O.ij٭ŶjpOھڨtΤ٭첣ͲvM٭Od¦. Pm N i {   BzSuW٭Ŷ.jp %d MB uW٭ŶBz@ӽuW٭Ŷ.Bz@ӽuW٭Ŷ.pGSuW٭Ŷ, ܦh@~i|.ij٭ŶjpOھڨtΤ٭첣Ͳv, ٭Od, Hγ̪d߫ɶ¦.Ŷ [%s] wgϥ [%s]sWŶܪŶqG "%s" Ob %sqG "%s" Ob %s, ݩɮ "%s"qG "%s" Ob %s, ݩA "%s"qG "%s" Ob %s, ݩƥO "%s" 8 a   ADDM ioztΪLįR.q@~ %s j %s Lq@~wsqG "%s" (ݩBz "%s") {ɭ˵ DBA_THRESHOLDS [ҵGwsuŶϥΡvqG{ɭȪŶ [%s] u [%s] iΪŶаեε{, èϥΫij WRC qݺ (bBƥneq) ƥحs}ls. WRC qݺ %s (b %s W@Bz@~ %s ), @ IO ^ɶwFݭn`N (%s @) & =Ӧhsqݺݳsu (%s\\%) Pɨϥ WRC qݺ %s (b %s W@Bz@~ %s ) CPUӦhsqݺݳsu (%s\\%) b WRC qݺ %s (b %s W@Bz@~ %s ) iæ IO @~Ʈw^ҦƮwsҦ%s (%s Ӧ줸) wgϥ %s%%, ٦ %s iΪ줸.,tR<=>X_ϰŶﶵ: 1. Ҽ{ܧ RMAN %s. pGzثeϥΡuƫOv, iHҼ{ܧ RMAN %s. 2. ϥ RMAN %s RO, Nɮ׳ƥܺϱa. 3. W[ϺЪŶHδ db_recovery_file_dest_size Ѽƪjp. 4. ϥ RMAN %s RORݭnɮ. pGeϥΧ@~tΩROӧRɮ, hШϥ RMAN %s RO.pGإߪO %s Ӧ줸, hOwŶϥΪA.pGإߪެO %s Ӧ줸, hOwŶϥΪA.ͶժX.T, Lkij.󪺥iΪŶ֩ 1%, Y. ?D@cABCD#ENFpGHҰY, w` %s Ӧ줸.󦳳iΪŶLkY, ] %s.󤤪iΪŶp̫@XR϶jp.tmŶ:%s: wϥΪŶ:%s: i^Ŷ:%s:ҥΪ %s.%s ƦCʥ\ðYp, wi` %s Ӧ줸. b %s 歫, wi` %s Ӧ줸.%s ʤ쵲ƦCiǥѭղ.]tiǥѭղ쵲ƦC.󤤪iΪŶp 10MB.Y %s.%s, w` %s Ӧ줸.I8JiKLM!NjY %s.%s ΰ %s, wi` %s Ӧ줸.Y %s.%s lΰ %s, wi` %s Ӧ줸.I/O nD/:%s, I/O /:%s, Ϭqjp (MB):%s, I/O /nD:%s.N %s.%s xs, wi %s @ I/O ݮɶN %s.%s ΰ %s xs, wi %s @ I/O ݮɶ.N %s.%s lΰ %s O, wi %s @ I/O ݮɶ.ݰʧ@ --uɦVv|iBz.bRBz. >Np4m礣ݰʧ@ݭnɭsҰ, ӤO۰ʭsҰʰBz %s b`I %s `@~, ɶ %s; ]NX: %sBz %s b`I %s @~, ɶ %s; ]NX: %sƦXA %s%s `@~, ɶ %s; ]NX: %sƦXA %s%s @~, ɶ %s; ]NX: %sAȦbBz %s `I %s `@~, ɶ %s; ]NX: %sAȦbBz %s `I %s @~, ɶ %s; ]NX: %sAȹwsubBz %s `I %s `@~, ɶ %s; ]NX: %s2 s!"#$AzAȹwsubBz %s `I %s @~, ɶ %s; ]NX: %sƮw %s ( %s) `@~, ɶ %s; ]NX: %sƮw %s ( %s) @~, ɶ %s; ]NX: %s`I %s %s @~, ɶ %s; ]NX: %sASM Bz %s b`I %s `@~, ɶ %s; ]NX: %sASM Bz %s b`I %s @~, ɶ %s; ]NX: %sSTREAMS ^Bz@~ "%s" w, o ORA-%s ̱q dba_capture oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_capture_adm.start_capture sҰ^Bz@~.STREAMS MγBz@~ "%s" w, o ORA-%sq dba_apply oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_apply_adm.start_apply sҰʮMγBz@~. pG~O ORA-26714, ЦҼ{N 'DISABLE_ON_ERROR' MΰѼƳ] 'N', HקK]ϥΪ̿~Ӥ.STREAMS ǿBz@~ "%s" wb 16 ѫᤤ .ұq dba_queue_schedules oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_propagation_adm.start_propagation sҰʶǿBz@~.pGثe椤u@tO@oͪp, ЦҼ{W[uyvϪjp.MγBz@~ "%s" STREAMS ~C]to ORA-%s sdݿ~CH dba_apply_error e, HP_oͿ~]. ץ~, Шϥ dbms_apply_adm.execute_error dbms_apply_adm.execute_all_errors s楦.&GUCUӳBz@~o STREAMS ۰ʤ: l^Bz@~ "%s"BlyBz@~ "%s"Bƻs^Bz@~ "%s" HνƻsyBz@~ "%s"@ƻsyBz@~`B@, STREAMS ۰ʦXִN|۰ʰ. Ьd DBA_STREAMS_SPLIT_MERGE AѸԲӸT.XStream ^Bz@~ "%s" w, o ORA-%sq dba_capture oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_capture_adm.start_capture sҰ^Bz@~.XStream MγBz@~ "%s" w, o ORA-%s %q dba_apply oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_apply_adm.start_apply sҰʮMγBz@~. pG~O ORA-26714, ЦҼ{N 'DISABLE_ON_ERROR' MΰѼƳ] 'N', HקK]ϥΪ̿~Ӥ.XStream ǿBz@~ "%s" wb 16 ѫᤤq dba_queue_schedules oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_propagation_adm.start_propagation sҰʶǿBz@~.MγBz@~ "%s" XStream ~C]to ORA-%s s Edݿ~CH dba_apply_error e, HP_oͿ~]. ץ~, Шϥ dbms_apply_adm.execute_error dbms_apply_adm.execute_all_errors s楦.l^Bz@~ "%s"Bl XStream Bz@~ "%s"Bƻs^Bz@~ "%s" Hνƻs XStream Bz@~ "%s" o XStream ۰ʤΤ@ƻs Xstream Bz@~TB@, Xstream ۰ʦXִN|۰ʰ. Ьd DBA_STREAMS_SPLIT_MERGE AѸԲӸT.GoldenGate ^Bz@~ "%s" w, o ORA-%s ұq dba_capture oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_capture_adm.start_capture sҰ^Bz@~.GoldenGate MγBz@~ "%s" w, o ORA-%sq dba_apply oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_apply_adm.start_apply sҰʮMγBz@~. pG~O ORA-26714, ЦҼ{N 'DISABLE_ON_ERROR' MΰѼƳ] 'N', HקK]ϥΪ̿~Ӥ.GoldenGate ǿBz@~ "%s" wb 16 ѫᤤq dba_queue_schedules oTꪺ~T, w惡~ĨAʧ@, Mϥ dbms_propagation_adm.start_propagation sҰʶǿBz@~.MγBz@~ "%s" GoldenGate ~C]to ORA-%s sdݿ~CH dba_apply_error e, HP_oͿ~]. ץ~, Шϥ dbms_apply_adm.execute_error dbms_apply_adm.execute_all_errors s楦.89sl^Bz@~ "%s"Bl GoldenGate Bz@~ "%s"Bƻs^Bz@~ "%s" Hνƻs GoldenGate Bz@~ "%s" o GoldenGate ۰ʤΤ@ƻs GoldenGate Bz@~`B@, GoldenGate ۰ʦXִN|۰ʰ. Ьd DBA_STREAMS_SPLIT_MERGE AѸԲӸT. %s ϥθ %s Ƨ - ϶pƭp⪺YҬO %sTY %s %s %s - wYҬO %s %s ˦ʤ %sYҪƤwYҬO %s\Ws %s: %s iY - Y϶ƥجO %sSYSTEM M SYSAUX Ŷ䴩{ǪŶ %s sb %s sbΰ %s.%s %s - wYҬO %sΰ %s.%s ˦ʤ %sΰ %s.%s ϥθ %s Ƨ- wYҬO %ss %s: ΰ %s.%s iY - Y϶ƥجO %su޲zvOuε{vOuOvOuævOuպAvOuvO ":WamuLvOuƵ{vOuϥΪ I/OvOwİϦLwİϧ֨] DROP TRUNCATE yˬdI]xɤjpyˬdI] MTTR yˬdI]d߳yˬdI]Ŷ DDL yˬdIT{M˦^CPU ϥΪpDBMS_LOCK ϥΪpDBMS_PIPE ϥΪpL׭sôiΪwİϵݵwR]LijywR]rϥΪpywR]R~ywR$8@IU_ju}]@αywRWзǵI/O ǿqް϶Υ֨L֨öۤsu֨򥢰϶֨T֨h϶nDITL Java 歬XݤxɤPL/SQL sĶPL/SQL RMAN I/OƦCwݶǥΪkq@~suM_suq@~ѱƵ{@ΰϭCsɾnRŶݦyyqw  *6DLb|ȮɪŶv I/O ̨ΰϬquOvݤeX SQLƮwɶeX SQL I/O eX SQLLpwİϧ֨Lp PGALpxwİϹLp SGALp@ΰϹLpy٭ I/OSOu޲zvݨƥSOuε{vݨƥSOuOvݨƥSOuT{vݨƥSOuævݨƥSOuպAvݨƥSOuvݨƥSOuLvݨƥ %/3CYm~үSOuƵ{vݨƥSOuϥΪ I/OvݨƥO귽޲z{RCPU I/O I/OOۤsuŶæε{ݦC@~eXӥΤLuCvOSOuCvݨƥLpBzOeX SQL ԭzyuϥΪ I/OvPuOvέpeXӰϬqwİϦL - @ΰ϶wİϦL - @Ϊ2m DP@ΰϦv, bBzϥΤjqƮwɶ.wİϧ֨ꪺv, bBzϥΤjqƮwɶ.bYǰBz, iνwİϪݨϥΤjqƮwɶ. ƮwgJ (DBWR) LktXiνwİϪݨD.bYǰBz, ݭxwİϪŶϥΤjqƮwɶ.D CPU OYǰBz~V. ԦƷ|] CPU Xj.bBz, D@~tΰ쭫jO.uLvOƮw, bBzϥΤjqƮwɶ.,a5kӦbYǰBz, wİϧ֨Lp, yhXܦhŪ I/O.bBz, SGA jpA, yB~ I/O εwR.bYǰBz, yϤjpA, yB~ I/O êjyƤJC@~.bBz, PGA jpA, yȮɪŶL I/O, ϥΤjqƮwɶ.wR SQL ԭzy, bBzϥΤjqƮwɶ.bBz, Ҥ۲, ]@Ψ㦳ۦPr SQL ԭzy. oLwRϥΤjqƮwɶ.,sTƦ]@ΰϤjpTӳywR, bBzϥΤjqƮwɶ.oͭR~wR SQL ԭzy, bBzϥΤjqƮwɶ.DDL @~yеL. bBz, oLwRϥΤjqƮwɶ.]ϥΤry@ SQL ԭzy. oBzLwRϥΤjqƮwɶ.bBz, nR SQL ԭzyϥΤjqƮwɶ.RBzsM, ADDM uRBzlɨϥ2s@װBzϥΤάۤsu˸m "%s" ӥB IP }O %s, ӷO "%s".BzϥαMάۤsu˸m "%s" ӥB IP }O %s, ӷO "%s".dݰBzh ADDM u@, AѯSwBzϥΪۤsu˸m.BzϥΤάۤsu˸m.Oracle BzO (SGA M PGA) jpA.Oracle BzO (SGA M PGA) jpA, yB~ I/O M CPU ζq."memory_target" ȦbRoܧ, ]LkP_Bz̨ΰOؼ.&` # }] AWR ַӤ, ҥHLkP_Bz̨ΰOؼ.NѼ "memory_target" ]w %s M, W[tmBzO.Oracle O (SGA M PGA) jpA, yB~ I/O M CPU ζq. ~, Dw]jp϶wİϧ֨Lp, yjqB~Ū I/O.bYǰBz, Oracle BzO (SGA M PGA) jpA, yB~ I/O M CPU ζq.۰ ADDM ҥθƮwRҦ &  -|ܤֵo{ %s Ӧ FORCE_MATCHING_SIGNATURE %s M PLAN_HASH_VALUE %s SQL ԭzyϥΤr. Ьd V$SQL, o SQL ԭzyd.ܤֵo{ %s Ӧ FORCE_MATCHING_SIGNATURE %s M PLAN_HASH_VALUE %s SQL ԭzyϥΤr. SQL_ID "%s" SQL ԭzyY@ӨҤl.վiJI PL/SQL "%s" ( "%s", ID %s). аѦ PL/SQL AѨLT.վiJI PL/SQL ID %s. аѦ PL/SQL AѨLT.ϥ %s PL/SQL "%s" ( "%s", ID %s).2N0rרϥ %s PL/SQL ID %s.pGvTp %s ӧ@Τq@~, μvTpRʤ %s Ʈwɶ, hz "%s" o{.pG SQL vTp %s ӧ@Τq@~, Ψ^ɶpʸU %s , hzP SQL_ID "%s" SQL ij.zݩ֦ "%s", W٬ "%s" BlW٬ "%s" Ϭqij.zƪs %s Ϭqij.zܧѼ "%s" Ȫij.椬BzTϥΤjqƮwɶ.2Y2椬BzTϥΤjqƮwɶ.WXwOۤsuOjqϥθƮwɶDn].u֨AȳBz@~ (LMSn)vBznDtפ.ƮwCϥ %s KB ۤsuWe.u֨AȳBz@~ (LMSn)vtצbi %s @d.լdyqݰBz "%s" 줧϶v]. Dq`PɶݻݰBzuGCS xƲMPBvƥ.ݤ@ӰBzuxɦPBvƥ|yLBz֨v.,i !"<#iլdBzqݰBz "%s" 줧϶|ö몺].լdqݰBz "%s" 줧϶|ö몺].Dq`PݰBz CPU ~V, OΤ LMSn Bz@~uǦ.˸m "%s" Ω %s\\% ۤsuǿ, bRo %s ǰeα~.˸m "%s" bRo %s ǰeα~.BzCϥ %s KB ۤsuWeb֨TW. SLۤsuǿ骺T.$&%v&'(CƮwCϥ %s KB ۤsuWeb֨TW. SLۤsuǿ骺T.ۤsuWe %s\\% Ω֨T, %s\\% Ω󥭦d߰T, %s\\% ΩƮww޲z.8K ۤsuT𬰦ʸU %s .Ҽ{w RMAN θƨV, Ϊ̱ƩwbϥΪ̬ʸWcɰoǤu@.ƻPȦsɪ I/O ǿqӤpU: RMAN %s%%, ƨV %s%%, _ %s%%, ҦLʦ %s%% .),*+,-g.賡ƻPȦsɪįLt. pGLkϥάۦPkΩҦɮ, ЦҼ{bhӺϺФγoɮ.ɮ %s ӻ, @϶Ū^ɶO %s @, `@WB I/O ݬO %s .ˬdsɾBz@~ɮ I/O ǿq, TwO_AX{w.sɾ I/O ǿqbxɬOC %s, bsɩMsɳƥxɬOC %s.xɪ`@ I/O ǿqOC %s, ӥBsɾ䤤 %s%%.xɦbŪPgJ譱`@ I/O ǿqOOC %s PC %s./ PQRԭx I/O ǿqӤpU: RMAN P_ %s%%, xgJ %s%%, sɾ %s%%, y AQ %s%%, ҦLʦ %s%%.ˬd %s ԭzy (SQL_ID "%s"), Xi઺įi. ziHb ASH iɥRBѦ SQL_ID T.b %s ԭzy (SQL_ID "%s" ) uSQL վij{v. t~, ˬdԭzyHXi઺įi. ziHb ASH iɥRBѤ SQL_ID T.b %s ԭzy (SQL_ID "%s") uSQL վij{v.S TUVSQL ϥΨƮwɶ %s%% b CPU, I/O MO. ziHuSQL վij{vӧﵽoƮwɶ.SQL uϥΨƮwɶ %s%% b CPU, I/O MO. ], ݭnuSQL վij{v. аѾ\ SQL į, Aѥiia.SQL ϥΨƮwɶ %s%% b CPU, I/O MO. ziHuSQL վij{vӧﵽoƮwɶ. аѾ\U责ѪƥH ASH i, Aѥii@Bﵽį઺a.Lkb SQL ԭzyuSQL վij{v.W,XYZ/[{\ SQL ƮwɶӤpU: %s%% Ω SQL , %s%% ΩR, %s%% Ω PL/SQL , %s%% Ω Java . SQL ԭzybiRɦܤ֨ϥ %s ӤPp. %s ԭzy (SQL_ID "%s") WhIsNϥΤF %s%% Ʈwɶb %s ԭzy (SQL_ID "%s").o{ϥΤjqƮwɶ SQL ԭzy. ziHNoDZԭzy@Oﵽį઺ؼ.Lkb %s ӱԭzyuSQL վij{v.㱽y %s "%s.%s" ( ID %s) ϥ %s%% Ʈwɶb SQL ԭzy.]&^h_`a>է㱽y ID %s Ϭqϥ %s%% Ʈwɶb SQL ԭzy.%s "%s.%s" ( ID %s) I/O POݨϥ %s%% Ʈwɶb SQL ԭzy. ID %s Ϭq I/O POݨϥ %s%% Ʈwɶb SQL ԭzy.o{yjquϥΪ I/OvPuOvݪӧOƮwϬq.аѾ\ueX SQL ԭzyv, AѦbϬqϥΤjq I/O SQL ԭzy. Ҧp, %s ԭzy (SQL_ID "%s") NFϬq %s%% uϥΪ I/OvPuOv.bcd2½аѾ\ueX SQL ԭzyv, AѨϥΤjqɶ Java SQL ԭzy. Ҧp, %s ԭzy (SQL_ID "%s") bRNF %s%% Java ɶ.аѾ\ueX SQL ԭzyv, AѨϥΤjqɶb CPU SQL ԭzy. Ҧp, %s ԭzy (SQL_ID "%s") bRNF %s%% CPU ϥήɶ.аѾ\ueX SQL ԭzyv, AѨϥΤjqɶbuOvݪ SQL ԭzy. Ҧp, %s ԭzy (SQL_ID "%s") bRNF %s%% uOv.e&fghGiаѾ\ueX SQL ԭzyv, AѨϥΤjqɶb "%s" ݨƥ SQL ԭzy. Ҧp, %s ԭzy (SQL_ID "%s") boǵݤNF %s%%.Ʈwhѫij. Ьd ADDM RXvTBzӨoij.W[vTBzwİϧ֨jp. Ьd ADDM RXvTBzAѸԲӸT.ЦҼ{W[ CPU ΧhBzӴѸƮwA. Ьd ADDM RXvTBzӨoB~ij.W[vTBz@ζϤjp. Ьd ADDM RXvTBzAѸԲӸT.j klmˬd I/O ltΪgJį. ЦҼ{W[ƮwgJƥ, DPB I/O A, HΨϥΪ|J. Ьd ADDM RXvTBzAѸԲӸT.ˬdε{޿, AѨϥγsܼƴNri. Ϊ, ziHN "cursor_sharing" ѼƳ] "force".W[vTBzxwİϤjp. ˬduWxɪ I/O į. Ьd ADDM RXvTBzAѸԲӸT.W[tmvTBzO. Ьd ADDM RXvTBzAѸԲӸT.n,opq>rsˬdvTDWtm Oracle BzOMLε{. Ьd ADDM RXvTBzAѸԲӸT.W[vTBz SGA jp. Ьd ADDM RXvTBzAѸԲӸT.W[vTBzyϤjp. Ьd ADDM RXvTBzAѸԲӸT.W[vTBz PGA jp. Ьd ADDM RXvTBzAѸԲӸT.RSuwİϦLvݨƥ󪺧@ΰ϶.RSuwİϦLvݨƥ󪺧@Ϊ.t,upqrs9ID %s BǸ %s q@~ (Bzs %s) OɭPQΦijįq %s%% q@~.l{ ID %s (PL/SQL ID %s) Ӯ %s .w %s ӷdzƽwİϧ֨.%s έpƬOU %s 檺.%s έpƨӦ۲ĤG.%s έpƬO %s 檺.