Databases Reference
In-Depth Information
Choose Memory Advisors from the links in the Advisors. This will take you to the next screen,
where you can see the AMM feature enabled and the memory space reserved for the Oracle
Database. A graph shows the history of memory allocation. In the next screenshot, you can
see this element in the Oracle Enterprise Manager:
Clicking on the Advice button next to the Total Memory Size, you can see a graph showing
the possible improvement in DB time for various sizes of Total Memory— this helps us choose
the right memory size to get the best performance. As we can see in the following screenshot,
over a certain threshold we cannot get a great improvement in DB time when we increase the
memory further.
