Database Reference
In-Depth Information
Figure 11-13: Memory Parameters page showing PGA management
area. When Oracle Instance starts the PGA gets created.
SQL Access Advisor
The SQL Access Advisor provides recommendations in terms of
indexes, materialized views and partitions to achieve better
performance. Materialized views, partitions, and indexes are
necessary in tuning the database as they help in fast execution of
complex, data intensive SQL statements. SQL Access Advisor
can be accessed through Advisor Central page. The link to
Advisor Central page is located on Home page under Related
Links section as shown in Figure 11-3.
Search WWH ::
Custom Search