SQL Access Advisor allows DBAs and developers to analyze individual SQL statements, SQL tuning sets or the entire system and recommend materialize views, partitioning and indexes on tables. There are two interfaces of SQL Access Advisor: Oracle Enterprise Manager and DBMS_ADVISOR package. The Oracle Enterprise Manager interface is easy and user-friendly, but DBMS_ADVISOR package provides the same recommendations from SQL*Plus, which is useful in environments that do not have OEM installed. SQL Access Advisor is a part of the Oracle Tuning Pack, which also requires the Diagnostic Pack.
Viewing entries tagged
SQL tuning sets