love wife & love life —Roger的Oracle&MySQL技术博客

Phone:18180207355 提供专业Oracle&MySQL数据恢复、性能优化、迁移升级、紧急救援等服务

Archive for the tunning Category

_optimizer_null_aware_antijoin引发的SQL性能问题

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags: , , , , ,
Posted in tunning on 四月 19, 2015 | There are currently No Comments

怪异的SQL执行计划

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags: , , , ,
Posted in tunning on 十月 20, 2014 | There are currently 7 Comments

about subquery unnest/push pred

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags:
Posted in tunning on 四月 28, 2013 | There are currently 1 Comment

flashback_transaction_query 查询慢的问题

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags: ,
Posted in tunning on 十一月 20, 2012 | There are currently 4 Comments

使用sql profle进行偷梁换柱的小例子–outline exchange(续)

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags: ,
Posted in tunning on 九月 16, 2012 | There are currently 3 Comments

使用sql profle进行偷梁换柱的小例子

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags:
Posted in tunning on 九月 13, 2012 | There are currently 2 Comments

stripe /block size/db_file_multiblock_read_count

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags: , , ,
Posted in tunning on 九月 1, 2012 | There are currently 1 Comment

10g中distinct加强以及anti jion,semi jion

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags:
Posted in tunning on 六月 20, 2012 | There are currently 2 Comments

一次3 node Rac tunning

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags: , ,
Posted in rac & dg, tunning on 六月 13, 2012 | There are currently 1 Comment

深入解析参数 OPTIMIZER_DYNAMIC_SAMPLING

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Posted in Oracle rdbms, tunning on 四月 12, 2012 | There are currently 4 Comments

一个SQL Tuning例子

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags:
Posted in Oracle rdbms, tunning on 二月 25, 2012 | There are currently 8 Comments

关于outline的一点测试和总结

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger的 […]

Tags:
Posted in Oracle rdbms, tunning on 七月 12, 2011 | There are currently No Comments