Archive for the tunning Category

_optimizer_null_aware_antijoin引发的SQL性能问题

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

Tags: 11gR2, filter, hash, hash anti join, hash join, _optimizer_null_aware_antijoin
Posted in tunning on 四月 19, 2015 | There are currently No Comments

怪异的SQL执行计划

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

Tags: 10053 event, dbms_stats, filter, NESTED LOOPS SEMI, oracle sql tuning
Posted in tunning on 十月 20, 2014 | There are currently 7 Comments

about subquery unnest/push pred

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

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

flashback_transaction_query 查询慢的问题

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

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

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

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

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

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

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

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

stripe /block size/db_file_multiblock_read_count

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

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

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

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

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

一次3 node Rac tunning

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

Tags: gc buffer busy, gc cr multi block request, gc current block busy
Posted in rac & dg, tunning on 六月 13, 2012 | There are currently 1 Comment

深入解析参数 OPTIMIZER_DYNAMIC_SAMPLING

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

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

一个SQL Tuning例子

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

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

关于outline的一点测试和总结

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

Tags: outline 测试总结
Posted in Oracle rdbms, tunning on 七月 12, 2011 | There are currently No Comments

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

Categories

Archives

最新评论

国内圈子

oracle security

功能

Archive for the tunning Category

_optimizer_null_aware_antijoin引发的SQL性能问题

怪异的SQL执行计划

about subquery unnest/push pred

flashback_transaction_query 查询慢的问题

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

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

stripe /block size/db_file_multiblock_read_count

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

一次3 node Rac tunning

深入解析参数 OPTIMIZER_DYNAMIC_SAMPLING

一个SQL Tuning例子

关于outline的一点测试和总结