SQLT – Geração do Relatório

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>

2 comments

    1. A ferramenta pode ser utilizada pelo DBA sim, além de ser solicitada pelo MOS.
      Em próximos Posts, irei colocar exemplos.

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.