Oracle PL/SQL性能调优速成课程 [英] Oracle PL/SQL performance tuning crash course

问题描述

我是一位Java专家，对基本SQL和PL/SQL都很熟悉.我可以编写简单的过程和函数.现在，我期望进行一些Oracle性能调整.有人可以帮我提供一些速成课程资料吗?提前致谢.

I am a Java guy who is familiar to basic SQL and PL/SQL. I can write simple procedures and functions. Now, I am expected to do some Oracle performance tuning. Can anyone help me with some crash course material? Thanks in advance.

-Siddharth

--Siddharth

推荐答案

如果您想了解有关SQL性能调整的更多信息，则需要了解oracle提示以及如何检查查询的解释计划:

If you want to know more on SQL preformance tuning, then you need to know the oracle hints and how to check the explain plan of the query:

http://www.adp-gmbh.ch/ora/sql/hints/index.html

其他与性能相关的重要事情是分析功能

Other important performance related things are the analytical functions

http://www.adp-gmbh.ch/ora/sql/analytical/index.html

如果您对Oracle特定选项更感兴趣，这将很有用.如果您通常对性能调优感兴趣，则其他答案可能会更有用

This can be useful if you are interested more in Oracle Specific options. The other answers might be more useful if you are generally interested in performance tuning

这篇关于Oracle PL/SQL性能调优速成课程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！