SQLT 安装使用示例

SQLT的说明和下载参考文章：https://blog.csdn.net/u010692693/article/details/102976993

SQLT的常见问题参考文章： https://blog.csdn.net/u010692693/article/details/102981665

SQLT的使用说明参考文章： https://blog.csdn.net/u010692693/article/details/103095577

下面是SQLT安装和使用的示例：

安装SQLT

sqlplus / as sysdba

SQL> create tablespace SQLT datafile '/oradata/orcl/sqlt01.dbf' size 50M;
SQL> create user sqlt identified by sqlt;
SQL> grant SQLT_USER_ROLE to sqlt;
   

SQL> start sqlt/install/sqdrop.sql    --卸载脚本

SQL> start sqlt/install/sqcreate.sql  --安装脚本

Optional Connect Identifier (ie: @PROD): 
Password for user SQLTXPLAIN: 
Re-enter password: 
Type YES or NO [Default NO]: 
Default tablespace [UNKNOWN]: SQLT
Temporary tablespace [UNKNOWN]: TEMP
Main application user of SQLT: sqlt
Oracle Pack license [T]: 

使用SQLT的 XTRACT 功能

select /*+ no_index(t2 idx_t2) */ * from t2 where n=1;
select * from table(dbms_xplan.display_cursor(null,null,'advanced'));

SQL> start sqlt/run/sqltxtract.sql czuhk7qsk46kn  sqlt