Scribd
Upload
23 views24 pages

SQLT - Sqltxplain - SQL

SQLT is a tool developed by Oracle Corporation to diagnose the performance of SQL queries. It suggests areas for improvement by analyzing a SQL query's ID. DBAs with minimal tuning experience can use SQLT to read and interpret output, similar to AWR reports. Oracle support engineers use SQLT to diagnose performance issues reported by customers.

Uploaded by

Thu Nhien
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views24 pages

SQLT - Sqltxplain - SQL

SQLT is a tool developed by Oracle Corporation to diagnose the performance of SQL queries. It suggests areas for improvement by analyzing a SQL query's ID. DBAs with minimal tuning experience can use SQLT to read and interpret output, similar to AWR reports. Oracle support engineers use SQLT to diagnose performance issues reported by customers.

Uploaded by

Thu Nhien
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 24

UZMA PARVEEN SQLT

Carlos Sierra

SQLT is a tool (SQLTXPLAIN.SQL) devolved by Carlos Sierra (Oracle Corporation). It is used to diagnose

the performance of quires. It suggests the improvement areas of a sql query by inputting the sql id.

DBA need minimum tuning experience to read and interprets the SQLT outputs, it is like reading AWR

reports. Oracle Support engineers are using this tool to diagnose the performance issues.

Page 1 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

DOWNLOAD SQLT

Download the SQLT from the (MOS) Document 215187.1 (oracle.com) SQLT (SQLTXPLAIN) - Tool
That Helps To Diagnose SQL Statements Performing Poorly.

CREATE DIRECTORY IN LINUX SERVER TO KEEP SQLT SOFTWARE

COPY SQLT TO LINUX SERVER USING WINSCP

Page 2 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

COPY SQLT TO LINUX SERVER USING WINSCP

UNZIP SQLT ON LINUX SERVER

FILE CREATED AFTER UNZIP OF SQLT ON LINUX SERVER

Page 3 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

CHECK IS SQLT INSTALLED ON CDB?

CHECK IS SQLT INSTALLED IN PDB?

Page 4 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

CHECK SQLT USERS CREATED IN CDB OR IN PDB ?

Page 5 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

INSTALL SQLT IN PDB USING SQCREATE.SQL

Page 6 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 7 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 8 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 9 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 10 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 11 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 12 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

FINALLY, SQLT INSTALLED IN PDB

SQLT USERS ALSO CREATED IN PDB

Page 13 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

GRANT INHERIT PRIVILEGES TO SQLT USERS IN PDB

Page 14 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

GET SQLTEXT OR SQLID FROM APPLICATION USER

GET SQLID FROM SQLTEXT

Page 15 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

CONNECT TO PDB AND RUN SQLTXTRACT.SQL WITH << SQLID >>

Page 16 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 17 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 18 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 19 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 20 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

FIND ZIP FILE CREATED AT CURRENT WORKING DIRECTORY

COPY ZIP FILE TO WINDOWS SERVER

UNZIP THE ZIP FILE AT WINDOWS SERVER

Page 21 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

OPEN THE _MAIN.HTML FILE AND ANALYZE IT

Page 22 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

Page 23 of 24 o-dba-g.blogspot.com
UZMA PARVEEN SQLT

THANKYOU !!!!

Page 24 of 24 o-dba-g.blogspot.com

You might also like