love wife love life —Roger的Oracle/MySQL/PostgreSQL数据恢复博客

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

Archive for the tunning Category

_optimizer_null_aware_antijoin引发的SQL性能问题

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

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

怪异的SQL执行计划

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

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

about subquery unnest/push pred

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

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

flashback_transaction_query 查询慢的问题

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

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

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

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

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

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

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

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

stripe /block size/db_file_multiblock_read_count

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

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

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

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

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

一次3 node Rac tunning

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

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

深入解析参数 OPTIMIZER_DYNAMIC_SAMPLING

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

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

一个SQL Tuning例子

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

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

关于outline的一点测试和总结

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

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