Understanding Memory Advisor
The Memory Advisor helps you tune the size of your memory structures. You can use the Memory Advisor only when automatic memory tuning is disabled in the database. When ASMM is disabled, the Memory Advisor is responsible for optimizing system memory for the database instance. Using the Memory Advisor, you can let Oracle tune the memory according to the database needs or use the SGA Advisor or the PGA Advisor to set the total size of the SGA or PGA and optimal values for their components.
The Memory Advisor consists of three advisors to give you recommendations on shared pool (SGA), buffer cache (SGA), and PGA. The main components of the shared pool are the library cache and the dictionary cache. The library cache ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
