Install SQLT
Download the latest SQLT package from below link https://support.oracle.com/epmos/main/downloadattachmentprocessor?parent=DOCUMENT&sourceId=215187.1&attachid=215187.1:SQLT_LATEST&clickstream=yes
Unzip the file
[oracle@exdbadm01 sqlt]$ unzip sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip
Archive: sqlt_10g_11g_12c_18c_19c_5th_June_2020.zip
creating: sqlt/
Execute the install.sql to install SQLT in the database
kish@exdbx<>START /home/oracle/sqlt/sqlt/install/install.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.
Elapsed: 00:00:00.00
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.
Elapsed: 00:00:00.00
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
Define SQLTXPLAIN password (hidden and case sensitive).
Elapsed: 00:00:00.00
Password for user SQLTXPLAIN:
Re-enter password:
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
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
------------------------------ ----------------------------------------
EXAMPLE
USERS
Elapsed: 00:00:00.01
Specify PERMANENT tablespace to be used by SQLTXPLAIN.
Tablespace name is case sensitive.
Default tablespace [UNKNOWN]: EXAMPLE
Elapsed: 00:00:00.00
Password for user SQLTXPLAIN:
Re-enter password:
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
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
------------------------------ ----------------------------------------
EXAMPLE
USERS
Elapsed: 00:00:00.01
Specify PERMANENT tablespace to be used by SQLTXPLAIN.
Tablespace name is case sensitive.
Default tablespace [UNKNOWN]: EXAMPLE
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
... please wait
TABLESPACE
------------------------------
TEMP
Elapsed: 00:00:00.01
Specify TEMPORARY tablespace to be used by SQLTXPLAIN.
Tablespace name is case sensitive.
Temporary tablespace [UNKNOWN]: TEMP
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
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: TEST
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
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]:
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.00
TADOBJ completed.
SQDOLD completed. Ignore errors from this script
adding: 211225001426_01_sqcreate.log (deflated 91%)
Elapsed: 00:00:00.00
TAUTLTEST completed.
adding: 211225001918_09_tautltest.log (deflated 63%)
Elapsed: 00:00:00.00
SQUTLTEST completed.
adding: 211225001918_10_squtltest.log (deflated 63%)
SQLT users must be granted SQLT_USER_ROLE before using this tool.
SQCREATE completed. Installation completed successfully.