SQLTXTRACT and SQLTXPLAIN. How are they installed?

GPS Open Source News

Hello friends!!! This week we return with an entry on ORACLE. Have you had problems with bugs, execution plans… and since support_oracle have you requested information having to install SQLTXTRACT and SQLTXPLAIN?

Today we will see how to install this tool and thus, collect the information! Let’s get to it!

Installing SQLTXTRACT Prerequisites

In order to use SQLTXTRACT, we first need to download the SQLTXPLAIN package. We will do it through the web:

https://support.oracle.com/epmos/main/downloadattachmentprocessor?parent=DOCUMENT&sourceId=1614107.1&attachid=215187.1:SQLT_LATEST&clickstream=yes

Once we have the software, we leave it on the machine host and follow the following steps:

  1. We unzip the software:
 [oradev@ORA12CL ~]$ unzip sqlt_10g_11g_12c_18c_19c_29th_January_2020.zip
  .
  .
 inflating: sqlt/utl/xplore/sys_views.sql
 inflating: sqlt/utl/xplore/uninstall.sql
 inflating: sqlt/utl/xplore/user_objects.sql
 inflating: sqlt/utl/xplore/xplore.pkb
 inflating: sqlt/utl/xplore/xplore.pks
 [oradev@ORA12CL ~]$
 [oradev@ORA12CL ~]$ ls -lrth sqlt
 total 120K
 drwxr-xr-x 3 oradev oinstall 4.0K Jan 29 17:38 input
 drwxr-xr-x 2 oradev oinstall 4.0K Jan 29 17:38 doc
 drwxr-xr-x 2 oradev oinstall 4.0K Jan 29 17:38 install
 drwxr-xr-x 2 oradev oinstall 4.0K Jan 29 17:38 run
 drwxr-xr-x 7 oradev oinstall 4.0K Jan 29 17:38 utl
 -rw-r--r-- 1 oradev oinstall 58K Feb 5 17:44 sqlt_instructions.html
 -rw-r--r-- 1 oradev oinstall 39K Feb 5 17:46 sqlt_instructions.txt 

2. Go to the install directory to install the software.

 [oradev@ORA12CL ~]$ cd sqlt/install
 [oradev@ORA12CL install]$ sqlplus / as sysdba
  
 SQL*Plus: Release 11.2.0.4.0 Production on Thu Feb 6 11:04:53 2020
  
 Copyright (c) 1982, 2013, Oracle. All rights reserved.
  
  
 Connected to:
 Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
 With the Automatic Storage Management option
  
 SQL> START sqcreate.sql 

After running the sqcreate.sql. The assistant will ask us the following questions:

SQLTXTRACT 1

We leave blank and give to Intro. Later we must define a password.

Once the password is defined, the next step is to specify the path where we are going to save the resulting data. We give to YES

SQLTXTRACT 2

It will show us the available tablespaces and we will have to choose one.

SQLTXTRACT 3

Later, we will have to indicate a temporary tablespace

We now select the main schema on which we are going to collect the data of the query.

SQLTXTRACT 4

Finally, we will select the type of license.

After these steps the installation will begin.

SQLTXTRACT 4

We see that the SQLTXPLAIN utility has been fully installed.

Using SQLXTRACT

Once we have installed SQLTXPLAIN, we will be able to run SQLXTRACT. In this way we can collect information for Oracle Support. To use the tool simply run the following commands:

SQL > START sqltxtract.sql 93yvxy6qxwdar ********** 

The package you have generated, we will upload it to later to Oracle Support.

If you want to learn more about Oracle or the world of databases, Linux and Open Source, do not forget to subscribe to our newsletter!

With a single email per month you will be up to date with everything we publish and news from this world of databases. You can unsubscribe whenever you want without problems.

Comments are closed.