Once the optimization is done, the SQL Tuning
Advisor makes recommendations, which could include updating statistics, adding
indexes, or creating a SQL profile. This profile is stored in the database and is used as
the optimization plan for future executions of the statement, which allows you to
???fix??? errant SQL plans without having to touch the underlying SQL.
The tool is often used along with the SQL Access Advisor since that tool provides
advice on materialized views and indexes. Oracle Database 11g introduces a SQL
Advisor tool that combines functions of the SQL Tuning Advisor and the SQL
Access Advisor (and now includes a new Partition Advisor). The Partition Advisor
component advises on how to partition tables, materialized views, and indexes in
order to improve SQL performance.
Data Dictionary Tables
The main purpose of the Oracle data dictionary is to store data that describes the
structure of the objects in the Oracle database. Because of this purpose, there are
many views in the Oracle data dictionary that provide information about the
attributes and composition of the data structures within the database.
Pages:
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281