# ## $#sY   s #*06;AGLRW]bhknt,37?EINSX]bhmsxz|\fp  &,18;=@AEHNPV^gkpuz} <DK  $(+/SV[_beilpps&@ . . 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&y - %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:;b 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 .lm3n ' ' (Global Cache Service); (LMSn). ' ' "gcs_server_processes". , , ' '. , . -%s "%s.%s".o&paqrtE SQL . . (LMSn) . RAC . "%s" . "%s.%s" %s %s.u&z{y "%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.bu -"%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 .&$_ "%s" . SQL -API: dbms_spm.migrate_stored_outline SQL "%s", . . optimizer . SQL.,w SQL "%s", .%s .%s .-%s . . . "%s" .%s .&t] , "%s" .-%s , .-%s , .-%s , . ACCEPT_SQL_PROFILES -TRUE .-%s , -SQL SQL .  SQL , optimizer . optimizer SQL. SQL , SQL . SQL , SQL . REPLACE_USER_SQL_PROFILES -TRUE SQL .!,"#$%N&-%s , . TEST_EXECUTE -FULL -AUTO .-%s . %s , . %s , . %s, . %s, DMLs DDLs.',(})*+,o %s, . %s .%s "%s" . SQL "%s" SQL "%s" . SQL , . SQL . SQL SQL .-&.S/0$1A SQL . "FATAL ERROR", SQL "%s" . SQL . SQL SQL, . SQL . SQL . SQL SQL .22345W678 SQL . SQL SQL, . sql . .-%s /. . %s . . .9:T; . -DOP %s %s%% -SQL. , . -%s%% . , , . SQL .<=n %s . SQL . -DOP %s %s%% . , . -%s%% . , , .>?@X , , (elapsed time) . -Oracle optimizer . SQL (elapsed time) .A , . , , SQL. Oracle optimizer .B CND[Er , 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 ivjks-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 D %s %s . %s dba_resumable. undo_retention -%d tablespace %d MB . '- '.Tablespace . tablespace .8Er '- '. tablespace . . . -AWR. target_object. ' '. tablespace .2Su -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 &  "Z (%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?@ABCUD . -1% . . . %s . %s. . : %s: : %s: :%s: %s.%s . %s . %s. %s .E2FfGHIJ)Ke%s . . -10MB. %s.%s, %s . %s.%s %s, %s . %s.%s - %s, %s . I/O /:%s, I/O /:%s, (MB):%s, I/O /:%s.L8MN8c{ %s.%s , I/O %s - %s.%s %s , I/O %s -. %s.%s - %s , I/O %s -. -- Grid Director . . %s %s %s; : %s8h4}  %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#$) %s ( %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.STREAMS apply process "%s" ORA-%s$Q -dba_apply, dbms_apply_adm.start_apply. ORA-26714, 'DISABLE_ON_ERROR' 'N' . STREAMS "%s" 16 c-dba_queue_schedules, dbms_propagation_adm.start_propagation.f| , -Streams. STREAMS STREAMS apply process "%s" ORA-%s dba_apply_error . , dbms_apply_adm.execute_error dbms_apply_adm.execute_all_errors.  K STREAMS "%s", streams "%s", "%s" streams "%s" STREAMS streams . -DBA_STREAMS_SPLIT_MERGE. XStream "%s" ORA-%s -dba_capture, dbms_capture_adm.start_capture.CM~XStream apply process "%s" ORA-%s -dba_apply, dbms_apply_adm.start_apply. ORA-26714, 'DISABLE_ON_ERROR' 'N' . XStream "%s" 16  c-dba_queue_schedules, dbms_propagation_adm.start_propagation. XStream -apply process "%s" ORA-%s dba_apply_error . , dbms_apply_adm.execute_error dbms_apply_adm.execute_all_errors. )W XStream "%s", XStream "%s", "%s" XStream "%s" XStream streams . -DBA_STREAMS_SPLIT_MERGE. GoldenGate "%s" ORA-%s -dba_capture, dbms_capture_adm.start_capture.FPGoldenGate apply process "%s" ORA-%s -dba_apply, dbms_apply_adm.start_apply. ORA-26714, 'DISABLE_ON_ERROR' 'N' . GoldenGate "%s" 16  c-dba_queue_schedules, dbms_propagation_adm.start_propagation. GoldenGate apply process "%s" ORA-%s dba_apply_error . , dbms_apply_adm.execute_error dbms_apply_adm.execute_all_errors.2L GoldenGate "%s", GoldenGate "%s", "%s" GoldenGate "%s" GoldenGate GoldenGate . -DBA_STREAMS_SPLIT_MERGE. %s %s - %s %s %s %s - %s %s %s D[/P %s ' %s: %s - %s -tablespaces SYSTEM SYSAUX Tablespace %s %s %s.%s %s - %s %s.%s %s %s.%s %s - %s ' %s: %s.%s - %s ""n-Pq "" "" "" "" "" "" "Scheduler" "I/O " ' DROP TRUNCATE ' ' MTTR ' ' Tablespace DDL Commit -Rollback hy@k -DBMS_LOCK -DBMS_PIPE (Hard Parse) (Hard Parse) (Hard Parse) (Hard Parse) (Hard Parse) -Watermark -I/O  %/JYkx ITL Java PL/SQL PL/SQLRMAN I/O (Soft Parse) Streams I/Ot(C^ySQL ""SQL SQL I/O PGA Redo Log SGA Streams I/O "" "" "" "Commit" "" "" "" ""  "'+:FP^c{ "Scheduler" "I/O " (paging) I/O I/O " " " " SQL "/ " -"",@[ - - . . . (DBWR) . redo .&u"k . . (paging) . "" . -I/O .-SGA , -I/O . ?streams , -I/O streams.-PGA , I/O -tablespaces . SQL . SQL . . o . SQL . DDL . . SQL . .2{ G SQL . , 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 QR8Sm %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 .jkla - /. -database writers, / . , ADDM . . "cursor_sharing" -"force". redo log buffers . / redo log . , ADDM .m nopZ . , ADDM . Oracle . , ADDM . -SGA . , ADDM . streams . , ADDM .q,rstuvp -PGA . , ADDM . " " . " " . %s %s ' %s -%s%% . - %s PL/SQL ID %s %s .%s .qrUsw %s %s . %s . %s %s .