Description of the illustration pfgrf225.eps

This figure illustrates how materialized views work with the SQL Access Advisor:

First, data is in a warehouse. The warehouse includes materialized views and workloads.
From the warehouse, data goes to the trace log and the SQL cache.
From the trace log, to Oracle Trace Manager, then to the SQL Access Advisor.
From the SQL cache, to the SQL Access Advisor.
In addition, workload collection can go to the SQL Access Advisor.
Also, a third-party tool can go to the SQL Access Advisor.