SQLT – Geração do Relatório
Existem vários métodos para gerar um relatório da ferramenta SQLT (SQLTXPLAIN).
Um deles é o SQLTXTRACT, ideal para analisar um SQL que já foi executado.
Os scripts para geração de relatórios do SQLT ficam na pasta run, no diretório onde foi descompactado o SQLT.
O SQLTXTRACT requer o SQL_ID do SQL que será analisado, e deve ser executado com o usuário que o executou (no meu caso, o SCOTT).
Ao término da execução do SQLTXTRACT (que é bem extensa e completa, veja abaixo) é gerado um arquivo zip (neste caso, sqlt_s71191_xtract_8r9k0d8kkvcv1.zip), onde estão todos os dados analisados, e o relatório completo do SQL em questão, que veremos em um próximo Post.
Microsoft Windows [versão 6.1.7601] Copyright (c) 2009 Microsoft Corporation. Todos os direitos reservados. C:UsersRicardo>cd Software C:UsersRicardoSoftware>cd sqlt C:UsersRicardoSoftwaresqlt>cd run C:UsersRicardoSoftwaresqltrun>sqlplus SCOTT/TIGER SQL*Plus: Release 11.2.0.3.0 Production on Seg Out 7 13:02:11 2013 Copyright (c) 1982, 2011, Oracle. All rights reserved. Conectado a: Personal Oracle Database 11g Release 11.2.0.3.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> SET PAGES 1000 SQL> SET LINES 210 SQL> COL SQL_TEXT FORMAT A100 SQL> SELECT COUNT(OBJECT_TYPE) FROM T WHERE OBJECT_TYPE = 'TABLE'; COUNT(OBJECT_TYPE) ------------------ 7456 SQL> SELECT COUNT(OBJECT_TYPE) FROM T WHERE OBJECT_TYPE = 'VIEW'; COUNT(OBJECT_TYPE) ------------------ 136160 SQL> SELECT COUNT(OBJECT_TYPE) FROM T WHERE OBJECT_TYPE = 'SYNONYM'; COUNT(OBJECT_TYPE) ------------------ 896864 SQL> SELECT SQL_ID, SQL_TEXT FROM V$SQL WHERE SQL_TEXT LIKE '%FROM T %'; SQL_ID SQL_TEXT ------------- ---------------------------------------------------------------------------------------------------- 6y7gd43bqwup7 SELECT COUNT(OBJECT_TYPE) FROM T WHERE OBJECT_TYPE = 'TABLE' c29z19hyh18jv SELECT COUNT(OBJECT_TYPE) FROM T WHERE OBJECT_TYPE = 'VIEW' 1ca07qc8njdkv SELECT SQL_ID, SQL_TEXT FROM V$SQL WHERE SQL_TEXT LIKE '%FROM T %' 8r9k0d8kkvcv1 SELECT COUNT(OBJECT_TYPE) FROM T WHERE OBJECT_TYPE = 'SYNONYM' SQL> @sqltxtract 8r9k0d8kkvcv1 Procedimento PL/SQL concluÝdo com sucesso. Parameter 1: SQL_ID or HASH_VALUE of the SQL to be extracted (required) Paremeter 2: SQLTXPLAIN password (required) Informe o valor para 2: Nerv2013 SQLT_VERSION ---------------------------------------- SQLT version number: 12.1.02 SQLT version date : 2013-09-09 Installation date : 2013-10-07/12:23:12 ... please wait ... adding: alert_orcl.log (136 bytes security) (deflated 85%) NOTE: You used the XTRACT method connected as SCOTT. In case of a session disconnect please verify the following: 1. There are no errors in sqltxtract.log. 2. Your SQL 8r9k0d8kkvcv1 exists in memory or in AWR. 3. You connected as the application user that issued original SQL. 4. User SCOTT has been granted SQLT_USER_ROLE. In case of errors ORA-03113, ORA-03114 or ORA-07445 please just re-try this SQLT method. This tool handles some of the errors behind a disconnect when executed a second time. To actually diagnose the problem behind the disconnect, read ALERT log and provide referenced traces to Support. After the root cause of the disconnect is fixed then reset SQLT corresponding parameter. To monitor progress, login into another session and execute: SQL> SELECT * FROM SQLTXADMIN.sqlt$_log_v; ... collecting diagnostics details, please wait ... In case of a disconnect review log file in current directory 'vmstat' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. 'sar' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. ... getting sqlt_s71191_sql_monitor_active_driver.sql out of sqlt repository ... ... generating sqlt_s71191_sql_monitor_active_16777216_1500240790_1.html ... ... generating sqlt_s71191_sql_monitor_active_16777217_2371838348_1.html ... ... generating sqlt_s71191_sql_monitor_active_16777216_1500240790_1.html ... adding: sqlt_s71191_sql_monitor_active_16777216_1500240790_1.html (164 bytes security) (deflated 90%) adding: sqlt_s71191_sql_monitor_active_16777217_2371838348_1.html (164 bytes security) (deflated 82%) adding: sqlt_s71191_sql_monitor_active_driver.sql (164 bytes security) (deflated 79%) zip warning: error deleting sqlt_s71191_sql_monitor_active_driver.sql ... getting sqlt_s71191_remote_driver.sql out of sqlt repository ... adding: sqlt_s71191_remote_driver.sql (164 bytes security) (deflated 27%) zip warning: error deleting sqlt_s71191_remote_driver.sql ... getting sqlt_s71191_main.html out of sqlt repository ... ... getting sqlt_s71191_lite.html out of sqlt repository ... ... getting sqlt_s71191_readme.html out of sqlt repository ... ... getting sqlt_s71191_readme.txt out of sqlt repository ... ... getting sqlt_s71191_metadata.sql out of sqlt repository ... ... getting sqlt_s71191_metadata1.sql out of sqlt repository ... ... getting sqlt_s71191_metadata2.sql out of sqlt repository ... ... getting sqlt_s71191_system_stats.sql out of sqlt repository ... ... getting sqlt_s71191_schema_stats.sql out of sqlt repository ... ... getting sqlt_s71191_set_cbo_env.sql out of sqlt repository ... ... getting missing_file.txt out of sqlt repository ... ... getting sqlt_s71191_sta_report_mem.txt out of sqlt repository ... ... getting sqlt_s71191_sta_script_mem.sql out of sqlt repository ... ... getting missing_file.txt out of sqlt repository ... ... getting missing_file.txt out of sqlt repository ... ... getting missing_file.txt out of sqlt repository ... ... getting missing_file.txt out of sqlt repository ... ... getting sqlt_s71191_sql_detail_active.html out of sqlt repository ... ... getting sqlt_s71191_sql_monitor_active.html out of sqlt repository ... ... getting sqlt_s71191_sql_monitor.html out of sqlt repository ... ... getting sqlt_s71191_sql_monitor.txt out of sqlt repository ... ... getting sqlt_s71191_10053_explain.trc out of sqlt repository ... ... getting sqlt_s71191_10053_i1_c0_extract.trc out of sqlt repository ... ... getting missing_file.txt out of sqlt repository ... ... getting sqlt_s71191_import.sh out of sqlt repository ... ... getting sqlt_s71191_export_parfile.txt out of sqlt repository ... ... getting sqlt_s71191_export_parfile2.txt out of sqlt repository ... ... getting plan.sql out of sqlt repository ... ... getting 10053.sql out of sqlt repository ... ... getting flush.sql out of sqlt repository ... ... getting sqlt_s71191_purge.sql out of sqlt repository ... ... getting sqlt_s71191_restore.sql out of sqlt repository ... ... getting sqlt_s71191_del_hgrm.sql out of sqlt repository ... ... getting tc.sql out of sqlt repository ... ... getting xpress.sh out of sqlt repository ... ... getting xpress.sql out of sqlt repository ... ... getting setup.sql out of sqlt repository ... ... getting readme.txt out of sqlt repository ... ... getting tc_pkg.sql out of sqlt repository ... ... getting sel.sql out of sqlt repository ... ... getting sel_aux.sql out of sqlt repository ... ... getting install.sh out of sqlt repository ... ... getting install.sql out of sqlt repository ... ... getting pack_tcx.sql out of sqlt repository ... ... getting sqlt_s71191_awrrpt_driver.sql out of sqlt repository ... ... generating sqlt_s71191_awrrpt_0001_1_21_22.html ... ... generating sqlt_s71191_awrrpt_0002_1_10_11.html ... ... generating sqlt_s71191_awrrpt_0003_1_11_12.html ... ... generating sqlt_s71191_awrrpt_0004_1_12_13.html ... adding: sqlt_s71191_awrrpt_0001_1_21_22.html (164 bytes security) (deflated 90%) adding: sqlt_s71191_awrrpt_0002_1_10_11.html (164 bytes security) (deflated 91%) adding: sqlt_s71191_awrrpt_0003_1_11_12.html (164 bytes security) (deflated 90%) adding: sqlt_s71191_awrrpt_0004_1_12_13.html (164 bytes security) (deflated 90%) adding: sqlt_s71191_awrrpt_driver.sql (164 bytes security) (deflated 77%) zip warning: error deleting sqlt_s71191_awrrpt_driver.sql ... getting sqlt_s71191_addmrpt_driver.sql out of sqlt repository ... ... generating sqlt_s71191_addmrpt_0001_1_21_22.txt ... ... generating sqlt_s71191_addmrpt_0002_1_10_11.txt ... ... generating sqlt_s71191_addmrpt_0003_1_11_12.txt ... ... generating sqlt_s71191_addmrpt_0004_1_12_13.txt ... adding: sqlt_s71191_addmrpt_0001_1_21_22.txt (164 bytes security) (deflated 61%) adding: sqlt_s71191_addmrpt_0002_1_10_11.txt (164 bytes security) (deflated 73%) adding: sqlt_s71191_addmrpt_0003_1_11_12.txt (164 bytes security) (deflated 61%) adding: sqlt_s71191_addmrpt_0004_1_12_13.txt (164 bytes security) (deflated 75%) adding: sqlt_s71191_addmrpt_driver.sql (164 bytes security) (deflated 79%) zip warning: error deleting sqlt_s71191_addmrpt_driver.sql ... getting sqlt_s71191_ashrpt_driver.sql out of sqlt repository ... ... generating sqlt_s71191_ashrpt_0001_mem_1_1007_1303.html ... ... generating sqlt_s71191_ashrpt_0002_awr_1_1007_1057.html ... ... generating sqlt_s71191_ashrpt_0003_awr_1_1007_1241.html ... ... generating sqlt_s71191_ashrpt_0004_awr_1_1006_0851.html ... ... generating sqlt_s71191_ashrpt_0005_awr_1_1006_0956.html ... adding: sqlt_s71191_ashrpt_0001_mem_1_1007_1303.html (164 bytes security) (deflated 87%) adding: sqlt_s71191_ashrpt_0002_awr_1_1007_1057.html (164 bytes security) (deflated 85%) adding: sqlt_s71191_ashrpt_0003_awr_1_1007_1241.html (164 bytes security) (deflated 85%) adding: sqlt_s71191_ashrpt_0004_awr_1_1006_0851.html (164 bytes security) (deflated 46%) adding: sqlt_s71191_ashrpt_0005_awr_1_1006_0956.html (164 bytes security) (deflated 46%) adding: sqlt_s71191_ashrpt_driver.sql (164 bytes security) (deflated 81%) zip warning: error deleting sqlt_s71191_ashrpt_driver.sql ... getting sqlt_s71191_tcb_driver.sql out of sqlt repository ... zip warning: name not matched: C:oraclediagrdbmsorclorcltracesqlt_s71191_tcb_* zip warning: name not matched: C:oraclediagrdbmsorclorcltraceREADME.txt zip error: Nothing to do! (sqlt_s71191_tcb.zip) adding: sqlt_s71191_tcb_driver.sql (164 bytes security) (deflated 43%) zip warning: error deleting sqlt_s71191_tcb_driver.sql ... getting sqlt_s71191_export_driver.sql out of sqlt repository ... ******************************************************************* * Enter SQLTXPLAIN valid password to export SQLT repository * * Notes: * * 1. If you entered an incorrect password you will have to enter * * now both USER and PASSWORD. The latter is case sensitive * * 2. User is SQLTXPLAIN and not your application user. * ******************************************************************* Export: Release 11.2.0.3.0 - Production on Seg Out 7 13:20:30 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Conectado a: Personal Oracle Database 11g Release 11.2.0.3.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ExportaþÒo executada no conjunto de caracteres de WE8MSWIN1252 e no conjunto de caracteres de AL16UTF16 NCHAR Obs.: concess§es em tabelas/views/sequÛncias/funþ§es nÒo serÒo exportadas Obs.: Ýndices em tabelas nÒo serÒo exportados Obs.: restriþ§es em tabelas nÒo serÒo exportadas Sobre exportar tabelas especificadas via Caminho Convencional ... . . exportando tabela SQLT$_STATTAB 0 linhas exportadas ExportaþÒo encerrada com sucesso, sem advertÛncias. Export: Release 11.2.0.3.0 - Production on Seg Out 7 13:20:46 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. Conectado a: Personal Oracle Database 11g Release 11.2.0.3.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ExportaþÒo executada no conjunto de caracteres de WE8MSWIN1252 e no conjunto de caracteres de AL16UTF16 NCHAR Obs.: concess§es em tabelas/views/sequÛncias/funþ§es nÒo serÒo exportadas Obs.: Ýndices em tabelas nÒo serÒo exportados Obs.: restriþ§es em tabelas nÒo serÒo exportadas Sobre exportar tabelas especificadas via Caminho Convencional ... . . exportando tabela SQLT$_SQL_STATEMENT 1 linhas exportadas . . exportando tabela SQLT$_AUX_STATS$ 13 linhas exportadas . . exportando tabela SQLT$_DBA_AUTOTASK_CLIENT 1 linhas exportadas . . exportando tabela SQLT$_DBA_COL_STATS_VERSIONS 165 linhas exportadas . . exportando tabela SQLT$_DBA_COL_USAGE$ 1 linhas exportadas . . exportando tabela SQLT$_DBA_CONSTRAINTS 6 linhas exportadas . . exportando tabela SQLT$_DBA_HIST_ACTIVE_SESS_HIS 9 linhas exportadas . . exportando tabela SQLT$_DBA_HIST_PARAMETER_M 20 linhas exportadas . . exportando tabela SQLT$_DBA_HIST_SEG_STAT_OBJ 2 linhas exportadas . . exportando tabela SQLT$_DBA_HIST_SNAPSHOT 24 linhas exportadas . . exportando tabela SQLT$_DBA_HIST_SQL_PLAN 6 linhas exportadas . . exportando tabela SQLT$_DBA_HIST_SQLSTAT 8 linhas exportadas . . exportando tabela SQLT$_DBA_HIST_SQLTEXT 1 linhas exportadas . . exportando tabela SQLT$_DBA_HISTGRM_STATS_VERSN 142 linhas exportadas . . exportando tabela SQLT$_DBA_IND_COLUMNS 1 linhas exportadas . . exportando tabela SQLT$_DBA_IND_STATISTICS 1 linhas exportadas . . exportando tabela SQLT$_DBA_IND_STATS_VERSIONS 11 linhas exportadas . . exportando tabela SQLT$_DBA_INDEXES 1 linhas exportadas . . exportando tabela SQLT$_DBA_OBJECTS 2 linhas exportadas . . exportando tabela SQLT$_DBA_OPTSTAT_OPERATIONS 277 linhas exportadas . . exportando tabela SQLT$_DBA_SEGMENTS 2 linhas exportadas . . exportando tabela SQLT$_DBA_TAB_COLS 15 linhas exportadas . . exportando tabela SQLT$_DBA_TAB_STATISTICS 1 linhas exportadas . . exportando tabela SQLT$_DBA_TAB_STATS_VERSIONS 11 linhas exportadas . . exportando tabela SQLT$_DBA_TABLES 1 linhas exportadas . . exportando tabela SQLT$_DBA_TABLESPACES 5 linhas exportadas . . exportando tabela SQLT$_DBMS_XPLAN 162 linhas exportadas . . exportando tabela SQLT$_GV$ACTIVE_SESSION_HISTOR 85 linhas exportadas . . exportando tabela SQLT$_GV$NLS_PARAMETERS 19 linhas exportadas . . exportando tabela SQLT$_GV$OBJECT_DEPENDENCY 3 linhas exportadas . . exportando tabela SQLT$_GV$PARAMETER2 347 linhas exportadas . . exportando tabela SQLT$_GV$PARAMETER_CBO 288 linhas exportadas . . exportando tabela SQLT$_GV$PQ_SYSSTAT 20 linhas exportadas . . exportando tabela SQLT$_GV$PX_PROCESS_SYSSTAT 15 linhas exportadas . . exportando tabela SQLT$_GV$SQL 1 linhas exportadas . . exportando tabela SQLT$_GV$SQL_MONITOR 3 linhas exportadas . . exportando tabela SQLT$_GV$SQL_OPTIMIZER_ENV 1 linhas exportadas . . exportando tabela SQLT$_GV$SQL_PLAN 3 linhas exportadas . . exportando tabela SQLT$_GV$SQL_PLAN_MONITOR 9 linhas exportadas . . exportando tabela SQLT$_GV$SQL_SHARED_CURSOR 1 linhas exportadas . . exportando tabela SQLT$_GV$SQLAREA 1 linhas exportadas . . exportando tabela SQLT$_GV$SQLAREA_PLAN_HASH 1 linhas exportadas . . exportando tabela SQLT$_GV$SQLSTATS 1 linhas exportadas . . exportando tabela SQLT$_GV$SQLSTATS_PLAN_HASH 1 linhas exportadas . . exportando tabela SQLT$_GV$SQLTEXT_WITH_NEWLINES 1 linhas exportadas . . exportando tabela SQLT$_GV$SYSTEM_PARAMETER 346 linhas exportadas . . exportando tabela SQLT$_LOG 1104 linhas exportadas . . exportando tabela SQLT$_METADATA 18 linhas exportadas . . exportando tabela SQLT$_NLS_DATABASE_PARAMETERS 20 linhas exportadas . . exportando tabela SQLT$_OUTLINE_DATA 56 linhas exportadas . . exportando tabela SQLT$_PLAN_EXTENSION 12 linhas exportadas . . exportando tabela SQLT$_PLAN_INFO 26 linhas exportadas . . exportando tabela SQLT$_SQL_PLAN_TABLE 3 linhas exportadas . . exportando tabela SQLT$_SQL_SHARED_CURSOR_D 1 linhas exportadas . . exportando tabela SQLT$_STGTAB_SQLSET 6 linhas exportadas . . exportando tabela SQLT$_V$SESSION_FIX_CONTROL 652 linhas exportadas . . exportando tabela SQLT$_WRI$_ADV_TASKS 2 linhas exportadas . . exportando tabela SQLT$_WRI$_OPTSTAT_AUX_HISTORY 45 linhas exportadas ExportaþÒo encerrada com sucesso, sem advertÛncias. 'chmod' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. adding: sqlt_s71191_exp.dmp (164 bytes security) (deflated 84%) adding: sqlt_s71191_import.sh (164 bytes security) (deflated 35%) adding: sqlt_s71191_exp2.dmp (164 bytes security) (deflated 78%) adding: sqlt_s71191_exp.log (164 bytes security) (deflated 80%) adding: sqlt_s71191_exp2.log (164 bytes security) (deflated 43%) adding: sqlt_s71191_export_driver.sql (164 bytes security) (deflated 68%) zip warning: error deleting sqlt_s71191_export_driver.sql adding: sqlt_s71191_export_parfile.txt (164 bytes security) (deflated 73%) adding: sqlt_s71191_export_parfile2.txt (164 bytes security) (deflated 34%) ... getting sqlt_s71191_tc_sql.sql out of sqlt repository ... ... getting q.sql out of sqlt repository ... ... getting sqlt_s71191_tc_script.sql out of sqlt repository ... ### tkprof commands below may error out with "could not open trace file". disregard error. TKPROF: Release 11.2.0.3.0 - Development on Seg Out 7 13:21:01 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. could not open trace file C:oraclediagrdbmsorclorcltrace*_ora_*_S71191_SQLT_TRACE.trc TKPROF: Release 11.2.0.3.0 - Development on Seg Out 7 13:21:01 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. could not open trace file C:oraclediagrdbmsorclorcltrace*_ora_*_S71191_SQLT_TRACE.trc ### copy command below will error out on linux and unix. disregard error. C:oraclediagrdbmsorclorcltraceorcl_ora_23820_S71191_SQLT_TRACE.trc 1 arquivo(s) copiado(s). ### tkprof commands below may error out with "could not open trace file". disregard error. TKPROF: Release 11.2.0.3.0 - Development on Seg Out 7 13:21:05 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. TKPROF: Release 11.2.0.3.0 - Development on Seg Out 7 13:21:13 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. ### tkprof commands below may error out with "could not open trace file". disregard error. TKPROF: Release 11.2.0.3.0 - Development on Seg Out 7 13:21:22 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. could not open trace file *_ora_*_S71191_SQLT_TRACE.trc TKPROF: Release 11.2.0.3.0 - Development on Seg Out 7 13:21:22 2013 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. could not open trace file *_ora_*_S71191_SQLT_TRACE.trc adding: sqlt_s71191_sqlt_tkprof_nosort.txt (164 bytes security) (deflated 91%) adding: sqlt_s71191_sqlt_tkprof_sort.txt (164 bytes security) (deflated 90%) updating: alert_orcl.log (136 bytes security) (deflated 85%) adding: SPFILEORCL.ORA (136 bytes security) (deflated 76%) zip warning: name not matched: $ORACLE_HOME/cfgtoollogs/opatch/opatch* zip error: Nothing to do! (sqlt_s71191_opatch.zip) ### chmod command below will error out on windows. disregard error. 'chmod' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. adding: sqlt_s71191_system_stats.sql (164 bytes security) (deflated 51%) adding: sqlt_s71191_set_cbo_env.sql (164 bytes security) (deflated 78%) adding: sqlt_s71191_metadata1.sql (164 bytes security) (deflated 68%) adding: sqlt_s71191_metadata2.sql (164 bytes security) (deflated 67%) adding: q.sql (164 bytes security) (deflated 28%) adding: plan.sql (164 bytes security) (deflated 28%) adding: 10053.sql (164 bytes security) (deflated 8%) adding: flush.sql (164 bytes security) (deflated 5%) adding: tc.sql (164 bytes security) (deflated 17%) adding: sel.sql (164 bytes security) (deflated 41%) adding: sel_aux.sql (164 bytes security) (deflated 34%) adding: install.sql (164 bytes security) (deflated 59%) adding: install.sh (164 bytes security) (deflated 10%) adding: pack_tcx.sql (164 bytes security) (deflated 64%) adding: sqlt_s71191_schema_stats.sql (164 bytes security) (deflated 53%) ### chmod command below will error out on windows. disregard error. 'chmod' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. adding: sqlt_s71191_system_stats.sql (164 bytes security) (deflated 51%) adding: sqlt_s71191_set_cbo_env.sql (164 bytes security) (deflated 78%) adding: sqlt_s71191_metadata.sql (164 bytes security) (deflated 67%) adding: sqlt_s71191_readme.txt (164 bytes security) (deflated 75%) adding: q.sql (164 bytes security) (deflated 28%) adding: plan.sql (164 bytes security) (deflated 28%) adding: 10053.sql (164 bytes security) (deflated 8%) adding: flush.sql (164 bytes security) (deflated 5%) adding: tc.sql (164 bytes security) (deflated 17%) adding: sel.sql (164 bytes security) (deflated 41%) adding: sel_aux.sql (164 bytes security) (deflated 34%) adding: xpress.sql (164 bytes security) (deflated 61%) adding: xpress.sh (164 bytes security) (deflated 11%) adding: setup.sql (164 bytes security) (deflated 43%) adding: readme.txt (164 bytes security) (stored 0%) adding: tc_pkg.sql (164 bytes security) (deflated 53%) adding: sqlt_s71191_purge.sql (164 bytes security) (deflated 31%) adding: sqlt_s71191_restore.sql (164 bytes security) (deflated 43%) adding: sqlt_s71191_del_hgrm.sql (164 bytes security) (deflated 28%) zip warning: name not matched: sqlt_s71191_opatch.zip zip error: Nothing to do! (sqlt_s71191_tc.zip) zip warning: sqlt_s71191_trc.zip not found or empty adding: orcl_ora_23820_s71191_10053.trc (136 bytes security) (deflated 81%) adding: orcl_ora_23820_s71191_10053_i1_c0.trc (136 bytes security) (deflated 80%) adding: orcl_ora_23820_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 87%) adding: orcl_p000_23748_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 61%) adding: orcl_p001_23808_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 59%) adding: orcl_p002_16816_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 58%) adding: orcl_p003_18924_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 58%) adding: orcl_p004_23016_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 58%) adding: orcl_p005_24264_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 57%) adding: orcl_p006_24540_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 57%) adding: orcl_p007_22544_S71191_SQLT_TRACE.trc (136 bytes security) (deflated 58%) adding: sqlt_s71191_10053_explain.trc (164 bytes security) (deflated 81%) adding: sqlt_s71191_10053_i1_c0_extract.trc (164 bytes security) (deflated 80%) zip warning: name not matched: sqltxtract2.log adding: sqltxtract.log (164 bytes security) (deflated 81%) adding: missing_file.txt (164 bytes security) (deflated 15%) zip warning: name not matched: sqltxtract2.log deleting: sqltxtract.log deleting: missing_file.txt zip warning: zip file empty ### ls commands below will error out on windows. disregard error. 'ls' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. 'ls' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. 'ls' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. ### who command below will error out on windows. disregard error. 'who' não é reconhecido como um comando interno ou externo, um programa operável ou um arquivo em lotes. updating: sqlt_s71191_sql_monitor_active_driver.sql (164 bytes security) (deflated 79%) updating: sqlt_s71191_remote_driver.sql (164 bytes security) (deflated 27%) updating: sqlt_s71191_awrrpt_driver.sql (164 bytes security) (deflated 77%) updating: sqlt_s71191_addmrpt_driver.sql (164 bytes security) (deflated 79%) updating: sqlt_s71191_ashrpt_driver.sql (164 bytes security) (deflated 81%) updating: sqlt_s71191_tcb_driver.sql (164 bytes security) (deflated 43%) updating: sqlt_s71191_export_driver.sql (164 bytes security) (deflated 68%) adding: sqlt_s71191_xtract.log (164 bytes security) (deflated 78%) adding: sqltxhost.log (164 bytes security) (deflated 37%) adding: sqlt_s71191_10053_explain.trc (164 bytes security) (deflated 81%) adding: sqlt_s71191_10053_i1_c0_extract.trc (164 bytes security) (deflated 80%) adding: sqlt_s71191_addmrpt_0004.zip (164 bytes security) (stored 0%) adding: sqlt_s71191_ashrpt_0005.zip (164 bytes security) (stored 0%) adding: sqlt_s71191_awrrpt_0004.zip (164 bytes security) (stored 0%) adding: sqlt_s71191_driver.zip (164 bytes security) (stored 0%) adding: sqlt_s71191_lite.html (164 bytes security) (deflated 80%) adding: sqlt_s71191_log.zip (164 bytes security) (stored 0%) adding: sqlt_s71191_main.html (164 bytes security) (deflated 88%) adding: sqlt_s71191_readme.html (164 bytes security) (deflated 74%) adding: sqlt_s71191_sql_detail_active.html (164 bytes security) (deflated 90%) adding: sqlt_s71191_sql_monitor.html (164 bytes security) (deflated 88%) adding: sqlt_s71191_sql_monitor.txt (164 bytes security) (deflated 70%) adding: sqlt_s71191_sql_monitor_active.html (164 bytes security) (deflated 82%) adding: sqlt_s71191_sql_monitor_active_0003.zip (164 bytes security) (stored 0%) adding: sqlt_s71191_sta_report_mem.txt (164 bytes security) (deflated 76%) adding: sqlt_s71191_sta_script_mem.sql (164 bytes security) (deflated 66%) adding: sqlt_s71191_tc.zip (164 bytes security) (stored 0%) adding: sqlt_s71191_tcx.zip (164 bytes security) (stored 0%) adding: sqlt_s71191_tc_script.sql (164 bytes security) (deflated 28%) adding: sqlt_s71191_tc_sql.sql (164 bytes security) (deflated 14%) adding: sqlt_s71191_trc.zip (164 bytes security) (stored 0%) Archive: sqlt_s71191_xtract_8r9k0d8kkvcv1.zip Length Date Time Name --------- ---------- ----- ---- 172594 07/10/2013 13:15 sqlt_s71191_10053_explain.trc 163468 07/10/2013 13:15 sqlt_s71191_10053_i1_c0_extract.trc 7437 07/10/2013 13:18 sqlt_s71191_addmrpt_0004.zip 13952 07/10/2013 13:20 sqlt_s71191_ashrpt_0005.zip 63955 07/10/2013 13:17 sqlt_s71191_awrrpt_0004.zip 8215 07/10/2013 13:21 sqlt_s71191_driver.zip 14791 07/10/2013 13:15 sqlt_s71191_lite.html 1463368 07/10/2013 13:21 sqlt_s71191_log.zip 931946 07/10/2013 13:15 sqlt_s71191_main.html 18001 07/10/2013 13:15 sqlt_s71191_readme.html 70651 07/10/2013 13:15 sqlt_s71191_sql_detail_active.html 24646 07/10/2013 13:15 sqlt_s71191_sql_monitor.html 2564 07/10/2013 13:15 sqlt_s71191_sql_monitor.txt 14444 07/10/2013 13:15 sqlt_s71191_sql_monitor_active.html 7297 07/10/2013 13:15 sqlt_s71191_sql_monitor_active_0003.zip 7948 07/10/2013 13:15 sqlt_s71191_sta_report_mem.txt 1696 07/10/2013 13:15 sqlt_s71191_sta_script_mem.sql 189223 07/10/2013 13:21 sqlt_s71191_tc.zip 38935 07/10/2013 13:21 sqlt_s71191_tcx.zip 429 07/10/2013 13:21 sqlt_s71191_tc_script.sql 65 07/10/2013 13:21 sqlt_s71191_tc_sql.sql 4817025 07/10/2013 13:21 sqlt_s71191_trc.zip --------- ------- 8032650 22 files File sqlt_s71191_xtract_8r9k0d8kkvcv1.zip for 8r9k0d8kkvcv1 has been created. sqlt_s71191_sqldx T CSV 8r9k0d8kkvcv1 Parameter 1: Oracle Pack License (Tuning or Diagnostics) [T|D] (required) Parameter 2: Output Type (HTML or CSV or Both) [H|C|B] (required) Parameter 3: SQL_ID of the SQL to be analyzed (required) Values passed: License: "T" Output : "CSV" SQL_ID : "8r9k0d8kkvcv1" ### ... getting SQL text ... ### ... getting signature ... ### ... getting tables ... ### ... generating dynamic script, please wait ... sqlt_s71191_sqldx_8r9k0d8kkvcv1_driver.sql file has been created. ### ### by sql_id ### 2013-10-07/13:23:36 DBA_ADVISOR_SQLPLANS 2013-10-07/13:23:36 DBA_ADVISOR_SQLSTATS 2013-10-07/13:23:37 DBA_HIST_ACTIVE_SESS_HISTORY 2013-10-07/13:23:37 DBA_HIST_SQLSTAT 2013-10-07/13:23:37 DBA_HIST_SQLTEXT 2013-10-07/13:23:38 DBA_HIST_SQL_PLAN 2013-10-07/13:23:38 DBA_SQLSET_PLANS 2013-10-07/13:23:38 DBA_SQLSET_STATEMENTS 2013-10-07/13:23:39 GV$ACTIVE_SESSION_HISTORY 2013-10-07/13:23:40 GV$SESSION_LONGOPS 2013-10-07/13:23:40 GV$SQL_MONITOR 2013-10-07/13:23:41 GV$SQL_PLAN_MONITOR adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_ADVISOR_SQLPLANS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_ADVISOR_SQLSTATS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_HIST_ACTIVE_SESS_HISTORY.csv (164 bytes security) (deflated 91%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_HIST_SQLSTAT.csv (164 bytes security) (deflated 93%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_HIST_SQLTEXT.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_HIST_SQL_PLAN.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_SQLSET_PLANS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_SQLSET_STATEMENTS.csv (164 bytes security) (deflated 97%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_GVsACTIVE_SESSION_HISTORY.csv (164 bytes security) (deflated 96%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_GVsSESSION_LONGOPS.csv (164 bytes security) (deflated 86%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_GVsSQL_MONITOR.csv (164 bytes security) (deflated 97%) adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_GVsSQL_PLAN_MONITOR.csv (164 bytes security) (deflated 92%) Archive: sqlt_s71191_sqldx_8r9k0d8kkvcv1_csv.zip Length Date Time Name --------- ---------- ----- ---- 855173 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_ADVISOR_SQLPLANS.csv 64400 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_ADVISOR_SQLSTATS.csv 26426 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_HIST_ACTIVE_SESS_HISTORY.csv 21430 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_HIST_SQLSTAT.csv 12174 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_HIST_SQLTEXT.csv 172928 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_HIST_SQL_PLAN.csv 374568 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_SQLSET_PLANS.csv 31176 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_DBA_SQLSET_STATEMENTS.csv 201753 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_GVsACTIVE_SESSION_HISTORY.csv 3537 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_GVsSESSION_LONGOPS.csv 48615 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_GVsSQL_MONITOR.csv 11029 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_GVsSQL_PLAN_MONITOR.csv --------- ------- 1823209 12 files adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_csv.zip (164 bytes security) (stored 0%) Archive: sqlt_s71191_sqldx.zip Length Date Time Name --------- ---------- ----- ---- 35743 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_csv.zip --------- ------- 35743 1 file ### ### by exact signature ### ### ### by force signature ### 2013-10-07/13:23:42 DBA_HIST_ACTIVE_SESS_HISTORY 2013-10-07/13:23:42 DBA_HIST_SQLSTAT 2013-10-07/13:23:43 DBA_SQLSET_PLANS 2013-10-07/13:23:43 DBA_SQLSET_STATEMENTS 2013-10-07/13:23:44 GV$ACTIVE_SESSION_HISTORY 2013-10-07/13:23:45 GV$SQL_MONITOR adding: sqlt_s71191_sqldx_5360570916423475080_force_DBA_HIST_ACTIVE_SESS_HISTORY.csv (164 bytes security) (deflated 93 %) adding: sqlt_s71191_sqldx_5360570916423475080_force_DBA_HIST_SQLSTAT.csv (164 bytes security) (deflated 94%) adding: sqlt_s71191_sqldx_5360570916423475080_force_DBA_SQLSET_PLANS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_5360570916423475080_force_DBA_SQLSET_STATEMENTS.csv (164 bytes security) (deflated 97%) adding: sqlt_s71191_sqldx_5360570916423475080_force_GVsACTIVE_SESSION_HISTORY.csv (164 bytes security) (deflated 97%) adding: sqlt_s71191_sqldx_5360570916423475080_force_GVsSQL_MONITOR.csv (164 bytes security) (deflated 98%) Archive: sqlt_s71191_sqldx_5360570916423475080_force_csv.zip Length Date Time Name --------- ---------- ----- ---- 74506 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_DBA_HIST_ACTIVE_SESS_HISTORY.csv 40681 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_DBA_HIST_SQLSTAT.csv 374568 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_DBA_SQLSET_PLANS.csv 31176 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_DBA_SQLSET_STATEMENTS.csv 1008765 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_GVsACTIVE_SESSION_HISTORY.csv 87507 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_GVsSQL_MONITOR.csv --------- ------- 1617203 6 files adding: sqlt_s71191_sqldx_5360570916423475080_force_csv.zip (164 bytes security) (stored 0%) Archive: sqlt_s71191_sqldx.zip Length Date Time Name --------- ---------- ----- ---- 35743 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_csv.zip 51354 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_csv.zip --------- ------- 87097 2 files ### ### by table ### 2013-10-07/13:23:46 DBA_ALL_TABLES 2013-10-07/13:23:47 DBA_CATALOG 2013-10-07/13:23:47 DBA_COL_COMMENTS 2013-10-07/13:23:48 DBA_CONSTRAINTS 2013-10-07/13:23:49 DBA_CONS_COLUMNS 2013-10-07/13:23:50 DBA_INDEXES 2013-10-07/13:23:51 DBA_IND_COLUMNS 2013-10-07/13:23:51 DBA_IND_STATISTICS 2013-10-07/13:23:54 DBA_LOGSTDBY_NOT_UNIQUE 2013-10-07/13:23:55 DBA_STREAMS_COLUMNS 2013-10-07/13:23:55 DBA_TABLES 2013-10-07/13:23:56 DBA_TAB_COLS 2013-10-07/13:23:57 DBA_TAB_COLUMNS 2013-10-07/13:23:58 DBA_TAB_COMMENTS 2013-10-07/13:23:58 DBA_TAB_STATISTICS 2013-10-07/13:24:00 DBA_TAB_STATS_HISTORY 2013-10-07/13:24:00 DBA_UPDATABLE_COLUMNS adding: sqlt_s71191_sqldx_table_DBA_ALL_TABLES.csv (164 bytes security) (deflated 80%) adding: sqlt_s71191_sqldx_table_DBA_CATALOG.csv (164 bytes security) (deflated 77%) adding: sqlt_s71191_sqldx_table_DBA_COL_COMMENTS.csv (164 bytes security) (deflated 96%) adding: sqlt_s71191_sqldx_table_DBA_CONSTRAINTS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_table_DBA_CONS_COLUMNS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_table_DBA_INDEXES.csv (164 bytes security) (deflated 90%) adding: sqlt_s71191_sqldx_table_DBA_IND_COLUMNS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_table_DBA_IND_STATISTICS.csv (164 bytes security) (deflated 82%) adding: sqlt_s71191_sqldx_table_DBA_LOGSTDBY_NOT_UNIQUE.csv (164 bytes security) (deflated 75%) adding: sqlt_s71191_sqldx_table_DBA_STREAMS_COLUMNS.csv (164 bytes security) (deflated 92%) adding: sqlt_s71191_sqldx_table_DBA_TABLES.csv (164 bytes security) (deflated 80%) adding: sqlt_s71191_sqldx_table_DBA_TAB_COLS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_table_DBA_TAB_COLUMNS.csv (164 bytes security) (deflated 99%) adding: sqlt_s71191_sqldx_table_DBA_TAB_COMMENTS.csv (164 bytes security) (deflated 98%) adding: sqlt_s71191_sqldx_table_DBA_TAB_STATISTICS.csv (164 bytes security) (deflated 82%) adding: sqlt_s71191_sqldx_table_DBA_TAB_STATS_HISTORY.csv (164 bytes security) (deflated 90%) adding: sqlt_s71191_sqldx_table_DBA_UPDATABLE_COLUMNS.csv (164 bytes security) (deflated 89%) Archive: sqlt_s71191_sqldx_table_csv.zip Length Date Time Name --------- ---------- ----- ---- 2691 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_ALL_TABLES.csv 218 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_CATALOG.csv 5623 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_COL_COMMENTS.csv 34682 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_CONSTRAINTS.csv 32808 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_CONS_COLUMNS.csv 5967 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_INDEXES.csv 12581 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_IND_COLUMNS.csv 1488 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_IND_STATISTICS.csv 195 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_LOGSTDBY_NOT_UNIQUE.csv 3061 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_STREAMS_COLUMNS.csv 2490 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_TABLES.csv 85629 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_TAB_COLS.csv 80426 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_TAB_COLUMNS.csv 4236 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_TAB_COMMENTS.csv 1362 07/10/2013 13:23 sqlt_s71191_sqldx_table_DBA_TAB_STATISTICS.csv 2093 07/10/2013 13:24 sqlt_s71191_sqldx_table_DBA_TAB_STATS_HISTORY.csv 1802 07/10/2013 13:24 sqlt_s71191_sqldx_table_DBA_UPDATABLE_COLUMNS.csv --------- ------- 277352 17 files adding: sqlt_s71191_sqldx_table_csv.zip (164 bytes security) (stored 0%) Archive: sqlt_s71191_sqldx.zip Length Date Time Name --------- ---------- ----- ---- 35743 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_csv.zip 51354 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_csv.zip 11117 07/10/2013 13:24 sqlt_s71191_sqldx_table_csv.zip --------- ------- 98214 3 files ### ### by global ### 2013-10-07/13:24:01 DBA_HIST_SNAPSHOT 2013-10-07/13:24:02 GV$PARAMETER2 adding: sqlt_s71191_sqldx_global_DBA_HIST_SNAPSHOT.csv (164 bytes security) (deflated 93%) adding: sqlt_s71191_sqldx_global_GVsPARAMETER2.csv (164 bytes security) (deflated 99%) Archive: sqlt_s71191_sqldx_global_csv.zip Length Date Time Name --------- ---------- ----- ---- 11584 07/10/2013 13:24 sqlt_s71191_sqldx_global_DBA_HIST_SNAPSHOT.csv 2969382 07/10/2013 13:24 sqlt_s71191_sqldx_global_GVsPARAMETER2.csv --------- ------- 2980966 2 files adding: sqlt_s71191_sqldx_global_csv.zip (164 bytes security) (stored 0%) Archive: sqlt_s71191_sqldx.zip Length Date Time Name --------- ---------- ----- ---- 35743 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_csv.zip 51354 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_csv.zip 11117 07/10/2013 13:24 sqlt_s71191_sqldx_table_csv.zip 23828 07/10/2013 13:24 sqlt_s71191_sqldx_global_csv.zip --------- ------- 122042 4 files sqlt_s71191_sqldx_*.zip files have been created. adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_driver.sql (164 bytes security) (deflated 92%) adding: sqldx.log (164 bytes security) (deflated 72%) Archive: sqlt_s71191_sqldx_8r9k0d8kkvcv1_log.zip Length Date Time Name --------- ---------- ----- ---- 53248 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_driver.sql 5924 07/10/2013 13:24 sqldx.log --------- ------- 59172 2 files adding: sqlt_s71191_sqldx_8r9k0d8kkvcv1_log.zip (164 bytes security) (stored 0%) SQLDX files have been created. Archive: sqlt_s71191_sqldx.zip Length Date Time Name --------- ---------- ----- ---- 35743 07/10/2013 13:23 sqlt_s71191_sqldx_8r9k0d8kkvcv1_csv.zip 51354 07/10/2013 13:23 sqlt_s71191_sqldx_5360570916423475080_force_csv.zip 11117 07/10/2013 13:24 sqlt_s71191_sqldx_table_csv.zip 23828 07/10/2013 13:24 sqlt_s71191_sqldx_global_csv.zip 6220 07/10/2013 13:24 sqlt_s71191_sqldx_8r9k0d8kkvcv1_log.zip --------- ------- 128262 5 files adding: sqlt_s71191_sqldx.zip (164 bytes security) (stored 0%) SQLTXTRACT completed. SQL>
Portilho, essa ferramenta é utilizada para análise pelo DBA ou o output é submetido ao MOS para análise?
A ferramenta pode ser utilizada pelo DBA sim, além de ser solicitada pelo MOS.
Em próximos Posts, irei colocar exemplos.