SQLT安装及使用

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

iteye_11495

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

阅读量219

点赞数

文章标签：数据库

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.