# ## $#r    r #*06;AGLRW]bhknt,37?EINSX]bhmsxz|\fp #).39;=@AEHNPV^gkpuz} <D $(+/SV[_beilpr&@ . . SQL Tuning Advisor SQL SQL_ID "%s". %s\\% . . "%s" . "%s.%s" %s %s.& H  . , . -. . " (buffer) " . %s SQL PLAN_HASH_VALUE %s . -V$SQL SQL .  j U . ORACLE, -tablespace tablespace "%s" %s "%s.%s" %s. , -tablespace . (hash partitioning) -%s "%s.%s" %s DML . y&z - %s "%s.%s" %s PCTFREE. UPDATE SQL_ID "%s" " (buffer) ". INSERT SQL_ID "%s" " (buffer) ". . , SQL .&^ "%s" . "%s.%s" %s %s. -%s "%s.%s" %s DML . . INSERT SQL_ID "%s". UPDATE SQL_ID "%s" " (buffer) ".,r C -DBMS_PIPE.PUT . DELETE SQL_ID "%s" " (buffer) ". pipe . -pipes DBMS_PIPE. SELECT , . DBMS_PIPE.PUT .2q !2"n# "" . "" . "%s" "%s" . "" . "" . "" . "commit" .$2%n&'(!)Z* "" . "" . "scheduler" . "" . "" . "" . "commit" .+,,e-./c0 "" . "" . "scheduler" . -%s "%s.%s" %s. , -SQL . -%s "%s.%s" %s . SQL SQL_ID "%s" -"DBMS_LOCK".1,2V3456\ SQL SQL_ID "%s" .%s "%s.%s" "%s" . "DBMS_LOCK" . . . "log_archive_max_processes".7&89:;c ITL , . .Tablespace %s . . COMMIT . (DBWR) "db_writer_processes".<,=w>?@AA -%s M %s redo.DML -tablespaces redo . . . watermark (HW) . ITL .B,CoDEFsG . checkpoint. . " " COMMIT ROLLBACK . . (ST) .H&I_JK L . "DBMS_LOCK" . SQL SQL_ID "%s" -watermark (HW) %s "%s.%s" %s. SQL SQL_ID "%s" -Interested Transaction List (ITL) -%s "%s.%s" %s. ORACLE, -tablespace tablespace "%s".M,NWOPQ@Rx SQL . " " COMMIT ROLLBACK . %s , redo %s . (DBWR) . . redo.S&TUV'WvDML -tablespaces redo , . checkpoint. redo "log_buffer" -%s M. watermark (HW) . (ST) .X,YgZ[\]` ITL . INSERT SQL_ID "%s" " (buffer) ". %s\\%. . DELETE SQL_ID "%s" " (buffer) ". -top SQL . . ORDER RAC.^&_e`ab4 . "%s" . . SELECT SQL_ID "%s".ORACLE - SYSTEM tablespace. -tablespace .c,d~efg3h SELECT SQL_ID "%s" " (buffer) ". SELECT SQL_ID "%s" - " (buffer) ". . . Streams , . .ijfk? Streams . %s.%s SEGMENT_ID %s -interconnect latency . Oracle .lm4n ' ' (Global Cache Service); (LMSn). ' ' "gcs_server_processes". , , ' '. , . -%s "%s.%s".o&paqrtE SQL . . (LMSn) . RAC . "%s" . "%s.%s" %s %s.u&z{z "%s" . "%s.%s" %s %s. "%s" . %s %s. . "%s.%s" %s %s. "/ " . / redo .xB redo %s K %s -. PGA , / -tablespaces . "pga_aggregate_target" . SQL / . 6 %s . , . - / . / . , / . 't PGA , / -tablespaces . (Buffer) "fast_start_io_target", "fast_start_io_target" -"log_checkpoint_timeout". MTTR . , . R DML , - /. DROP TRUNCATE - /. ALTER TABLESPACE - /. "/ " .&\ %s %s. , COMMIT. SQL SQL_ID "%s" " (buffer) " . SQL /. - / . .&t / -tablespaces . (Buffer) , / . / - /. DML , - /. DROP TRUNCATE - /. B} ALTER TABLESPACE - /. redo " ". SQL SQL_ID "%s" " (buffer) " . "Segment Advisor" %s "%s.%s" %s. l - /. Oracle Stripe . . "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". MTTR "fast_start_mttr_target". Oracle ' ' . %s -%s %s , %s\\% . ADDM.,X!f ADDM. -%s "%s.%s" %s . / %s. . . . , .&y@ -SQL SQL_ID "%s" / . %s\\% -%s\\% . ADDM . . SQL Tuning Advisor SQL SQL_ID "%s". .  il . OS: , (firmware) . -OS - . "db_file_multiblock_read_count". "%s" IP "%s". %s .&n~ %s . (LMSn) %s . . SQL SQL_ID "%s" . . %s%% .&'W "%s" "%s" %s%% -SQL SQL_ID "%s". "%s" "%s" %s%% . "%s", "%s", "%s" "%s" %s%% . . "%s" "%s" -%s%% .   ,n "%s", "%s", "%s" "%s" -%s%% . , . (DBWR) "db_writer_processes". / . "%s" . "Database Reference" Oracle . -2.m/01263d SQL . SQL . SQL . PL/SQL . PL/SQL . JAVA . "%s" . "Database Reference" Oracle . - SQL .4 5h67 . SQL SQL_ID "%s" "%s". SQL . shared pool . "cursor_space_for_time" "TRUE" -shared pool (cursors) .889v:;<%=X>? SQL . SQL . SQL . PL/SQL . PL/SQL . JAVA . -CPU . redo .@,AwBCD2Ep -V$SQL_SHARED_CURSOR. shared pool . DDL . . literals . .F GH1I . ADDM . SQL . . NLS , SQL trace optimizer. DDL . .J&KLMGN . SQL . SQL . . . "%s" "%s".O&PXQRSs "%s" "%s". (hard parsing) shared pool . SQL . . . , .T&UtVWuX . .tablespace "%s" %s "%s.%s" %s . Oracle tablespaces - CREATE TEMPORARY TABLESPACE. "" . "" .Y&Z[\ ]F "%s" %s "latch free" . "" . "" . SQL SQL_ID "%s" . ORACLE, -tablespace -tablespaces -SYSTEM tablespace.^&_T`a/bv -"%s" -%s\\% . (lock) %s . "DBMS_LOCK". . DDL -DML . "%s" . %s %s.c,defgdh . "%s.%s" %s %s. "%s.%s". "%s.%s". -%s "%s.%s" %s , INITRANS %s "%s.%s" %s . PCTFREE %s "%s.%s" %s .i&jklm= %s "%s.%s" %s INITRANS. - /. INSERT . -tablespaces. , "open_cursors".n,opqr[s , "session_cached_cursors". PL/SQL . PL/SQL DDL . "%s" . "%s" . -tablespace . -tablespace "%s".t&umvwx] -tablespaces . "%s" P1 ("%s") "%s". "%s" P1 ("%s") "%s" -P2 ("%s") "%s". "%s" P1,P2,P3 ("%s") "%s", "%s" "%s" . .yz c . . : , . (paging) .{| " . INIT.ORA "sga_target", "shared_pool_size", "db_cache_size", -"pga_aggregate_target". (paging) . . .}~ Automatic Shared Memory Management "sga_target" SGA . Automatic PGA Memory Management "pga_aggregate_target" PGA ." PGA "pga_aggregate_target" %s%% . "pga_aggregate_target" . : "pga_aggregate_target" -SGA isize .2i[ "%s" %s%% . %s M SGA -%s M PGA, %s M. -Oracle Database Resource Manager . SQL SQL_ID "%s" %s %s . SQL SQL_ID "%s" %s %s . PL/SQL %s . Java %s .,^] %s . %s . "%s" "%s" -%s% . / %s . Oracle Resource Manager'. . Oracle Resource Manager.&)z Oracle Resource Manager. ., "cursor_sharing" -"force". SQL CPU . . / (%s\\%) " / . "undo_retention" -%s seconds.&%v "undo_retention" %s %s . / . redo " ". "%s" "%s" . "shared_pool_size" -%s M. / : %s , %s , %s -%s .&nC -SGA "sga_target" -%s M. PL/SQL SQL_ID "%s". , "Tuning PL/SQL Applications" Oracle: "PL/SQL User\\'s Guide and Reference". SQL / . / . SQL / . g / . / -%s "%s.%s" %s. %s K "db_%sk_cache_size" -%s M. , . "sga_target" .&= / ' ' . -shared pool -shared pool. -shared pool - AWR . - AWR . / - AWR .&x ADDM .ADDM - AWR . ' MTTR - AWR . ' -tablespace DDL - AWR . / - AWR .,xN / RMAN - AWR . / RMAN - /. / RMAN - /. RMAN, RMAN . RMAN. , RMAN, RMAN . -SGA . hC-SGA , / . SGA, "sga_target" . SGA - AWR . SGA "sga_target" -%s M.&M-SGA , / . , , / . ' - AWR .streams , / .streams . streams - AWR . dG streams "streams_pool_size" -%s M. streams , streams . "%s". " gcs" . " " - " (buffer) gc " . zJ " " . , / %s -%s . %s . %s . SQL PLAN_HASH_VALUE %s . -V$SQL SQL .$f . SQL . DML. ORACLE, -tablespace . SQL . q . , . %s K / . "sga_target" -%s M . Streams streams . DYXYZ[\ Streams streams. %s SQL PLAN_HASH_VALUE %s . SQL SQL_ID "%s". . " " . " " . ADDM '%s' AWR -%s %s. -%s -%s ]D^M_i`}abcd;e_f '%s' DB ID %s. : %s. %s. ADDM : %s. ADDM %s, ADDMADDM .ADDM %s.ADDM %s, %s %s. , ADDM . gDhij)k@ldmnop , ADDM %s, %s %s. , ADDM %s, %s %s. , " " . %s . %s.ADDM %s %s . . %s.ADDM %sqzrstuvwxyz{| }5~W]h : : AWR %s , %s\\% . : z"CLW ADDM ADDM . SQL . : %s , %s\\% . SQL SQL_ID %s PLAN_HASH %s. SQL SQL_ID %s.t5W %s. %s, %s %s. Tablespace %s %s. %s. %s. %s id1 %s. %s ID1 %s ID2 %s. %s.ATTR1 %s.ATTR2 %s.ATTR3 %s.ATTR4 %s. %s: %s: Vd{ J : %s , %s\\% . :ADDM ADDM - . -, . >l)bz SQL -SQL SQL. (plan_hash_value). ORDER BY SQL ORDER BY SQL ORDER BY SQL -SQL SQL -SQL .8qg . TRUE . FALSE .TRUE . FALSE . commit SQL. SQL SQL -SQL SQL . DbNf SQLTRUE SQL, FALSE TRUE SQL , FALSE SQL SQL explain plan SQL SQL SQL 2O? SQL YES SQL ; NO -advisor SQLFULL SQL , AUTO -NO TRUE . FALSE NULL OPTIMIZER_FEATURES_ENABLE %s. -optimizer . OPTIMIZER_FEATURES_ENABLE , -optimizer . -optimizer.,W OPTIMIZER_FEATURES_ENABLE . -optimizer . -optimizer . -optimizer -%s -%s. -optimizer . -optimizer . optimizer -. optimizer. >oP} optimizer " ". optimizer. "%s"."%s" . "%s"."%s" . "%s"."%s" . Optimizer "%s"."%s" . Optimizer "%s"."%s" . Optimizer "%s"."%s" .optimizer .&)optimizer .optimizer . -optimizer , . -optimizer , . -optimizer , .,   a   -optimizer , . -optimizer , . -optimizer , . SQL . optimizer . optimizer .8x3K "%s" . SQL "%s", . . optimizer . SQL. SQL "%s", .%s .%s .&G_-%s . . . "%s" .%s . , "%s" .-%s , . S)-%s , .-%s , . ACCEPT_SQL_PROFILES -TRUE .-%s , -SQL SQL . SQL , optimizer . optimizer SQL.& q!"# SQL , SQL . SQL , SQL . REPLACE_USER_SQL_PROFILES -TRUE SQL .-%s , . TEST_EXECUTE -FULL -AUTO .-%s . %s , .$,%t&'(l) %s , . %s, . %s, DMLs DDLs. %s, . %s .%s "%s" .*&+q,-%.R SQL "%s" SQL "%s" . SQL , . SQL . SQL SQL . SQL . "FATAL ERROR", SQL "%s" ./&0123 SQL . SQL SQL, . SQL . SQL . SQL SQL . SQL . SQL SQL, . sql . .4,5u6789V-%s /. . %s . . . .:;l -DOP %s %s%% -SQL. , . -%s%% . , , . SQL .<=n %s . SQL . -DOP %s %s%% . , . -%s%% . , , .>?@ Y , , (elapsed time) . -Oracle optimizer . SQL (elapsed time) .A , . , , SQL. Oracle optimizer .B COD\Es , SQL Tuning Advisor . , , SQL. Oracle optimizer . . . , .FGH\ %s -%s . , SQL Oracle optimizer . %s -%s . , SQL Oracle optimizer . %s . , SQL Oracle optimizer .I,J}KLMNY , -%s . -%s . . -"UNION ALL" "UNION", - ."UNION" . "UNION ALL" , -.OP "NOT IN" -"NOT EXISTS" "NOT IN" "NOT NULL" "NOT NULL" "IS NOT NULL" "FILTER" - . , - "FILTER" -join. -"NOT IN" "NOT EXISTS" "NULL".S TrUV| join . . "ORDERED". "ORDERED" optimizer . .Y,Z[\]T^optimizer "ORDER BY" "DELETE" "UPDATE" .-optimizer view - "ROWNUM".optimizer .optimizer .optimizer "SPREADSHEET".optimizer ._2`{abcOdgoptimizer "GROUP BY".-optimizer view .optimizer "GROUP BY" "ROLLUP", "CUBE" "GROUPING SETS".optimizer "START WITH".optimizer NO_MERGE.optimizer "CURSOR".optimizer "WITH".h ivjkt-optimizer view -outer join.optimizer %s . View , . OPTIMIZER_FEATURES_ENABLE -9.0.1, -optimizer views .optimizer "START WITH".l&mtnopooptimizer "SELECT FOR UPDATE". outer join "WHERE" .optimizer "ROWNUM".optimizer "GROUP BY CUBE".optimizer "GROUPING SETS".q&rstupoptimizer "SELECT" "SEQUENCE".optimizer outer join .optimizer -outer join . "MERGE" OPTIMIZER_FEATURES_ENABLE -9.0.1 . %s .v&wrxyz3optimizer - %s .optimizer %s . "UNION" %s . . .{|}6 %s %s , "%s". -optimizer "%s"."%s". %s %s , "%s". -optimizer "%s"."%s". %s %s , "%s". -optimizer "%s"."%s".~F %s %s , "%s". -optimizer "%s"."%s".optimizer -, . . , .` . %s %s , - "%s". - -optimizer "%s"."%s". %s %s , - "%s". - -optimizer "%s"."%s". . , " " SQL , . . SQL . -optimizer SQL . SQL -optimizer .W Access Advisor . , "%s"."%s" . , , . -optimizer .,>Xw Access Advisor . , . , . SQL . SQL . SQL . SQL . -SQL .835 SQL '%s' -SQL. SQL '%s' -SQL. '%s': %s '%s' '%s'.%s SQL , . . : %s %s %s hash %s2H8e %s %s %s %s %s hash %s %s, check sum %s, %s -%s hash %s %s, check sum %s, %s -%s %s CR Diff'ing: %s [base %s, target %s]%s CR Diff'ing: %s %s [rule: %s, status: %s], !"! %s () %s %s hash %s hash %s %s, check sum %s, %s -%s %s P1: %s P2: %s ' ': SQL %s, SCN %s, SCN %s, Undo Tablespace %s, Undo %s.,7 ' ': SQL %s, SCN %s, SCN %s, rollback segment %s. . rollback. %s %s -tablespace %s. %s. %s %s rollback %s. %s %s %s -%s. %s8 F %s %s . %s dba_resumable. undo_retention -%d tablespace %d MB . '- '.Tablespace . tablespace .8Er '- '. tablespace . . . -AWR. target_object. ' '. tablespace .2Vx -tablespace . . tablespace . tablespace . tablespace . - tablespace . .2)Ms tablespace . tablespace . tablespace .tablespace %d MB tablespace . tablespace . tablespace . >  3 Z   tablespace , .Tablespace [%s] [%s] -tablespace "%s" -%s "%s" -%s "%s" "%s" -%s "%s" "%s" -%s "%s" ADDM . %s %s  , M @ "%s" "%s". DBA_THRESHOLDS . " Tablespace ".-Tablespace [%s] [%s] WRC, . / , %s , WRC %s -%s %s & "[ (%s\\%) -CPU WRC %s -%s %s (%s\\%) / WRC %s -%s %s %s %s bytes %s%% -%s bytes . tr< : 1. RMAN %s. -Data Guard, RMAN %s. 2. RMAN %s. 3. db_recovery_file_dest_size. 4. RMAN %s. , - RMAN %s. %s bytes. %s bytes. .=8>Y?@ABCVD . -1% . . . %s . %s. . : %s: : %s: :%s: %s.%s . %s . %s. %s . EDFxGHIJ;w%s . . -10MB. %s.%s, %s . %s.%s %s, %s . %s.%s - %s, %s . -- Grid Director . . 8h.d %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 2!k"#$;c %s (domain %s) %s; : %s %s (domain %s) %s; : %s %s %s %s; : %s ASM %s %s %s; : %s ASM %s %s %s; : %s STREAMS "%s" ORA-%s -dba_capture, dbms_capture_adm.start_capture.DO|STREAMS apply process "%s" ORA-%s -dba_apply, dbms_apply_adm.start_apply. ORA-26714, 'DISABLE_ON_ERROR' 'N' . STREAMS "%s" 16 Y c-dba_queue_schedules, dbms_propagation_adm.start_propagation. , -Streams. STREAMS STREAMS apply process "%s" ORA-%s89Jn dba_apply_error . , dbms_apply_adm.execute_error dbms_apply_adm.execute_all_errors. %s %s - %s %s %s %s - %s %s %s %s ' %s: %s - %s P= -tablespaces SYSTEM SYSAUX Tablespace %s %s %s.%s %s - %s %s.%s %s %s.%s %s - %s ' %s: %s.%s - %s "" "" "" "" ""n#:\} "" "" "Scheduler" "I/O " ' DROP TRUNCATE ' ' MTTR ' ' Tablespace DDL Commit -Rollback -DBMS_LOCK -DBMS_PIPE h 8@Qdy (Hard Parse) (Hard Parse) (Hard Parse) (Hard Parse) (Hard Parse) -Watermark -I/O ITL Java!.DZlw PL/SQL PL/SQLRMAN I/O (Soft Parse) Streams I/OSQL ""SQL SQL I/O hs5SnPGA Redo Log SGA Streams I/O "" "" "" "Commit" "" "" "" "" "Scheduler" "I/O " ":Zm~ (paging) I/O I/O " " " " SQL "/ " -"" - - &S . . . (DBWR) . redo . . .&wp (paging) . "" . -I/O .-SGA , -I/O .streams , -I/O streams. s-PGA , I/O -tablespaces . SQL . SQL . . .  SQL . DDL . . SQL . . SQL .,zEt , ADDM - "%s" IP %s "%s". "%s" IP %s "%s". -ADDM . . Oracle (SGA -PGA) . y)q Oracle (SGA -PGA) , -I/O . "memory_target" . AWR . "memory_target" -%s M.  T Oracle (SGA -PGA) , -I/O . , , -I/O . Oracle (SGA -PGA) , -I/O . ADDM    6 %s SQL FORCE_MATCHING_SIGNATURE %s PLAN_HASH_VALUE %s . SQL , -V$SQL . %s SQL FORCE_MATCHING_SIGNATURE %s PLAN_HASH_VALUE %s . SQL SQL_ID "%s". PL/SQL "%s" "%s" %s. , PL/SQL. %s PL/SQL . , PL/SQL.&^~%s PL/SQL "%s" "%s" %s.%s %s PL/SQL. "%s" -%s -%s . SQL SQL_ID "%s" -SQL -%s -%s . "%s", "%s" "%s".2hN %s. "%s". . . .Global Cache Service Processes (LMSn) . %s - interconnect.&r\Global Cache Service Processes (LMSn) %s . "%s". "gcs log flush sync" . " " . "%s". "%s". &!"#E$y , (paging) LMSn . "%s" %s\\% -%s . "%s" -%s . %s - . %s - . .% &'(M%s\\% , %s\\% %s\\% . 8K %s . RMAN Data Pump, . / : %s%% RMAN, %s%% Data Pump, %s%% -%s%% .)*+E . , . %s, %s / %s . / ., -./8 / %s redo -%s . / redo %s -%s%% . / redo %s -%s . / redo : %s%% RMAN , %s%% Log Writer, %s%% Archiver, %s%% Streams AQ -%s%% .P QR9Sn %s SQL_ID "%s" . , ASH SQL_ID . SQL Tuning Advisor %s SQL_ID "%s". , . ASH SQL_ID . SQL Tuning Advisor %s SQL_ID "%s".-SQL %s%% -CPU, / . SQL Tuning Advisor.TUV-SQL %s%% -CPU, / . , SQL Tuning Advisor . -SQL .-SQL %s%% -CPU, / . SQL Tuning Advisor. , ASH.SQL Tuning Advisor SQL .W&XYZO[ SQL : %s%% SQL, %s%% , %s%% PL/SQL -%s%% Java. , -%s SQL . %s SQL_ID "%s" - %s%% %s SQL_ID "%s". SQL . .SQL Tuning Advisor %s.\ ]}^_C %s "%s.%s" %s %s%% SQL . %s %s%% SQL . / %s "%s.%s" %s %s%% SQL . / %s %s%% SQL .`asb "/ " "" . " SQL " SQL / . , %s SQL_ID "%s" -%s%% "/ " "" . " SQL " SQL Java. , %s SQL_ID "%s" -%s%% Java .cdeL " SQL " SQL CPU. , %s SQL_ID "%s" -%s%% -CPU . " SQL " SQL . , %s SQL_ID "%s" -%s%% . " SQL " SQL "%s". , %s SQL_ID "%s" -%s%% .f gxhiV . , ADDM . . , ADDM . CPUs . , ADDM . -shared pool . , ADDM .jklb - /. -database writers, / . , ADDM . . "cursor_sharing" -"force". redo log buffers . / redo log . , ADDM .m nopZ . , ADDM . Oracle . , ADDM . -SGA . , ADDM . streams . , ADDM .q2rstp|qr -PGA . , ADDM . " " . " " . %s %s ' %s -%s%% .%s . %s %s . %s .