Posted by 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.