|
lovehewenyu 发表于 2013-8-26 16:19 ![]()
浙江移动升级(7套RAC升级,目前全国最大的升级案例)
http://www.itpub.net/thread-1809842-1-1.html
LZ有心了
补充一下,前面提到的COE的脚本,我相信SQLT里的一些脚本肯定会用到的
SQLT:
SQLT (SQLTXPLAIN) - Tool that helps to diagnose a SQL statement performing poorly or one that produces wrong results (Doc ID 215187.1)
特别是
coe_xfr_sql_profile.sql
Using Sqltxplain to create a 'SQL Profile' to consistently reproduce a good plan (Doc ID 1487302.1)
和
coe_load_sql_profile.sql or coe_load_sql_baseline.sql
How to use hints to customize SQL Profile or SQL PLAN Baseline (Doc ID 1400903.1)
有兴趣的童鞋可以看下
outline基本可以扔了 |
|