Using Memory Advisor through
Automatic Shared Memory Management has
to be disabled to run the advisor. Choose shared pool or
buffer cache and click Advice next to it.
Figure 6.3 - Memory Advice
The corresponding graphs appear as shown
For Shared Pool size, the graph
Figure 6.4 - Memory Advice
Figure 6.5 - Memory Advice
For Buffer Cache, the graph
that a buffer
cache size larger than 52MB will not improve the performance
either. A bigger cache prompts less disk reads and
improves the performance. See Guru Conversation for more details .
To run the PGA Advisor, click on the PGA
property page. This is similar to running the SGA advisors.
Cache hit percentage is plotted against memory size. Higher hit
ratios in the range of 75% to 100% indicate better cache
Figure 6.6 - PGA Memory
Figure 6.7 - PGA Memory