SQLT安装及使用

最新推荐文章于 2023-07-07 08:59:11 发布

最新推荐文章于 2023-07-07 08:59:11 发布 · 263 阅读

文章标签：

#数据库

本文指导如何安装SQLT，配置环境，运行SQLT进行数据提取，并将生成的报告上传至指定系统，以获取数据库优化建议。

note:215187.1
1). Install SQLT

$ unzip sqlt.zip
$ cd sqlt/install
$ sqlplus / as sysdba
SQL> START sqcreate.sql
Password for user SQLTXPLAIN: <password of using sqlt>
Default tablespace [UNKNOWN]:USERS
Temporary tablespace [UNKNOWN]: TEMP
Main application user of SQLT: <application user>
Oracle Pack license [T]:T

2). Run it
$ cd sqlt
$ sqlplus feng/feng
SQL> START run/sqltxtract.sql <sql_id>

3). Upload the generated sqlt_s*.zip file to this SR
$ ls sqlt_s*
eg.
sqlt_s45616_xtract_1516217795.zip

The SQLT report will give us some recommendation which might be helpful.