SQLT
Version
COL sqlt_version FOR A40;
SELECT
'SQLT version number: '||sqltxadmin.sqlt$a.get_param('tool_version')||CHR(10)||
'SQLT version date : '||sqltxadmin.sqlt$a.get_param('tool_date')||CHR(10)||
'Installation date : '||sqltxadmin.sqlt$a.get_param('install_date') sqlt_version
FROM DUAL
/
Install
Download from 215187.1
Copy zip file to /u01/dba and unzip
This will result in SQLT being installed in /u01/dba/sqlt
cd /u01/dba/sqlt/install
sqlplus / as sysdba
START sqcreate.sql
You will be prompted for:
Connect Identifier e.g. @ORCL1 (this can be left blank unless you are using a PDB)
SQLTXPLAIN password.
SQLTXPLAIN Default Tablespace. e.g. USERS (select from the list); there must be a minimum of 50MB free
SQLTXPLAIN Temporary Tablespace. e.g. TEMP (select from the list).
The user that issued the SQL statement to be analyzed. Add additional SQLT users later by granting them SQLT_USER_ROLE. It is not recommended to use SYS as this user; but in some cases it may be necessary. If you do use SYS you must make this additional manual GRANT:
GRANT INHERIT PRIVILEGES ON USER SYS TO SQLTXADMIN
Licensed Oracle Pack. T for Oracle Tuning & Diagnostic, D for Oracle Diagnostic only or N for none (you must be licensed for any Packs you enable).
Deinstall
cd /u01/dba/sqlt/install
@sqdrop
Usage
For full usage instructions see: SQLT Usage Instructions (Doc ID 1614107.1) Some examples follow...
XTRACT
Login as the user who owns the SQL with the SQLID you want.
cd /u01/dba/sqlt/run
sqlplus user/password
START sqltxtract.sql &SQLID &sqltxplain_password
This will generate a zip file under /u01/dba/sqlt/run.
For an example of how this may be useful see the Troubleshooting section of: fix_control