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 ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
