2013.12.10SQL性能优化

来源：互联网发布：java堆栈编辑：程序博客网时间：2024/06/14 08:15

Oracle中可被并行化执行的SQL操作

http://www.askmaclean.com/archives/oracle%E4%B8%AD%E5%8F%AF%E8%A2%AB%E5%B9%B6%E8%A1%8C%E5%8C%96%E6%89%A7%E8%A1%8C%E7%9A%84sql%E6%93%8D%E4%BD%9C.html

Oracle SQL性能优化专题

http://www.askmaclean.com/archives/oracle-sql-tuning.html

[Oracle]-[SORT AGGREGATE]-count与索引

http://blog.csdn.net/bisal/article/details/9138577

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 2 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 142 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 0.00 0.00 0 144 0 1

SQL trace

oracle 直方图谷歌

http://blog.itpub.net/22664653/viewspace-671681

索引的特性与优化

http://blog.csdn.net/zengmuansha/article/details/5224478

Oracle 优化器的执行计划了解（1）

http://blog.csdn.net/zengmuansha/article/details/7453805

http://blog.csdn.net/zengmuansha/article/details/7642642

说明一点要做好表信息分析收集工作

拨开Oracle优化器迷雾探究Histogram直方图之秘

https://blogs.oracle.com/askmaclean/entry/%E6%8B%A8%E5%BC%80oracle%E4%BC%98%E5%8C%96%E5%99%A8%E8%BF%B7%E9%9B%BE%E6%8E%A2%E7%A9%B6histogram%E4%B9%8B%E7%A7%98

Oracle 1053事件主要看是成本如何计算的?

http://blog.csdn.net/zengmuansha/article/details/7863558

【Oracle原厂Maclean技术分享】拨开Oracle CBO 优化

http://www.tudou.com/programs/view/TGvP2pIyvwI/

http://www.tudou.com/home/askmaclean/

Parallel execution 并行查询性能测试

http://f.dataguru.cn/thread-46694-1-1.html

oracle并行查询常用7问

http://tech.techweb.com.cn/archiver/tid-459066.html

并行测试为何并行比非并行慢

http://f.dataguru.cn/thread-46946-1-1.html

调整buffer cache 谷歌

http://blog.csdn.net/leshami/article/details/6208594

http://blog.itpub.net/22578826/viewspace-703517

http://www.bitscn.com/pdb/oracle/200604/19266.html

http://hi.baidu.com/lichangzai/item/6f6c3d8265a61eeae496e02a

0 0