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

SQL Advisors

For SQL tuning, Oracle Database 10g has two advisors: SQL Tuning Advisor and SQL Access Advisor. SQL Tuning Advisor provides tuning advice for SQL statements without modifying any SQL statements. SQL Access Advisor provides tuning advice on indexes, materialized views, and materialized view logs for larger reports or work load. Both advisors are available through OEM. Rule Based Optimizers are completely de-supported in Oracle Database 10g, and these SQL advisors could help to a certain extent in rewriting your old RBO queries and taking advantage of Cost Based Optimization (CBO).

SQL Tuning Advisor takes one or more SQL statements as its input and invokes the automatic tuning optimizer to perform SQL tuning. The output is a series ...

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