# ## $"r-   mr #(-158;>BEILPSV[^bfikmqtz  047=AEGJNRUX\_bfjmqvxz{}^dhp}  $)-026:<>@AEGJMNOSV[_ciknqtx{|}~ t@DI   !#%(*,.PSTVY\_acegikmorqr  instance . (instance). SQL Tuning Advisor SQL SQL_ID "%s". (instance) %s\\% . .| , "%s" . "%s.%s" %s %s. . , . . - . . %s SQL "PLAN_HASH_VALUE" %s . SQL V$SQL.  ~ . ORACLE . . "%s" . %s "%s.%s" . "%s". , . . . T "%s" "%s.%s" "%s" DML . "%s" "%s.%s" "%s" PCTFREE. UPDATE SQL_ID "%s" .& INSERT SQL_ID "%s" " ". (instance) . , SQL . "%s" . "%s.%s" %s %s. g "%s" "%s.%s" "%s" DML . latch . INSERT SQL_ID "%s". UPDATE SQL_ID "%s" " ". wP "DBMS_PIPE.PUT" . DELETE SQL_ID "%s" " ". . DBMS_PIPE. T SELECT , . DBMS_PIPE.PUT . "" . "" .& !"<# "%s" "%s" . "" . "" . "" . " (commit)" .$&%}&',(} "" . "" . "" . "" . "" .)&*x+,+-z "" . " (commit)" . "" . "" . "" .. /0U1 %s "%s.%s" %s. SQL . "%s" "%s.%s" "%s" . SQL SQL_ID "%s" "DBMS_LOCK". SQL SQL_ID "%s" .2 34 5l "%s" "%s.%s" "%s" . "DBMS_LOCK" (instance). . .6782 "log_archive_max_processes". ITL . .9:;! (tablespace) "%s" . . COMMIT . (DBWR) "db_writer_processes".<=>5 %s M %s (redo). DML (tablespace) (redo). .? @|ABT . (HW) . ITL . .CDE . . " " COMMIT ROLLBACK .F GpHI< . (ST) . . "DBMS_LOCK" .JKLB SQL SQL_ID "%s" (HW) "%s" "%s.%s" "%s". SQL SQL_ID "%s" ITL (Interested Transaction List) "%s" "%s.%s" "%s". ORACLE , "%s".M NgOPi SQL . " " COMMIT ROLLBACK . %s (redo) %s bytes . (DBWR) .QRS . (redo). DML (tablespace) (redo), .TUV; . "log_buffer" %s M. (HW) .W&XYZu[ (ST) . ITL . INSERT SQL_ID "%s" . %s\\%. .\]^S DELETE SQL_ID "%s" . SQL. . ORDER RAC. latch ._ `ab^ "%s" . . SELECT SQL_ID "%s". ORACLE SYSTEM. .c def2 SELECT SQL_ID "%s" . SELECT SQL_ID "%s" " ". . (instance) intance.ghi@ . (instance) intance. .jk. instance %s.%s SEGMENT_ID %s instance . Oracle .lm: . / .. (LMSn). / .. ."gcs_server_processes". . , / ... . , .n oSpqL "%s" "%s.%s". SQL instance. instance. (LMSn) instance .rtG instance RAC instance., , , "%s" . "%s.%s" %s %s.uz "%s" . "%s.%s" "%s" "%s". , "%s" . %s %s.{-, , , . "%s.%s" %s %s. "/ " . / (redo) . %s K %s . PGA / (tablespace) . "pga_aggregate_target" .pH SQL / . "%s" . , . / .X / . / . PGA / (tablespace) .` , , "fast_start_io_target", "log_checkpoint_interval" "log_checkpoint_timeout" . MTTR . .i DML /. DROP TRUNCATE /. ALTER TABLESPACE /.ko "/ " . %s, "%s". , COMMIT. d SQL SQL_ID "%s" . SQL /. / . .. / (tablespace) . , , / . / /.k DML /. DROP TRUNCATE /.L ALTER TABLESPACE /. " ".3 SQL SQL_ID "%s" " " . "Segment Advisor" "%s" "%s.%s" "%s". /. Oracle . . "db_cache_size" %s M. PGA "pga_aggregate_target" %s M. Oracle PGA. "pga_aggregate_target" 0. Oracle MTTR "fast_start_mttr_target" "fast_start_io_target", "log_checkpoint_interval" "log_checkpoint_timeout".n MTTR "fast_start_mttr_target". Oracle . %s %s %s %s\\% . ADDM. rO ADDM. "%s" "%s.%s" "%s" . / "%s". .y . . , . SQL SQL_ID "%s" / ./ "%s\\%" "%s\\%" . ADDM. . SQL Tuning Advisor SQL SQL_ID "%s". . , . , ./ , (, .). . "db_file_multiblock_read_count". (instance) "%s" IP "%s". (instance) "%s" kbps .5 "%s" . (LMSn) instance "%s" . . SQL SQL_ID "%s" . . "%s%%" . "%s" "%s" %s%% SQL "SQL_ID = %s".At "%s" "%s" %s%% . "%s", "%s", "%s" "%s" %s%% . latch.  "%s" "%s" %s%% . "%s", "%s", "%s" "%s" %s%% .  ^ latch . (DBWR) "db_writer_processes". I/O .,&-./b0 "%s". "Database Reference" Oracle . SQL . SQL . SQL . PL/SQL .1 2a34x PL/SQL . JAVA . "%s". "Database Reference" Oracle . SQL . .56c7 SQL SQL_ID "%s" "%s". SQL . . . "TRUE" ."cursor_space_for_time" . cursor.8,9~:;!<b= SQL . SQL . SQL . PL/SQL . PL/SQL . JAVA .> ?@ Ai instance . . cursor V$SQL_SHARED_CURSOR. SQL .B CPDE DDL. . . cursor . cursor cursor .FG . ADDM . SQL cursor. .HIJ] NLS , SQL . cursor . . SQL .K LM=N SQL . SQL . . cursor . "%s" "%s".O PmQRw "%s" "%s". cursor SQL . SQL . cursor .STUp . , server. latch SQL . latch SQL .VW:X (tablespace) "%s" "%s" "%s.%s" "%s" . Oracle (tablespace) CREATE TEMPORARY TABLESPACE. "" . "" .Y Z[\ latch "%s" latch "%s" latch " latch". latch "" . latch "" . SQL SQL_ID "%s" .]^_x ORACLE , SYSTEM. "%s" %s\\% . "%s" .`abL "DBMS_LOCK". . DDL DML . "%s" . %s %s.c de$f . "%s.%s" %s %s. , "%s.%s". , "%s.%s". "%s" "%s.%s" "%s".g hijo INITRANS "%s" "%s.%s" "%s" . PCTFREE "%s" "%s.%s" "%s". "%s" "%s.%s" "%s" INITRANS. /.klmE INSERT. (tablespace). cursor "open_cursors".n op#q cursor "session_cached_cursors". PL/SQL. PL/SQL DDL . "%s". "%s".r&stu-v instances . "%s". instance. "%s" P1 ("%s") "%s". "%s" P1 ("%s") "%s" P2 ("%s") "%s".wx' "%s" P1,P2,P3 ("%s") : "%s", "%s" "%s" . cursor, , .yz# . . ( ) . .{ instance . , INIT.ORA ("sga_target", "shared_pool_size", "db_cache_size" "pga_aggregate_target").|} , . instance . . "sga_target" SGA instance.~ PGA "pga_aggregate_target" PGA instance. PGA "pga_aggregate_target" %s%% . "pga_aggregate_target". "pga_aggregate_target" SGA . "%s" %s%% . instance %s M SGA %s M PGA. %s M. Oracle Database Resource Manager .&5} SQL SQL_ID "%s" %s %s . SQL SQL_ID "%s" "%s" "%s" . PL/SQL "%s" . Java "%s" . "" "%s" . m5 "%s" . "%s" "%s" %s% . "/ " "%s" . Oracle Resource Manager. . Oracle Resource Manager. Oracle Resource Manager. ., "cursor_sharing" "". ; SQL . . / (%s\\%) / . "undo_retention" %s . "undo_retention" %s %s . /. " ". "%s" "%s" . SQL "shared_pool_size" %s M.+ / , : %s , %s , %s %s . SGA "sga_target" %s M. PL/SQL SQL_ID "%s". " PL/SQL" " PL/SQL" Oracle.&/ SQL /. / . SQL /. /. / "%s" "%s.%s" "%s". %s K "db_%sk_cache_size" %s M. , . , "sga_target".8 / . cursor , . cursor , AWR.L cursor , AWR. /, AWR. ADDM , .O ADDM , AWR. MTTR, AWR.` DDL , AWR. / , AWR. / RMAN, AWR.zU / RMAN /. / RMAN /. RMAN RMAN . u RMAN. , RMAN RMAN . SGA . SGA , / .i SGA "sga_target" . SGA, AWR. SGA "sga_target" %s M. SGA , / . , / . , AWR. d , /. . , AWR. "streams_pool_size" %s M. , . instance instance "%s". "gcs log flush sync", instance.H "log file sync" "gc buffer busy release" . "log file sync" instance instance.z , / "%s" "%s" . "%s" . "%s" . SQL "PLAN_HASH_VALUE" %s . SQL V$SQL. . SQL . DML . ORACLE .hd SQL instance. (instance) instance. , [ %s K / . "sga_target" %s M SQL.R . . %s SQL "PLAN_HASH_VALUE=%s" . "SQL_ID=%s". DrXY7ZH[t\]^ . " " . " " . ADDM "%s" AWR %s %s. %s %s %s %s._,`GabcRd : %s. %s. ADDM %s ADDM %s, ADDM. ADDM instance. ADDM instance %s.e fghK ADDM instance %s, %s %s. instance, ADDM instance. instance, ADDM %s instance, %s %s. instance, ADDM %s instance, %s %s.i8jklmDn|op " " . %s . %s. ADDM %s %s instance . . %s. ADDM instance %s. qVrkstuvwxy z-{]|} Instance :Instance : AWR ~JYm3DW %s %s\\% .Instance : ADDM ADDM . \gwow SQL . : %s %s\\% . SQL SQL_ID %s PLAN_HASH %s. SQL SQL_ID %s. DtC~ %s. %s, %s %s. %s %s.Latch %s. %s. %s 1 %s/ %s 1 %s 2 %s. %s. ATTR1 %s.bsi ATTR2 %s. ATTR3 %s. ATTR4 %s. %s: %s: : : %s %s\\% . : ADDM ADDM,5w ,k)[ SQL SQL SQL (plan_hash_value) ORDER BY SQL ORDER BY SQL ORDER BY SQL SQL SQL,]S SQL TRUE , FALSE ,rTRUE , FALSE SQL SQL SQL SQL SQL . SQL&}VTRUE SQL , FALSE TRUE SQL , FALSE SQL SQL SQL2fA SQL SQL SQL SQL .  Q3 YES SQL , NO SQLFULL SQL , , AUTO NO TRUE , FALSE NULL OPTIMIZER_FEATURES_ENABLE , "%s". .( . OPTIMIZER_FEATURES_ENABLE, / .. / .x OPTIMIZER_FEATURES_ENABLE . . .z %s %s. . . .,Oq . " ". . "%s"."%s" . "%s"."%s" . "%s"."%s" . v6 "%s"."%s" . "%s"."%s" . "%s"."%s" . .6 . . .U . . Z . . &   @ . SQL. . . "%s" , .&Al SQL "%s" , . . . SQL . SQL "%s" , .Kv %s . %s . %s . , .&%w . "%s" . %s . "%s". %s , . %s , .H %s , . "ACCEPT_SQL_PROFILES" "TRUE" . %s SQL SQL . SQL . , . p] SQL SQL. SQL SQL . "REPLACE_USER_SQL_PROFILES" "TRUE" SQL .! "#$W %s , . "TEST_EXECUTE" "FULL" "AUTO" . %s . %s . %s .%&&'(r) %s . %s DML DDL. %s . %s . %s "%s" .* +},-q SQL "%s" SQL "%s" +. SQL, . SQL. SQL SQL. SQL../0Z "FATAL ERROR", SQL "%s" . SQL. SQL SQL . SQL.12 SQL. SQL SQL. SQL. SQL SQL .3 45R6 sql. . %s /. %s .7 8[9: . . . ... DOP %s ...%s%% . SQL. , ... . .. . %s%%, .... . ., ...... ....;< SQL . %s . SQL.=>4 ... DOP %s ... %s%% .. ... . .. . %s%%, .... . ., ... ... .. .. .?@( Oracle optimizer . SQL .A . . . , . , SQL . Oracle optimizer .B CMDcE .. .. SQL Tuning Advisor .. . , . , . . SQL . Oracle optimizer . . . , .FG %s %s. , SQL Oracle optimizer . %s %s. , SQL Oracle optimizer .HI J %s . , SQL Oracle optimizer . . %s.KL_M %s. . "UNION ALL" "UNION" .N "UNION" . "UNION ALL" , .O "NOT IN" "NOT EXISTS" "NOT IN" "NOT NULL" "NOT NULL" "IS NOT NULL".PS> ."FILTER" . , . . "FILTER" . "NOT IN" "NOT EXISTS" "NULL". (-).TUV . "ORDERED". "ORDERED" . .YZ[X "ORDER BY" "DELETE" "UPDATE", . "ROWNUM" . .\ ]^__ . "SPREADSHEET" . . "GROUP BY" .` abc . "GROUP BY" "ROLLUP", "CUBE" "GROUPING SETS" . "START WITH" . NO_MERGE .d ghi} "CURSOR" . "WITH" . . "%s" .jk& . OPTIMIZER_FEATURES_ENABLE 9.0.1 . "START WITH".lmn "SELECT FOR UPDATE". "WHERE". "ROWNUM".opq( "GROUP BY CUBE". "GROUPING SETS". "SELECT" "SEQUENCE".rst . . "MERGE" OPTIMIZER_FEATURES_ENABLE 9.0.1 .u vw!x "%s" . "%s" . "%s" . "UNION" "%s" .yz{ . Access Advisor , . "%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".. . . "Access Advisor" SQL . . .. SQL . SQL . SQL, . Access Advisor , . , "%s"."%s" . " ". optimizer. Access Advisor , . , .,[G SQL . SQL . SQL. SQL . SQL . SQL "%s" SQL.&02 SQL "%s" SQL. "%s": %s "%s" "%s".%s SQL, . , .&H : %s %s %s %s %s %s %s %s %s %s %s, %s, %s %s ,@f %s %s, %s, %s %s %s CR Diff'ing: %s [ %s, %s]%s CR Diff'ing: %s %s [: %s, : %s] %s () %s %s %s   !R" %s %s, %s, %s %s %s P1: %s P2: %s : SQL "%s", SCN "%s", SCN "%s", (tablespace) "%s", "%s".  : SQL "%s", SCN "%s", SCN "%s", "%s". . . "%s", "%s", (tablespace) "%s". "%s" "%s", "%s", "%s". "%s" "%s", "%s", "%s". "%s"&X "%s", "%s", . "%s" dba_resumable. undo_retention "%d" (tablespace) %d MB . 4 . (tablespace) . (tablespace) . .,K (tablespace) . "Undo advisor" . . AWR. target_object. ._y (tablespace) (tablespace) . .&'a (tablespace) . (tablespace) OK. (tablespace) OK. (tablespace)  , (tablespace) (tablespace) . instance (tablespace)  k (tablespace) , %d MB instance (tablespace) instance (tablespace) (tablespace) ,  7 c }  (tablespace) , . (tablespace) [%s] [%s] (tablespace) "%s" %s "%s" %s "%s" "%s" %s "%s" , c  C  "%s" %s "%s" ADDM . %s %s "%s" instance "%s" DBA_THRESHOLDS " (tablespace)"  K  [%s] [%s] WRC clients . / (%s ms) client WRC %s %s %s c  client (%s\\%) client WRC %s %s %s client (%s\\%) / client WRC %s %s %s `t %s %s byte "%s%%" %s byte . ...:1..RMAN %s. .Data Guard, .RMAN %s.2..... RMAN %s.3.... . db_recovery_file_dest_size.4..., RMAN %s. . .., . RMAN %s. %s byte.,<q=>?(@s %s byte. . . 1% , . - %s byte. , : %s.A B{CDL . :%s: :%s: :%s: "%s.%s" - %s byte. "%s" - "%s" byte. E&FGHIX "%s" . . 10MB. %s.%s. : %s byte. %s %s.%s. : %s byte.J,E - %s %s.%s. : %s byte. -- Grid Director. instance . , instance "%s" "%s" "%s". : %s ~* instance "%s" "%s" "%s". : %s "%s%s" "%s". : %s "%s%s" "%s". : %s instance "%s", "%s" "%s". : %s    instance "%s", "%s" "%s". : %s instance "%s", "%s" "%s". : %s instance "%s", "%s" "%s". : %s "%s" ( "%s") "%s". : %s!&"#$M "%s" ( "%s") "%s". : %s "%s", "%s" "%s". : %s instance "%s" ASM "%s" "%s". : %s instance "%s" ASM "%s" "%s". : %s STREAMS "%s" ORA-%s "dba_capture", , "dbms_capture_adm.start_capture". STREAMS "%s" ORA-%sH dba_apply, . dbms_apply_adm.start_apply. ORA-26714, "DISABLE_ON_ERROR" "N" . STREAMS "%s" 16 ^ "dba_queue_schedules", , "dbms_propagation_adm.start_propagation". , . STREAMS "%s" ORA-%s&5 "dba_apply_error" . , "dbms_apply_adm.execute_error" "dbms_apply_adm.execute_all_errors". %s %s - %s %s %s %s - %s %s %s8jB`x %s %s: %s - %s SYSTEM SYSAUX %s %s %s.%s %s - %s %s.%s %s8 /Rv %s.%s %s - %s %s: %s.%s - %s "" "" "" " " "" "" Vu'Vj "" "" " /" Latche Checkpoint DROP TRUNCATECheckpoint Checkpoint MTTRCheckpoint Checkpoint DDL DBMS_LOCK Ve 0[p DBMS_PIPE / \w.J]lt ITL Java latch PL/SQL PL/SQLRMAN I/O \ 3Kt Latche / SQL "" Wait SQL DB SQL / PGA >Cu SGA / "" "" "" "" V(a " " "" "" "" "" " /" / /\fj4Pg " " " " SQL "User I/O" "Cluster" - -  latch . latch .  . (DBWR) . . CPU . . . latch "" . , / . SGA , / . , / .) PGA / . SQL . SQL cursor . . .X SQL . cursor DDL. .? SQL . . SQL . ADDM   "%s" IP %s "%s". "%s" IP %s "%s". ADDM . .q Oracle (SGA PGA) . Oracle (SGA PGA) , / . , "memory_target" . , AWR. "memory_target" %s M. / Oracle (SGA PGA) /, / . , / . / . Oracle (SGA PGA) , / .  n  ADDM %s SQL FORCE_MATCHING_SIGNATURE %s PLAN_HASH_VALUE %s . SQL V$SQL. %s SQL FORCE_MATCHING_SIGNATURE %s PLAN_HASH_VALUE %s . SQL_ID="%s".  o PL/SQL "%s" "%s" ID %s. , PL/SQL. PL/SQL %s . , PL/SQL. %s PL/SQL "%s" "%s" %s. %s PL/SQL %s. "%s" %s %s. SQL SQL_ID "%s" SQL %s %s .&C "%s", "%s" "%s". %s. "%s". instance . instance . W . (LMSn) . %s kbps . (LMSn) %s .^ instance "%s". "gcs log flush sync", instance. "log file sync" instance instance. "%s". }! "%s". , LMS . "%s" %s\\% %s ."#n? "%s" %s . %s kilo bits . .$% %s kilo bits . . %s\\% , %s\\% %s\\% .&'`( 8K %s microsecond. RMAN . / : %s%% RMAN, %s%% , %s%% %s%% .)* . , . %s, %s / %s .+, / . / %s %s .-.x / %s %s%% . / %s %s ./P; / : %s%% RMAN , %s%% , %s%% , %s%% Streams AQ %s%% . %s SQL_ID "%s" . ASH SQL_ID.QR SL SQL Tuning Advisor %s SQL_ID "%s". , . ASH SQL_ID. SQL Tuning Advisor %s SQL_ID "%s". SQL %s%% KME, E/E . SQL Tuning Advisor.T SQL %s%% KME, E/E . , SQL Tuning Advisor . SQL .UVc SQL %s%% KME, E/E . SQL Tuning Advisor. ASH . SQL Tuning Advisor SQL.WXY? SQL : %s%% SQL, %s%% , %s%% PL/SQL %s%% Java. %s . %s SQL_ID "%s" %s%% %s SQL_ID "%s".Z[\ SQL . . SQL Tuning Advisor %s. %s "%s.%s" %s %s%% SQL.]^_K %s %s%% SQL. / %s "%s.%s" %s %s%% SQL. / %s %s%% SQL.`a "User I/O" "Cluster". " SQL" / . , %s SQL_ID "%s" %s%% "User I/O" "Cluster" .bc " SQL" Java. , %s SQL_ID "%s" %s%% Java . " SQL" . , %s SQL_ID "%s" %s%% .de " SQL" . , %s SQL_ID "%s" %s%% . " SQL" "%s". , %s SQL_ID "%s" %s%% .fgF . ADDM . . ADDM , .hi . ADDM . . ADDM , .jk' . / . . ., / . ADDM , . . , "cursor_sharing" "".lm' . . . / . (redo) . ADDM , . . ADDM , .noy Oracle . ADDM , . SGA . ADDM , .pqrV . ADDM , . PGA . ADDM , . " " .s tpGq " " . %s %s %s, %s%% . %s . %s %s .rU "%s" .