Oracle中的SQL调优 [英] SQL tuning in Oracle
问题描述
有没有可用的文章/链接，可以在其中找到SQL调优(Oracle)的示例.如果用示例进行解释，那就太好了.我需要现有的查询，统计信息，计划，然后再提出建议的查询/建议和新计划.
Is there any article/link available where I can find examples of SQL tuning(Oracle). It would great if it is explain with example. I need something like existing query, statstics, plan and then suggested query/recommendation and new plan.
我在Google上找到了几个非常好的链接:
I found couple of really good links on google:
- http://www.dba-oracle.com/art_sql_tune.htm
- http://www.orafaq.com/tuningguide/
但是，我正在寻找具有上述详细信息的实时示例，这些文章中没有这些示例.
However I m looking for real time examples with above mentioned details, which are missing in these articles.
我希望我不要要求太多. :-)
I hope I m not asking for too much. :-)
推荐答案
快捷方式很少-可获得最佳效果:
There are few shortcuts - for best results:
- 购买基于费用 甲骨文基础知识"，乔纳森(Jonathan) 刘易斯
- 通过以下方式设置本地Oracle数据库 您完全可以控制
- 研究他的例子
- Purchase a copy of "Cost-Based Oracle Fundamentals" by Jonathan Lewis
- Set up a local Oracle database over which you have full control
- Work through his examples
这本书解释了优化器如何制定决策.
This book explains how the optimizer makes its decisions.
我不确定个人使用许可的含义，但是还学习了如何使用dbms_sqltune软件包-如果可以在正常的优化器路径上找到改进的计划，它将生成一份报告，以显示差异.通过查看这些信息，您可以收获很多.
I'm not sure of the licensing implications for personal use, but also learn how to use the dbms_sqltune package - in cases where it can find an improved plan over the normal optimizer path it will generate a report showing the differences. You can pick up a lot by looking at this information.
这篇关于Oracle中的SQL调优的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
