Does anyone has sql tuning tools for oracle recommendation? thanks

"abby" <redmfree (AT) yahoo (DOT) com.hk> wrote

Which version of Oracle ? For 10g, there are some built-in tools like AWR
and ADDM (look for it in the docs). For 9i, you can use Enterprise Manager
with the Tuning Packs (note : separately licensed)
Third-party tools like Quest's TOAD also have some extra modules to do SQL
tuning.

However, the best thing is to learn it yourself with sql trace, tkprof and a
good book


HTH
Matthias