Description of image file

This illustrates how materialized views work with the SQLAccess 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 SQLAccess Advisor.
From the SQL Cache, to the SQLAccess Advisor.
In addition, workload collection can go to the SQLAccess Advisor.
Also, Discoverer or a third-party tool can go to the SQLAccess Advisor.