优化sql的利器SQLT是怎么样的

优化sql的利器SQLT是怎么样的,相信很多没有经验的人对此束手无策,为此本文总结了问题出现的原因和解决方法,通过这篇文章希望你能解决这个问题。

创新互联公司专注于东山企业网站建设,响应式网站,商城网站开发。东山网站建设公司,为东山等地区提供建站服务。全流程按需策划设计,专业设计,全程项目跟踪,创新互联公司专业和态度为您提供的服务

优化sql的利器SQLT

Sqlt适用环境:

1、sql优化功底不是很深的同学

2、sql太复杂(2000行以上的SQL)

3、快速优化sql,不考虑业务逻辑

Setup SQLT Method

SQL> conn /as sysdba

SQL>@/home/oracle/sqlt/install/sqcreate.sql

Define SQLTXPLAIN password (hidden and case sensitive).

Password for user SQLTXPLAIN:

Re-enter password:

Default tablespace [UNKNOWN]: USERS <== hidden and case sensitive

Temporary tablespace [UNKNOWN]: TEMP <== hidden and case sensitive

Main application user of SQLT: doudou   <==administrator;grant SQLT_USER_ROLE

Oracle Pack license [T]:<==choose

SQCREATE completed. Installation completed successfully.

Remove SQLT Method

@/home/oracle/sqlt/install/sqdrop.sql

SQL> start sqltxtract.sql 0w6uydn50g8c <=SQL sql_id

Administrator privilege

grant connect,resource to doudou;

grant SQLT_USER_ROLE to doudou;

What is different SQLT XECUTE Method and SQLT XTRACT Method ?

SQLT XECUTE Method

? Pros

? Accurate 10053 (considers bind peeking)

? Plan execution statistics (sets STATISTICS_LEVEL=ALL)

? Actual Execution Plan (may be different than explain plan)

? Invokes SQL Tuning Advisor

? No need to know, or get before hand, hash_value or sql_id

? 10046 trace and Trace Analyzer (if installed)

? Cons

? SQL is executed (may take long time)

? Need to know the values of bind variables

SQLT XTRACT Method

? Pros

? Child plans and plan statistics (if STATISTICS_LEVEL=ALL)

? Actual Execution Plan (may be different than explain plan)

? Invokes SQL Tuning Advisor

? SQL is not executed

? No need to know the values of bind variables

? Easy to execute (if hash_value or sql_id are known)

? Cons

? 10053 is generated based on EXPLAIN PLAN FOR (may not

be accurate due to binds peeking)

? Requires to know, or get before hand, hash_value or sql_id

优化SQL的又一利器SQLT(SQLTXPLAIN),SQLT把收集的信息和建议方法都形成了html(main.html;readme.html;lite.html)格式,方便用户查看!

Main.html:SQLT给出了收集的信息和调优建议

Readme.html:SQLT给出了具体优化的方法

Lite.html:SQLT给出了简易的PLANS信息 

 Document 215187.1

看完上述内容,你们掌握优化sql的利器SQLT是怎么样的的方法了吗?如果还想学到更多技能或想了解更多相关内容,欢迎关注创新互联行业资讯频道,感谢各位的阅读!


新闻标题:优化sql的利器SQLT是怎么样的
标题URL:http://scyanting.com/article/jpspdg.html