????Oracle 10g?????????????????????????normal?????????tuning??????????????￡??????????normal????????CBO??normal????????С???????м??????????????????м????????????????????????????????????????????SQL?????н???????????м??????????????SQL?????ζ?????ü????м??????tuning??????????SQL???????????????????????????????????????????????????????飬????Oracle ????Automatic Tuning Optimizer??????????????????Oracle ???????????????SQL???????????SQL tuning advisor?????????

????1??SQL tuning?????????

????a???????????????????SQL????Top SQL

????b????????????м??

????c??????????????м???????SQLЧ??

????2?????tuning SQL

????a?????????????????????????????optimizer_mode??optimizer_index_caching??optimizer_index_cost_adj????????cache size??

????b?????SQL??????漰???????????????????????????б??????????????

????c?????????????????SQL??????????????·???????????????

????d?????????SQL????????SQL????Ч????С????????м???????????????????????????null???????????????????Ч??

????e???????????????????????????????????????I/O??

????3??Automatic Tuning Optimizer ??????

????a????????????

???????????м??????????????SQL????漰??????????????????????Щ????????Щ????????

?????????????????????????????????????????????Щ??????????????????????????????????????

???????????????????????Щ??????????????????Щ???????????????????????????????????report??

????b??????????·??

?????????????????SQL?????????·???????????????????????????????????裬?????????

?????????????????????ν??????????????????????????????????????????????????????????????????

????c??SQL??????

?????????????????Щ???н??????SQL??????????????????????????????????δ????????????д????????????????

????????????????????????????????ν???????????UNION??UNION ALL??????NOT IN?? NOT EXIST????滻???

???????м????????????????????Щ??????????

????d??SQL profiling

????SQL profiling ?????????????????????????????????????????????????SQL???????????????????????????????

?????????????????????????????????????sql profile??????????????????????ж????????

???????????????Щprofile???′δ???normal??????????sql??????????profile??

?????????profile??????????????????????????????????仯??profile?????????SQL???檔

????4??Automatic Tuning Optimizer??SQL tuning advisor???

????5??STA??tuning????

????STA??OEM??ν??????API???????tuning?????????????API??dbms_sqltune.create_tuning_task???

????????????create_tuning_task?????API???

????a???????SQL??????

????b?????ù?????е?SQL???sql_id??

????c??????awr????????????е?SQL???sql_id??

????d??????SQL???????????tuning??