SQLT Diagnostic Tool

Tool that helps to diagnose SQL statements performing poorly

SQLT Overview

SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise - ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, schema objects metadata, performance statistics, configuration parameters, and similar elements that influence the performance of the SQL being analyzed.

---

Install Instructions :

Download sqlt_latest.zip to the server and unzip its contents into the staging area .

  During the installation you will be asked to enter values for these parameters:

1. Optional Connect Identifier (mandatory when installing in a Pluggable Database)
In some restricted-access systems you may need to specify a connect identifier like @PROD. If a connect identifier is not needed, enter nothing and just hit the "Enter" key. Entering nothing is the most common setup.
The Connect Identifier is a mandatory parameter when installing SQLT in a Pluggable Database.

2. SQLTXPLAIN password.
Case sensitive in most systems.

3. SQLTXPLAIN Default Tablespace.
Select from a list of available permanent tablespaces which one should be used by SQLTXPLAIN for the SQLT repository. It must have more than 50MB of free space.

4. SQLTXPLAIN Temporary Tablespace.
Select from a list of available temporary tablespaces which one should be used by SQLTXPLAIN for volatile operations and objects.

5. Optional Application User.
This is the user that issued the SQL statement to be analyzed. For example, if this were an EBS system specify APPS, on Siebel you would specify SIEBEL and on People Soft SYSADM. You won't be asked to enter the password for this user. You can add additional SQLT users after the tool is installed, by granting them role SQLT_USER_ROLE.

6. Licensed Oracle Pack. (T, D or N)
You can specify T for Oracle Tuning, D for Oracle Diagnostic or N for none. If T or D is selected, SQLT may include licensed content within the diagnostics files it produces. Default is T. If N is selected, SQLT installs with limited functionality.

/home/oracle/staging/sqlt/install=> sqlplus "/as sysdba"
SQL*Plus: Release 12.1.0.2.0 Production on Wed Jan 17 10:52:15 2018
Copyright (c) 1982, 2014, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> START sqcreate.sql
        zip warning: name not matched: *_sq*.log
zip error: Nothing to do! (SQLT_installation_logs_archive.zip)
        zip warning: name not matched: *_ta*.log
zip error: Nothing to do! (SQLT_installation_logs_archive.zip)
Ignore errors from here until @@@@@ marker as this is to test for NATIVE PLSQL Code Type
@@@@ marker . You may ignore prior errors about NATIVE PLSQL Code Type
old   1: ALTER SESSION SET PLSQL_CODE_TYPE = &&plsql_code_type
new   1: ALTER SESSION SET PLSQL_CODE_TYPE = NATIVE
Session altered.
Specify optional Connect Identifier (as per Oracle Net)
Include "@" symbol, ie. @PROD
If not applicable, enter nothing and hit the "Enter" key.
You *MUST* provide a connect identifier when installing
SQLT in a Pluggable Database in 12c
This connect identifier is only used while exporting SQLT
repository everytime you execute one of the main methods.
Optional Connect Identifier (ie: @PROD):
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Define SQLTXPLAIN password (hidden and case sensitive).
Password for user SQLTXPLAIN:
Re-enter password:
PL/SQL procedure successfully completed.
The next step is to choose the tablespaces to be used by SQLTXPLAIN
The Tablespace name is case sensitive.
Do you want to see the free space of each tablespace [YES]
or is it ok just to show the list of tablespace [NO]?
Type YES or NO [Default NO]:
... please wait
TABLESPACE                     FREE_SPACE_MB
------------------------------ -------------
MGMT_AD4J_TS
MGMT_ECM_DEPOT_TS
MGMT_TABLESPACE
SQLT_DATA
STATSPACK_DATA
USERS
6 rows selected.
Specify PERMANENT tablespace to be used by SQLTXPLAIN.
Tablespace name is case sensitive.
Default tablespace [UNKNOWN]: SQLT_DATA
PL/SQL procedure successfully completed.
... please wait
TABLESPACE
------------------------------
TEMP
Specify TEMPORARY tablespace to be used by SQLTXPLAIN.
Tablespace name is case sensitive.
Temporary tablespace [UNKNOWN]: TEMP
PL/SQL procedure successfully completed.
The main application user of SQLT is the schema
owner that issued the SQL to be analyzed.
For example, on an EBS application you would
enter APPS.
You will not be asked to enter its password.
To add more SQLT users after this installation
is completed simply grant them the SQLT_USER_ROLE
role.
Main application user of SQLT: SYSMAN
 

PL/SQL procedure successfully completed.
SQLT can make extensive use of licensed features
provided by the Oracle Diagnostic and the Oracle
Tuning Packs, including SQL Tuning Advisor (STA),
SQL Monitoring and Automatic Workload Repository
(AWR).
To enable or disable access to these features
from the SQLT tool enter one of the following
values when asked:

"T" if you have license for Diagnostic and Tuning
"D" if you have license only for Oracle Diagnostic
"N" if you do not have these two licenses
Oracle Pack license [T]: N
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
TADOBJ completed.
SQDOLD completed. Ignore errors from this script
  adding: 180117105436_01_sqcreate.log (deflated 90%)

SQCUSR completed. Some errors are expected.
Procedure created.
No errors.
  adding: 180117105913_02_sqcusr.log (deflated 85%)
TAUTLTEST completed.
  adding: 180117105917_09_tautltest.log (deflated 60%)
SQUTLTEST completed.
  adding: 180117105917_10_squtltest.log (deflated 61%)
no rows selected

TACOBJ completed.
  adding: 180117105917_03_tacobj.log (deflated 86%)
SQL> PRO Dropping Libraries for TRCA
Dropping Libraries for TRCA
SQL> SET TERM OFF;
tool_repository_schema: "SQLTXPLAIN"
tool_administer_schema: "SQLTXADMIN"
role_name: "SQLT_USER_ROLE"
Creating Procedures
Creating Package Specs TRCA$G
No errors.
Creating Package Specs TRCA$P
No errors.
Creating Package Specs TRCA$T
No errors.
Creating Package Specs TRCA$I
No errors.
Creating Package Specs TRCA$E
No errors.
Creating Package Specs TRCA$R
No errors.
Creating Package Specs TRCA$X
No errors.
Creating Views
Creating Package Body TRCA$G
No errors.
Creating Package Body TRCA$P
No errors.
Creating Package Body TRCA$T
No errors.
Creating Package Body TRCA$I
No errors.
Creating Package Body TRCA$E
No errors.
Creating Package Body TRCA$R
No errors.
Creating Package Body TRCA$X
No errors.
Creating Grants on Libraries

Tool Version
----------------
12.2.171004

Install Date
----------------
20180117

Directories
--------------------------------------------------------------------------------------------------------------------------------
TRCA$INPUT1(VALID)      /app/oracle/diag/rdbms/cld1prd/cld1prd/trace
TRCA$INPUT2(VALID)      /app/oracle/diag/rdbms/cld1prd/cld1prd/trace
TRCA$STAGE(VALID)       /app/oracle/diag/rdbms/cld1prd/cld1prd/trace
user_dump_dest
background_dump_dest

Libraries
--------------------------------------------------------------------------------------------------------------------------------
VALID PACKAGE TRCA$I /* $Header: 224270.1 tacpkgi.pks 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE TRCA$E /* $Header: 224270.1 tacpkge.pks 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE TRCA$G /* $Header: 224270.1 tacpkgg.pks 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE TRCA$P /* $Header: 224270.1 tacpkgp.pks 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE TRCA$R /* $Header: 224270.1 tacpkgr.pks 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE TRCA$T /* $Header: 224270.1 tacpkgt.pks 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE TRCA$X /* $Header: 224270.1 tacpkgx.pks 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE BODY TRCA$I /* $Header: 224270.1 tacpkgi.pkb 12.1.14 2015/12/06 carlos.sierra mauro.pagano abel.macias@oracle.com
$ */

VALID PACKAGE BODY TRCA$E /* $Header: 224270.1 tacpkge.pkb 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE BODY TRCA$G /* $Header: 224270.1 tacpkgg.pkb 12.1.14 2015/12/06 carlos.sierra mauro.pagano abel.macias@oracle.com
$ */

VALID PACKAGE BODY TRCA$P /* $Header: 224270.1 tacpkgp.pkb 11.4.5.8 2013/05/10 carlos.sierra $ */
VALID PACKAGE BODY TRCA$R /* $Header: 224270.1 tacpkgr.pkb 11.4.5.0 2012/11/21 carlos.sierra $ */
VALID PACKAGE BODY TRCA$T /* $Header: 224270.1 tacpkgt.pkb 12.1.160429 2016/04/29 carlos.sierra abel.macias@oracle.com$ */
VALID PACKAGE BODY TRCA$X /* $Header: 224270.1 tacpkgx.pkb 11.4.5.0 2012/11/21 carlos.sierra $ */
TACPKG completed.

PL/SQL procedure successfully completed.

  adding: 180117105932_04_tacpkg.log (deflated 80%)
SQCOBJ completed. Some errors are expected.
  adding: 180117105955_05_sqcobj.log (deflated 93%)
 

SQLT can make extensive use of licensed features
provided by the Oracle Diagnostic and the Oracle
Tuning Packs, including SQL Tuning Advisor (STA),
SQL Monitoring, Automatic Workload Repository
(AWR) and SQL Tuning Sets (STS).
To enable or disable access to these features
from the SQLT tool enter one of the following
values when asked:

"T" if you have license for Diagnostic and Tuning
"D" if you have license only for Oracle Diagnostic
"N" if you do not have these two licenses

pack_license: "N"
disable_pack_access

PL/SQL procedure successfully completed.

Specify optional Connect Identifier (as per Oracle Net)
Include "@" symbol, ie. @PROD
If not applicable, enter nothing and hit the "Enter" key
connect_identifier: ""

PL/SQL procedure successfully completed.
Table truncated.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Procedure created.
No errors.
Table truncated.
PL/SQL procedure successfully completed.
Procedure dropped.
Commit complete.
SQSEED completed.
  adding: 180117110217_07_sqseed.log (deflated 80%)
... dropping packages for SQLT
... creating package specs for SQLT$A
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$a;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$C
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$c;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$D
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$d;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$E
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$e;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$H
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$h;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$I
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$i;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$M
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$m;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$R
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$r;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$S
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$s;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package specs for SQLT$T
SQL> SHOW ERRORS PACKAGE &&tool_administer_schema..sqlt$t;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating views
... creating package body for SQLT$A
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$a;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$C
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$c;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$D
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$d;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$E
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$e;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$H
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$h;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$I
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$i;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$M
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$R
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$r;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$S
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$s;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
... creating package body for SQLT$T
SQL> SHOW ERRORS PACKAGE BODY &&tool_administer_schema..sqlt$t;
No errors.
SQL> --
SQL> SET TERM ON ECHO OFF;
Creating Grants on Packages ...
LIBRARIES
----------------------------------------------------------------
VALID   PACKAGE      12.2.171004  OSQLT$A
VALID   PACKAGE      12.1.10       SQLT$C
VALID   PACKAGE      12.1.11       SQLT$D
VALID   PACKAGE      12.1.10       SQLT$E
VALID   PACKAGE      12.1.10       SQLT$H
VALID   PACKAGE      12.1.10       SQLT$I
VALID   PACKAGE      12.1.10       SQLT$M
VALID   PACKAGE      12.1.160429   SQLT$R
VALID   PACKAGE      12.1.10       SQLT$S
VALID   PACKAGE      12.1.10       SQLT$T
VALID   PACKAGE      11.4.5.0      TRCA$E
VALID   PACKAGE      11.4.5.0      TRCA$G
VALID   PACKAGE      11.4.5.0      TRCA$I
VALID   PACKAGE      11.4.5.0      TRCA$P
VALID   PACKAGE      11.4.5.0      TRCA$R
VALID   PACKAGE      11.4.5.0      TRCA$T
VALID   PACKAGE      11.4.5.0      TRCA$X
VALID   PACKAGE BODY 12.2.171004  OSQLT$A
VALID   PACKAGE BODY 12.1.14       SQLT$C
VALID   PACKAGE BODY 12.2.171004  OSQLT$D
VALID   PACKAGE BODY 12.1.160429   SQLT$E

LIBRARIES
----------------------------------------------------------------
VALID   PACKAGE BODY 12.1.160429   SQLT$H
VALID   PACKAGE BODY 12.2.171004  OSQLT$I
VALID   PACKAGE BODY 12.2.171004  OSQLT$M
VALID   PACKAGE BODY 12.2.171004  OSQLT$R
VALID   PACKAGE BODY 12.1.10       SQLT$S
VALID   PACKAGE BODY 12.2.171004  OSQLT$T
VALID   PACKAGE BODY 11.4.5.0      TRCA$E
VALID   PACKAGE BODY 12.1.14       TRCA$G
VALID   PACKAGE BODY 12.1.14       TRCA$I
VALID   PACKAGE BODY 11.4.5.8      TRCA$P
VALID   PACKAGE BODY 11.4.5.0      TRCA$R
VALID   PACKAGE BODY 12.1.160429   TRCA$T
VALID   PACKAGE BODY 11.4.5.0      TRCA$X

Deleting CBO statistics for SQLTXPLAIN objects ...

11:03:28    0 sqlt$a: -> delete_sqltxplain_stats
11:03:36    8 sqlt$a: <- delete_sqltxplain_stats
PL/SQL procedure successfully completed.
SQCPKG completed.
  adding: 180117110220_08_sqcpkg.log (deflated 79%)
  TAUTLTEST completed.
  adding: 180117110336_09_tautltest.log (deflated 59%)
SQUTLTEST completed.
  adding: 180117110336_10_squtltest.log (deflated 59%)

SQLT users must be granted SQLT_USER_ROLE before using this tool.

SQCREATE completed. Installation completed successfully.
SQL>

 

 

 

 

 

Execute SQLT for sql id 

In my case the sql which is poorly running belongs to Sysman schema

Here it goes...

SQL> start sqltxtract.sql ahpp2wqmx515j



PL/SQL procedure successfully completed.



Parameter 1:
SQL_ID or HASH_VALUE of the SQL to be extracted (required)



Paremeter 2:
SQLTXPLAIN password (required)

Enter value for 2: stormyDay_2016

PL/SQL procedure successfully completed.



PL/SQL procedure successfully completed.


Value passed:
SQL_ID_OR_HASH_VALUE: "ahpp2wqmx515j"


PL/SQL procedure successfully completed.

***
*** NOTE:
*** If you get error below it means SQLTXPLAIN is not installed:
***   PLS-00201: identifier 'SQLTXADMIN.SQLT$A' must be declared.
*** In such case look for errors in NN_*.log files created during install.
***

***
*** NOTE:
*** If running as SYS in 12c make sure to review sqlt_instructions.html first
***


SQLT_VERSION
----------------------------------------
SQLT version number: 12.2.171004
SQLT version date  : 2017-10-04
Installation date  : 2018-01-17/11:02:17

... please wait ...
  adding: alert_cld1prd.log (deflated 96%)

NOTE:
You used the XTRACT method connected as SYSMAN.

In case of a session disconnect please verify the following:
1. There are no errors in sqltxtract.log.
2. Your SQL ahpp2wqmx515j exists in memory or in AWR.
3. You connected as the application user that issued original SQL.
4. User SYSMAN 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
If running as SYS in 12c make sure to review sqlt_instructions.html first

... getting missing_file.txt out of sqlt repository ...
... getting sqlt_s49332_remote_driver.sql out of sqlt repository ...
  adding: sqlt_s49332_remote_driver.sql (deflated 46%)
... 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_s49332_main.html out of sqlt repository ...
... getting sqlt_s49332_lite.html out of sqlt repository ...
... getting sqlt_s49332_readme.html out of sqlt repository ...
... getting sqlt_s49332_readme.txt out of sqlt repository ...
... getting sqlt_s49332_metadata.sql out of sqlt repository ...
... getting sqlt_s49332_metadata1.sql out of sqlt repository ...
... getting sqlt_s49332_metadata2.sql out of sqlt repository ...
... getting sqlt_s49332_system_stats.sql out of sqlt repository ...
... getting sqlt_s49332_schema_stats.sql out of sqlt repository ...
... getting sqlt_s49332_set_cbo_env.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 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_s49332_10053_explain.trc out of sqlt repository ...
... getting sqlt_s49332_10053_i1_c0_extract.trc out of sqlt repository ...
... getting missing_file.txt out of sqlt repository ...
... getting sqlt_s49332_import.sh out of sqlt repository ...
... getting sqlt_s49332_export_parfile.txt out of sqlt repository ...
... getting sqlt_s49332_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_s49332_purge.sql out of sqlt repository ...
... getting sqlt_s49332_restore.sql out of sqlt repository ...
... getting sqlt_s49332_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 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_s49332_tcb_driver.sql out of sqlt repository ...
        zip warning: name not matched: /app/oracle/diag/rdbms/cld1prd/cld1prd/trace/README.txt
  adding: sqlt_s49332_tcb_dpexp.log (deflated 3%)
  adding: sqlt_s49332_tcb_dpexp.sql (deflated 71%)
  adding: sqlt_s49332_tcb_ol.xml (deflated 82%)
  adding: sqlt_s49332_tcb_prmimp.sql (deflated 53%)
  adding: sqlt_s49332_tcb_README.txt (deflated 57%)
  adding: sqlt_s49332_tcb_sql.xml (deflated 38%)
  adding: sqlt_s49332_tcb_ts.xml (deflated 36%)
  adding: sqlt_s49332_tcb_driver.sql (deflated 51%)
... getting sqlt_s49332_xpand_sql_driver.sql out of sqlt repository ...
... getting sqlt_s49332_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 12.1.0.2.0 - Production on Wed Jan 17 12:00:29 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
. . exporting table                  SQLT$_STATTAB       1579 rows exported
Export terminated successfully without warnings.


Export: Release 12.1.0.2.0 - Production on Wed Jan 17 12:00:34 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8MSWIN1252 character set (possible charset conversion)
Note: grants on tables/views/sequences/roles will not be exported
Note: indexes on tables will not be exported
Note: constraints on tables will not be exported

About to export specified tables via Conventional Path ...
. . exporting table            SQLT$_SQL_STATEMENT          1 rows exported
. . exporting table               SQLT$_AUX_STATS$         13 rows exported
. . exporting table      SQLT$_DBA_AUTOTASK_CLIENT          1 rows exported
. . exporting table  SQLT$_DBA_AUTOTASK_CLIENT_HST         30 rows exported
. . exporting table   SQLT$_DBA_COL_STATS_VERSIONS        365 rows exported
. . exporting table           SQLT$_DBA_COL_USAGE$         23 rows exported
. . exporting table          SQLT$_DBA_CONSTRAINTS         22 rows exported
. . exporting table  SQLT$_DBA_HISTGRM_STATS_VERSN       4090 rows exported
. . exporting table          SQLT$_DBA_IND_COLUMNS          9 rows exported
. . exporting table       SQLT$_DBA_IND_STATISTICS          8 rows exported
. . exporting table   SQLT$_DBA_IND_STATS_VERSIONS         22 rows exported
. . exporting table              SQLT$_DBA_INDEXES          8 rows exported
. . exporting table              SQLT$_DBA_OBJECTS         13 rows exported
. . exporting table   SQLT$_DBA_OPTSTAT_OPERATIONS       5229 rows exported
. . exporting table             SQLT$_DBA_SEGMENTS          8 rows exported
. . exporting table             SQLT$_DBA_TAB_COLS         69 rows exported
. . exporting table       SQLT$_DBA_TAB_HISTOGRAMS       1585 rows exported
. . exporting table    SQLT$_DBA_TAB_MODIFICATIONS          3 rows exported
. . exporting table       SQLT$_DBA_TAB_STATISTICS          3 rows exported
. . exporting table   SQLT$_DBA_TAB_STATS_VERSIONS         11 rows exported
. . exporting table               SQLT$_DBA_TABLES          3 rows exported
. . exporting table          SQLT$_DBA_TABLESPACES          5 rows exported
. . exporting table               SQLT$_DBMS_XPLAN        214 rows exported
. . exporting table        SQLT$_GV$NLS_PARAMETERS         19 rows exported
. . exporting table     SQLT$_GV$OBJECT_DEPENDENCY          4 rows exported
. . exporting table            SQLT$_GV$PARAMETER2        389 rows exported
. . exporting table         SQLT$_GV$PARAMETER_CBO        434 rows exported
. . exporting table            SQLT$_GV$PQ_SYSSTAT         20 rows exported
. . exporting table    SQLT$_GV$PX_PROCESS_SYSSTAT         15 rows exported
. . exporting table                   SQLT$_GV$SQL          1 rows exported
. . exporting table     SQLT$_GV$SQL_OPTIMIZER_ENV          9 rows exported
. . exporting table              SQLT$_GV$SQL_PLAN          7 rows exported
. . exporting table     SQLT$_GV$SQL_SHARED_CURSOR          1 rows exported
. . exporting table          SQLT$_GV$SQL_WORKAREA          1 rows exported
. . exporting table               SQLT$_GV$SQLAREA          1 rows exported
. . exporting table     SQLT$_GV$SQLAREA_PLAN_HASH          1 rows exported
. . exporting table              SQLT$_GV$SQLSTATS          1 rows exported
. . exporting table    SQLT$_GV$SQLSTATS_PLAN_HASH          1 rows exported
. . exporting table SQLT$_GV$SQLTEXT_WITH_NEWLINES          4 rows exported
. . exporting table      SQLT$_GV$SYSTEM_PARAMETER        386 rows exported
. . exporting table                      SQLT$_LOG       1243 rows exported
. . exporting table                 SQLT$_METADATA         24 rows exported
. . exporting table  SQLT$_NLS_DATABASE_PARAMETERS         20 rows exported
. . exporting table             SQLT$_OUTLINE_DATA         72 rows exported
. . exporting table           SQLT$_PLAN_EXTENSION         14 rows exported
. . exporting table                SQLT$_PLAN_INFO         12 rows exported
. . exporting table           SQLT$_SQL_PLAN_TABLE          7 rows exported
. . exporting table                  SQLT$_STATTAB       1579 rows exported
. . exporting table    SQLT$_V$SESSION_FIX_CONTROL       1099 rows exported
Export terminated successfully without warnings.

  adding: sqlt_s49332_exp.dmp (deflated 92%)
  adding: sqlt_s49332_import.sh (deflated 34%)
  adding: sqlt_s49332_exp2.dmp (deflated 93%)
  adding: sqlt_s49332_exp.log (deflated 77%)
  adding: sqlt_s49332_exp2.log (deflated 41%)
  adding: sqlt_s49332_export_driver.sql (deflated 67%)
  adding: sqlt_s49332_export_parfile.txt (deflated 73%)
  adding: sqlt_s49332_export_parfile2.txt (deflated 32%)
... getting sqlt_s49332_tc_sql.sql out of sqlt repository ...
... getting q.sql out of sqlt repository ...
... getting sqlt_s49332_tc_script.sql out of sqlt repository ...
### tkprof commands below may error out with "could not open trace file". disregard error.

TKPROF: Release 12.1.0.2.0 - Development on Wed Jan 17 12:00:38 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.



TKPROF: Release 12.1.0.2.0 - Development on Wed Jan 17 12:00:38 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


### copy command below will error out on linux and unix. disregard error.
/bin/bash: copy: command not found
### tkprof commands below may error out with "could not open trace file". disregard error.

TKPROF: Release 12.1.0.2.0 - Development on Wed Jan 17 12:00:39 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


could not open trace file /app/oracle/diag/rdbms/cld1prd/cld1prd/trace/S49332_SQLT_TRACE.trc

TKPROF: Release 12.1.0.2.0 - Development on Wed Jan 17 12:00:39 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


could not open trace file /app/oracle/diag/rdbms/cld1prd/cld1prd/trace/S49332_SQLT_TRACE.trc
### tkprof commands below may error out with "could not open trace file". disregard error.
cat: *_ora_*_S49332_SQLT_TRACE*.trc: No such file or directory

TKPROF: Release 12.1.0.2.0 - Development on Wed Jan 17 12:00:39 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


cat: *_ora_*_S49332_SQLT_TRACE*.trc: No such file or directory

TKPROF: Release 12.1.0.2.0 - Development on Wed Jan 17 12:00:39 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.


  adding: sqlt_s49332_sqlt_tkprof_nosort.txt (deflated 93%)
  adding: sqlt_s49332_sqlt_tkprof_sort.txt (deflated 91%)
  adding: sqlt_s49332_sqlt_tkprof_tnosort.txt (deflated 60%)
  adding: sqlt_s49332_sqlt_tkprof_tsort.txt (deflated 61%)
updating: alert_cld1prd.log (deflated 96%)
  adding: spfilecld1prd.ora (deflated 80%)
  adding: opatch2016-01-13_15-12-56PM_1.log (deflated 94%)
  adding: opatch2016-01-13_15-30-17PM_1.log (deflated 72%)
  adding: opatch2016-01-13_15-31-56PM_1.log (deflated 73%)
  adding: opatch2016-01-13_22-00-19PM_1.log (deflated 73%)
  adding: opatch2016-01-13_22-02-22PM_1.log (deflated 72%)
  adding: opatch2016-01-14_08-40-02AM_1.log (deflated 72%)
  adding: opatch2016-01-14_09-30-53AM_1.log (deflated 72%)
  adding: opatch2016-01-14_10-01-46AM_1.log (deflated 72%)
  adding: opatch2016-01-14_10-17-01AM_1.log (deflated 73%)
  adding: opatch2016-01-20_11-22-58AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-25-07AM_1.log (deflated 93%)
  adding: opatch2016-01-20_11-30-41AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-31-06AM_1.log (deflated 73%)
  adding: opatch2016-01-20_11-31-10AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-31-14AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-31-18AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-31-21AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-31-25AM_1.log (deflated 73%)
  adding: opatch2016-01-20_11-31-28AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-31-32AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-31-36AM_1.log (deflated 73%)
  adding: opatch2016-01-20_11-31-39AM_1.log (deflated 72%)
  adding: opatch2016-01-20_11-31-42AM_1.log (deflated 73%)
  adding: opatch2016-01-20_11-31-46AM_1.log (deflated 72%)
  adding: opatch2016-01-22_10-02-55AM_1.log (deflated 72%)
  adding: opatch2016-01-22_10-04-28AM_1.log (deflated 72%)
  adding: opatch2016-01-22_10-26-03AM_1.log (deflated 72%)
  adding: opatch2016-01-22_10-27-59AM_1.log (deflated 72%)
  adding: opatch2016-01-22_10-43-58AM_1.log (deflated 72%)
  adding: opatch2016-01-22_10-58-47AM_1.log (deflated 75%)
  adding: opatch2016-01-22_11-00-37AM_1.log (deflated 72%)
  adding: opatch2016-01-22_11-01-24AM_1.log (deflated 73%)
  adding: opatch2016-01-22_11-01-28AM_1.log (deflated 72%)
  adding: opatch2016-01-22_11-01-32AM_1.log (deflated 72%)
  adding: opatch2016-01-22_11-01-36AM_1.log (deflated 72%)
  adding: opatch2016-01-22_11-01-39AM_1.log (deflated 73%)
  adding: opatch2016-01-22_11-01-43AM_1.log (deflated 72%)
  adding: opatch2016-01-22_11-01-46AM_1.log (deflated 72%)
  adding: opatch2016-01-22_11-01-50AM_1.log (deflated 73%)
  adding: opatch2016-01-22_11-01-53AM_1.log (deflated 72%)
  adding: opatch2016-01-22_11-01-58AM_1.log (deflated 72%)
  adding: opatch2016-01-22_11-02-01AM_1.log (deflated 73%)
  adding: opatch2016-01-22_11-02-05AM_1.log (deflated 73%)
  adding: opatch2016-01-22_22-01-31PM_1.log (deflated 73%)
  adding: opatch2016-01-22_22-07-21PM_1.log (deflated 73%)
  adding: opatch2016-08-11_08-34-43AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-04-43AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-05-11AM_1.log (deflated 73%)
  adding: opatch2016-11-02_11-05-51AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-09-19AM_1.log (deflated 78%)
  adding: opatch2016-11-02_11-32-27AM_1.log (deflated 71%)
  adding: opatch2016-11-02_11-34-47AM_1.log (deflated 89%)
  adding: opatch2016-11-02_11-37-32AM_1.log (deflated 95%)
  adding: opatch2016-11-02_11-41-23AM_1.log (deflated 69%)
  adding: opatch2016-11-02_11-44-16AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-45-58AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-46-08AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-46-15AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-46-23AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-46-31AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-46-38AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-46-46AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-46-55AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-47-03AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-47-10AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-47-18AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-47-25AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-47-33AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-47-41AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-47-48AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-47-57AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-48-05AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-48-12AM_1.log (deflated 72%)
  adding: opatch2016-11-02_11-48-57AM_1.log (deflated 69%)
  adding: opatch2016-11-02_16-19-10PM_1.log (deflated 72%)
  adding: opatch2016-11-03_09-21-35AM_1.log (deflated 72%)
  adding: opatch2016-11-04_08-17-58AM_1.log (deflated 72%)
  adding: opatch2016-11-04_08-49-48AM_1.log (deflated 72%)
  adding: opatch2016-11-04_09-01-46AM_1.log (deflated 72%)
  adding: opatch2016-11-04_09-15-59AM_1.log (deflated 72%)
  adding: opatch2016-11-18_06-25-31AM_1.log (deflated 73%)
  adding: opatch2017-01-05_10-03-49AM_1.log (deflated 72%)
  adding: opatch2017-07-13_06-17-53AM_1.log (deflated 72%)
  adding: opatch2017-08-18_13-25-41PM_1.log (deflated 73%)
  adding: opatch2017-12-06_10-29-15AM_1.log (deflated 72%)
  adding: opatch2017-12-07_10-58-30AM_1.log (deflated 69%)
  adding: opatch2017-12-07_12-06-24PM_1.log (deflated 71%)
  adding: opatch2017-12-07_12-22-21PM_1.log (deflated 76%)
  adding: opatch2017-12-07_12-24-37PM_1.log (deflated 76%)
  adding: opatch2017-12-07_12-55-42PM_1.log (deflated 71%)
  adding: opatch2017-12-07_14-23-04PM_1.log (deflated 90%)
  adding: opatch2017-12-07_14-30-30PM_1.log (deflated 72%)
  adding: opatch2017-12-07_14-30-48PM_1.log (deflated 72%)
  adding: opatch2017-12-07_14-34-43PM_1.log (deflated 71%)
  adding: opatch2017-12-07_14-39-35PM_1.log (deflated 98%)
  adding: opatch2017-12-07_15-05-04PM_1.log (deflated 98%)
  adding: opatch2017-12-07_15-09-49PM_1.log (deflated 73%)
  adding: opatch2017-12-08_14-35-18PM_1.log (deflated 81%)
  adding: opatch2017-12-08_14-36-29PM_1.log (deflated 81%)
  adding: opatch2017-12-08_14-36-37PM_1.log (deflated 76%)
  adding: opatch2018-01-02_14-30-06PM_1.log (deflated 73%)
  adding: opatch2018-01-02_14-33-25PM_1.log (deflated 73%)
  adding: opatch2018-01-02_14-51-47PM_1.log (deflated 73%)
  adding: opatch2018-01-03_12-49-32PM_1.log (deflated 71%)
  adding: opatch2018-01-03_12-50-47PM_1.log (deflated 72%)
  adding: opatch2018-01-03_12-54-19PM_1.log (deflated 72%)
  adding: opatch2018-01-03_12-54-30PM_1.log (deflated 72%)
  adding: opatch2018-01-03_13-04-23PM_1.log (deflated 98%)
  adding: opatch2018-01-03_15-37-43PM_1.log (deflated 73%)
  adding: opatch2018-01-04_10-19-43AM_1.log (deflated 73%)
  adding: opatch2018-01-04_10-27-58AM_1.log (deflated 90%)
  adding: opatch2018-01-04_10-29-57AM_1.log (deflated 96%)
  adding: opatch2018-01-04_13-23-05PM_1.log (deflated 73%)
  adding: opatch2018-01-04_13-23-20PM_1.log (deflated 73%)
  adding: opatch2018-01-04_13-24-23PM_1.log (deflated 73%)
  adding: opatch2018-01-04_13-24-29PM_1.log (deflated 73%)
  adding: opatch2018-01-04_13-24-35PM_1.log (deflated 73%)
  adding: opatch2018-01-04_13-24-41PM_1.log (deflated 73%)
  adding: opatch2018-01-04_14-00-27PM_1.log (deflated 71%)
  adding: opatch2018-01-08_12-59-24PM_1.log (deflated 71%)
  adding: opatch_history.txt (deflated 95%)
### chmod command below will error out on windows. disregard error.
  adding: sqlt_s49332_system_stats.sql (deflated 47%)
  adding: sqlt_s49332_set_cbo_env.sql (deflated 78%)
  adding: sqlt_s49332_metadata1.sql (deflated 65%)
  adding: sqlt_s49332_metadata2.sql (deflated 66%)
  adding: q.sql (deflated 46%)
  adding: plan.sql (deflated 27%)
  adding: 10053.sql (deflated 22%)
  adding: flush.sql (deflated 5%)
  adding: tc.sql (deflated 17%)
  adding: sel.sql (deflated 40%)
  adding: sel_aux.sql (deflated 34%)
  adding: install.sql (deflated 58%)
  adding: install.sh (deflated 10%)
  adding: pack_tcx.sql (deflated 64%)
  adding: sqlt_s49332_schema_stats.sql (deflated 55%)
### chmod command below will error out on windows. disregard error.
  adding: sqlt_s49332_system_stats.sql (deflated 47%)
  adding: sqlt_s49332_set_cbo_env.sql (deflated 78%)
  adding: sqlt_s49332_metadata.sql (deflated 64%)
  adding: sqlt_s49332_readme.txt (deflated 75%)
  adding: q.sql (deflated 46%)
  adding: plan.sql (deflated 27%)
  adding: 10053.sql (deflated 22%)
  adding: flush.sql (deflated 5%)
  adding: tc.sql (deflated 17%)
  adding: sel.sql (deflated 40%)
  adding: sel_aux.sql (deflated 34%)
  adding: xpress.sql (deflated 60%)
  adding: xpress.sh (deflated 11%)
  adding: setup.sql (deflated 43%)
  adding: readme.txt (stored 0%)
  adding: tc_pkg.sql (deflated 53%)
  adding: sqlt_s49332_purge.sql (deflated 30%)
  adding: sqlt_s49332_restore.sql (deflated 43%)
  adding: sqlt_s49332_del_hgrm.sql (deflated 26%)
  adding: sqlt_s49332_opatch.zip (stored 0%)
        zip warning: sqlt_s49332_trc.zip not found or empty
  adding: cld1prd_ora_26814_s49332_10053_i1_c0.trc (deflated 80%)
  adding: cld1prd_ora_26814_s49332_10053.trc (deflated 82%)
  adding: sqlt_s49332_10053_explain.trc (deflated 82%)
  adding: sqlt_s49332_10053_i1_c0_extract.trc (deflated 80%)
        zip warning: name not matched: sqltxtract2.log
  adding: sqltxtract.log (deflated 80%)
  adding: missing_file.txt (deflated 16%)
        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.
### who command below will error out on windows. disregard error.
  adding: sqlt_s49332_xpand_sql_driver.sql (deflated 44%)
  adding: sqlt_s49332_cell_state_begin_and_end.txt (deflated 12%)
  adding: sqlt_s49332_cell_state_begin.txt (stored 0%)
  adding: sqlt_s49332_cell_state_end.txt (stored 0%)
  adding: sqlt_s49332_xtract.log (deflated 77%)
  adding: sqltxhost.log (deflated 56%)
  adding: sqlt_s49332_10053_explain.trc (deflated 82%)
  adding: sqlt_s49332_10053_i1_c0_extract.trc (deflated 80%)
  adding: sqlt_s49332_cell_state.zip (stored 0%)
  adding: sqlt_s49332_driver.zip (stored 0%)
  adding: sqlt_s49332_lite.html (deflated 84%)
  adding: sqlt_s49332_log.zip (stored 0%)
  adding: sqlt_s49332_main.html (deflated 88%)
  adding: sqlt_s49332_opatch.zip (stored 0%)
  adding: sqlt_s49332_readme.html (deflated 74%)
  adding: sqlt_s49332_tcb.zip (stored 0%)
  adding: sqlt_s49332_tc_script.sql (deflated 46%)
  adding: sqlt_s49332_tc_sql.sql (deflated 35%)
  adding: sqlt_s49332_tcx.zip (stored 0%)
  adding: sqlt_s49332_tc.zip (stored 0%)
  adding: sqlt_s49332_trc.zip (stored 0%)
  adding: sqlt_s49332_xpand.sql (deflated 45%)
Archive:  sqlt_s49332_xtract_ahpp2wqmx515j.zip
  Length      Date    Time    Name
---------  ---------- -----   ----
   256929  01-17-2018 12:00   sqlt_s49332_10053_explain.trc
   189565  01-17-2018 12:00   sqlt_s49332_10053_i1_c0_extract.trc
      710  01-17-2018 12:00   sqlt_s49332_cell_state.zip
     4223  01-17-2018 12:00   sqlt_s49332_driver.zip
    25768  01-17-2018 12:00   sqlt_s49332_lite.html
  1574575  01-17-2018 12:00   sqlt_s49332_log.zip
  1661314  01-17-2018 12:00   sqlt_s49332_main.html
   259661  01-17-2018 12:00   sqlt_s49332_opatch.zip
    14232  01-17-2018 12:00   sqlt_s49332_readme.html
     4749  01-17-2018 12:00   sqlt_s49332_tcb.zip
     1081  01-17-2018 12:00   sqlt_s49332_tc_script.sql
      195  01-17-2018 12:00   sqlt_s49332_tc_sql.sql
    72444  01-17-2018 12:00   sqlt_s49332_tcx.zip
   730234  01-17-2018 12:00   sqlt_s49332_tc.zip
   168127  01-17-2018 12:00   sqlt_s49332_trc.zip
      288  01-17-2018 12:00   sqlt_s49332_xpand.sql
---------                     -------
  4964095                     16 files

File sqlt_s49332_xtract_ahpp2wqmx515j.zip for ahpp2wqmx515j has been created.
sqlt_s49332_sqldx
N
CSV
ahpp2wqmx515j

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: "N"
Output : "CSV"
SQL_ID : "ahpp2wqmx515j"


### ... getting SQL text ...


### ... getting signature ...


### ... getting tables ...


### ... generating dynamic script, please wait ...


sqlt_s49332_sqldx_ahpp2wqmx515j_driver.sql file has been created.


sqlt_s49332_sqldx_*.zip files have been created.
  adding: sqlt_s49332_sqldx_ahpp2wqmx515j_driver.sql (deflated 55%)
  adding: sqldx.log (deflated 59%)

Archive:  sqlt_s49332_sqldx_ahpp2wqmx515j_log.zip
  Length      Date    Time    Name
---------  ---------- -----   ----
     1221  01-17-2018 12:00   sqlt_s49332_sqldx_ahpp2wqmx515j_driver.sql
     3143  01-17-2018 12:00   sqldx.log
---------                     -------
     4364                     2 files

  adding: sqlt_s49332_sqldx_ahpp2wqmx515j_log.zip (stored 0%)


SQLDX files have been created.

Archive:  sqlt_s49332_sqldx.zip
  Length      Date    Time    Name
---------  ---------- -----   ----
     2225  01-17-2018 12:00   sqlt_s49332_sqldx_ahpp2wqmx515j_log.zip
---------                     -------
     2225                     1 file

  adding: sqlt_s49332_sqldx.zip (stored 0%)

#####
The SQLT has collected information and place it in a repository in the database, exported it and zip it.
The collected info can be purged from the database using the following file :
... getting sqlt_s49332_purge.sql out of sqlt repository ...

SQLTXTRACT completed.