O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Avoiding Advisor Pitfalls

You may have noticed that the approach taken by the advisors is very similar to that used by a performance analyst. For example, when the SQL Tuning Advisor is invoked, it checks for the presence of valid and up-to-date object statistics. It then performs access path analysis such as checking for the presence of appropriate indexes. The SQL Access Advisor performs a similar task while looking for opportunities to create materialized views and to utilize the query-rewrite facility. In other words, the advisors automate what a human would do. Hence, when used incorrectly or without a complete understanding of the application and environment, the advisors suffer from the same shortfalls and mistakes that a human would be ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required