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:
Once we have the software, we leave it on the machine host and follow the following steps:
- 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 126.96.36.199.0 Production on Thu Feb 6 11:04:53 2020 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Release 188.8.131.52.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:
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
It will show us the available tablespaces and we will have to choose one.
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.
Finally, we will select the type of license.
After these steps the installation will begin.
We see that the SQLTXPLAIN utility has been fully installed.
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.