emperor_majesty的博客_Tuning

dbms_xplan.display_cursor

Use tools dbms_xplan.display_cursor() to see the cursor in library cache in shared pool.

xplan

display_cursor

原创 2013-03-03 13:59:56 1027 阅读

Using Hint

Use hint to change access path or join method. You may be familiar with join method, more examples, more understand. to be continue......

sql tuning

using hint

hint

原创 2012-07-13 13:50:12 516 阅读

Oracle Outline

create outline to stable the excution plan.

oracle

outline

原创 2012-07-07 17:37:42 747 阅读

sqltuning bind variable

run the shell, watch the result, what do you see, why?

bind variable

sql tuning

原创 2012-07-05 20:22:32 521 阅读

Materialized View

basic of Materialized View

Materialized View

原创 2012-07-04 18:14:59 632 阅读

opitimizer statistic

after gather statistic, oracle optimizer could make a right decide.

opertimizer

statistic

原创 2012-06-14 18:30:51 472 阅读

Composite Index

the usage of composite index.

index

原创 2012-06-12 13:09:33 424 阅读

Tuning PGA

tuning PGA for sql statement.

tuning

原创 2012-06-04 14:26:54 482 阅读

官方博客	全部文章	热门标签	班级博客
了解我们	网站地图	意见反馈

鸿蒙开发者社区	51CTO学堂
51CTO	软考资讯

51CTO博客

Oracle+Linux=>Majesty

dbms_xplan.display_cursor

Using Hint

Oracle Outline

sqltuning bind variable

Materialized View

opitimizer statistic

Composite Index

Tuning PGA

欢迎